DpApr 22, 20181 min"Concatenate" Function In ExcelThis function joins separate pieces of text into one item. Syntax: =CONCATENATE(Text1,Text2,Text3...Text30) Example: Here is the video...
DpApr 22, 20181 min"Clean" Function In ExcelThis function removes any nonprintable characters from text. These nonprinting characters are often found in data which has been imported...
DpApr 22, 20181 min"Combin" Function In ExcelThis function calculates the highest number of combinations available based upon a fixed number of items. This is nothing but the...
DpApr 22, 20181 min"Average" Function in ExcelThis function calculates the average from a list of numbers. If the cell contains zero 0, the cell will be included in the average...
DpApr 22, 20181 minAutosum In ExcelInstead of using the Autosum function or the button from the toolbar You can press Alt and = to achieve the same result Just you have to...
DpApr 22, 20181 min"AND" Function in ExcelThis function tests two or more conditions to see if they are all true. It can be used to test that a series of numbers meet certain...
DpApr 21, 20181 minShow only some portion of Excel sheetExcel Sheet has 2^20 Rows and 2^14 Columns. Instead of Using the blank cells appearing. It is better to hide all the unwanted blank...
DpApr 21, 20182 minHow to Change the Calender in Primavera in the middle of the projectHi, Lets see How we can change the Calendar once the schedule is prepared. As per the Scheduling Philosophy, Calendar has to be set...
DpApr 21, 20181 minExport Schedule from Primavera P6 to ExcelLets see How to export the P6 Schedule in to Excel in an easy way. Step 1: First Open the schedule and go to Activities layout, Which you...