The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
- Create an Excel report
- Create an Excel table
- Create a pivot table and pivot chart
- Create a dashboard and analyze data
- Create Hierarchies
- Create an Excel data model and connect to external data