This course builds on the concepts highlighted in the Basic Excel class.
Advanced Excel covers the following topics:
Advanced Excel covers the following topics:
- Creating and editing charts
- Creating conditional formatting
- Importing data into Excel
- Data cleaning tips and tricks
- Calculating discounted cash flows
- Customizing PivotTables and PivotChart reports
- Formatting dates, time, and text
- Using Excel’s What-if Analysis
- Using Excel’s statistical functions to identify outliers
- Other time-saving tips and techniques