We will begin this course with an introduction to functions and formulas, including logical and conditional functions, financial and statistical functions, and date/time and arrays.
Then we’ll move onto lookups and data tables, during which we will also discussing validating cells, filtering, charting, and graphics.
Next you will learn about PivotTables, including how to work, modify, format, and use them, as well as exporting, importing, and modifying data. We will also cover the PowerPivot.
Lastly, we will cover analytical tools, including goal seek, scenarios, solver, and instant data analysis.