Instruction 1: Learning Outcomes
- Create and manage table relationships in PowerPivot.
- Form calculated columns and linked tables in PowerPivot.
- Assemble PivotCharts and PivotTables to analyse data.
- Enable and navigate PowerPivot to extract data from tables.
- Use functions to filter and manipulate PowerPivot data.
- Organise and format tables for effective data presentation.
- Protect and refresh reports in different file formats.
Course Overview
The Microsoft Excel 2016 PowerPivot course is devised to assist you in becoming proficient in using this powerful tool to analyse and manipulate data. In this course, you will learn how to create and manage table relationships, create calculated columns, and import data from various sources.
The course covers creating PivotTables and PivotCharts, enabling and navigating PowerPivot, and filtering data using slicers. You will also learn how to organise and format tables for effective data presentation and protect and refresh reports in different file formats. By the end of the course, you will have the wisdom, methods and techniques to use PowerPivot to analyse and manipulate data like a pro.
Course Benefits
The Microsoft Excel 2016 PowerPivot course provides numerous benefits to individuals seeking to improve their data analysis skills. This course teaches you how to create and manage table relationships, import data from various sources, and manipulate data using functions. You can also create PivotTables and PivotCharts and filter data using slicers.
You can create professional-looking reports by organising and formatting tables for effective data presentation. You will also learn how to protect and refresh reports in different file formats. With the methods and knowledge learned in this course, you will be able to analyse and manipulate data efficiently and effectively using PowerPivot.
Career Path
- Data Analyst – Uses data analysis tools, including PowerPivot, to analyse and manipulate organisational data.
- Business Intelligence Analyst – Analyzes business data and develops strategies to improve organisational efficiency using PowerPivot.
- Financial Analyst – Analyzes financial data using PowerPivot to provide insights and recommendations to organisations.
- Database Administrator – Manages and maintains databases, including PowerPivot, for organizations.
- Reporting Analyst – Develops and presents reports using PowerPivot to communicate insights and recommendations to organisations.
- Marketing Analyst – Analyzes marketing data using PowerPivot to provide insights and recommendations to organisations.
- Operations Analyst – Analyzes operational data using PowerPivot to provide insights and recommendations to organisations.