Data Proofing, Save, Language and Ease of Access settings
Data Proofing Data Proofing in excel is a tool to test alphanumeric errors within the written material of the document. …
Data Proofing, Save, Language and Ease of Access settings Read More »
Date and Time Functions in Microsoft Excel
Date Function Date function is useful when you want to combine three values into one cell to form a date. …
Decimal Places and Percentage
Formatting Numbers to Percentages Suppose that we are working on a data set containing decimal values needed to be converted …
Power Function
Test Yourself The function “Power()” returns the result of a number raised to a certain power. Let’s have a look …
Modulus Function in Excel
Test Yourself The MOD() function in excel helps in returning the remainder when a particular number is divided by a …
Conditional Formatting _ Custom Number Formatting in Excel
Conditional Formatting Conditional formatting allows you to help visualize, explore and analyze data. It can help you to detect critical …
Conditional Formatting _ Custom Number Formatting in Excel Read More »
Combining Index and Match in Microsoft Excel
If you have come here to read about how to combine Index and Match function in Excel to produce meaningful …
Choosing the Right charts for effective presentation of your data
How to select the appropriate chart best suited for your data type? There are a lot of ways of representing …
Choosing the Right charts for effective presentation of your data Read More »
Subtotal Function
Test Yourself The SUBTOTAL function can return an SUM, AVERAGE, COUNT, MAX, and other values, and it can include or …
Average Function
Test yourself Understanding AVERAGE Formula The AVERAGE function in Excel returns a average number of all values given in a …
