Microsoft Excel: CHOOSE() & OFFSET() function
CHOOSE () function The CHOOSE function in excel returns a value from a list using the given index position of …
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 …
Anchoring and Grouping Cells
How to Anchor formatting cells? Anchor Formatting Cells Have you ever experienced erroneous results and copying and pasting your formula? …
SUM FUNCTION
Test Yourself Understanding Sum Function In Excel, we use the SUM function to total of values in a specified range …
