Average Function
Test yourself Understanding AVERAGE Formula The AVERAGE function in Excel returns a average number of all values given in a …
practice excel online
Calculating Date Differences in Excel
DATEDIF function in Microsoft Excel Calculating DATE differences We can calculate the no. of days, weeks, months & years by …
Basic Macros Tutorial in Microsoft Excel
What are Macros? A macro in computer science is a rule or pattern that specifies how a certain input sequence …
AND _ OR functions in Excel
How to use AND operation in Excel AND function is a conditional function which returns only two values, either TRUE …
Absolute Function (ABS)
Test Yourself Understanding Absolute (ABS) Formula The ABSOLUTE function in Excel returns a number’s absolute value i.e negative numbers are …
MAX FUNCTION
test yourself Understanding Max Formula MAX formula is used when we want to find the maximum value within a range …
COUNT FUNCTION
Test Yourself Understanding Count Formula In Excel, we use the COUNT function to count numeric values in a specified range …
SUM FUNCTION
Test Yourself Understanding Sum Function In Excel, we use the SUM function to total of values in a specified range …
