Excel 2016 formulas and functions

Getting the most out of ranges

Using range names

Building basic formulas

Creating advanced formulas

Troubleshooting formulas

Understanding functions

Working with text functions

Working with logical and information functions

Working with lookup functions

Working with date and time functions

Working with math functions

Working with statistical functions

Analyzing data with tables

Analyzing data with PivotTables

Using Excel's business modeling tools

Using regression to track trends and make forecasts

Solving complex problems with Solver

Building loan formulas

Building investment formulas

Building discount formulas.