Microsoft Excel
Use Excel as a serious analytics tool, from clean data to automated reports.
- Data cleaning and formatting
- Functions: IF, VLOOKUP, INDEX-MATCH, XLOOKUP
- Pivot Tables and Pivot Charts
- Charts and dashboards
- Data validation and error handling
- Introduction to Macros