The statistical functions of MS Excel can come useful to a person who is dealing with a lot of data that is numerical in nature. Here, we will look at two functions that are variations of the AVERAGE function in excel. Statistical Functions – AVERAGEA This function can be used to calculate the average value …
AVERAGEA and AVERAGEIF: Statistical Functions in MS Excel Read More »
Reference functions are those that are used to refer to other cells in a given sheet. In this article we will talk about two important reference functions- ADDRESS and INDIRECT. Reference Functions – ADDRESS Preetam has an excel sheet. He wants to make a reference to another cell in one of his cells. How can …
ADDRESS and INDIRECT: Reference Functions in MS Excel Read More »
Some functions in Excel can be used to give the sheet a formal look. In this module we will look at two such functions. ROUND is a Math & Trig Function that can be used to round off decimal numbers to nearest whole number and PROPER is a Text Function is a function that capitalizes …
DATE, DATEVALUE and EDATE are basic ‘Date & Time Function’ in Excel. This module will look at the differences between the three and where each one of these can be used. Date & Time Function – DATE Meryl has the following spreadsheet in which she wants to insert the birthdates for her classmates. She can …
DATE, DATEVALUE and EDATE: Date and Time Functions in Excel Read More »
What is Conditional Formatting? Conditional Formatting is an option available in Excel that allows one to highlight the trends in a range. Doing this will help one spot important and necessary values easily. Where is the Conditional Formatting option Present? It can be found in the ‘Styles’ group of ‘Home’ menu in an Excel sheet. …
Conditional Formatting in Microsoft Excel – Free Excel Tutorials Read More »