Mastering Excel Formulas and Functions: Seven Hour Course

Learn to create and use formulas in Excel as well as use Excel's own built-in functions to perform calculations.

Use a guide that provides instructions for every step that you will take in setting up and using the most popular formulas and functions in Excel. This book makes extensive use of screenshots to illustrate the various stages of each task.

You will learn to perform the various calculations in Excel:

• Making simple arithmetic calculations
• Using the Auto-Sum, Average, Max, Min, and Count Functions
• Absolute versus Relative Referencing in Formulas and Functions
• Using the AverageIF, SumIF, and CountIF Functions
• Employing VLOOKUP and IF Functions
• Combining two functions: IF and AND, IF and OR
• Using TEXT functions: UPPER, LOWER, PROPER, and CONCATENATE