Use appropriate names for columns and worksheets in a workbook. In case you aren’t using the latest features, you should save your files in 2003 *.xls format for backwards compatibility. Save the workbook with compatibility in mind.
#Free online tutorial for excel 2013 free
Let us understand some of the best practices to be followed while using Excel that will be taught to you in free excel courses.
#Free online tutorial for excel 2013 series
=COUNT() – Helps in counting the number of cells in a series =VLOOKUP() – Helps in looking for a value that is in the leftmost column of a table =AVERAGE() – Calculates the average value of a series of cells =IF() – Checks if the specified condition is met and returns a particular value if YES and a particular value if NO There are hundreds of functions that can be used in Excel, but in this free excel tutorial for beginners, let us understand some of the basic and most widely used functions.