The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios.

Topics include:
* Displaying and highlighting formulas
* Converting formulas to values
* Creating 3D formulas to gather data from multiple sheets
* Understanding the hierarchy of operations in formulas
* Using absolute and relative references
* Creating and expanding the use of nested IF statements
* Looking up information with VLOOKUP, MATCH, and INDEX
* Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
* Analyzing data with the statistical functions
* Performing basic math
* Calculating dates and times
* Editing text with functions
* Checking for errors with formulas

Download Links :