Excel Usefuls

Use Round function to round a number to a specific number of digits. You can apply the Round function to the whole part or to the decima...

Description: In a database or list, the DAVERAGE function averages the values in a field column from the set of records that matches t...

In Excel, all dates are stored as integers (Integer 1 represents January 1, 1900, integer 2 represents January 2, 1900, and so on). As the...

Excel 2007 - 347 functions Add-in and Automation functions (5) CALL EUROCONVERT GETPIVOTDATA REGISTER.ID SQL.REQUEST Cube funct...

1 How to drag the cells for making a selection? 2 Selecting a range by using the shift and arrow keys 3 Selecting the current region 4 Se...