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 OverviewThe 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 BenefitsThe 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.
- 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.
01 Sort and Filter PowerPivot Data.
02 Save Reports in Different File Formats.
03 Refresh Data from a Data Source.
04 Protect Reports.
05 Present PivotTable Data Visually.
06 Organize and Format Tables.
07 Manipulate Power Pivot Data Using DAX Functions.
08 Import Data from Various Data Sources.
09 Filter Data Using Slicers.
10 Extract Data from Tables Using Functions.
11 Enable and Navigate.
12 Create Power Views.
13 Create PivotTables.
14 Create PivotCharts.
15 Create Linked Tables.
16 Create Calculated Columns.
17 Create and Manage Table Relationships.
Complete This CPD Accredited Course & Get Your Framed Certificate!
Certify Your Skills
A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.
Stand Out From The Crowd
Add your Adams Certification to your resume and stay ahead of the competition.
Advance in Your Career
Share your Adams Certification with potential employers to show off your skills and capabilities.
About Course Publisher
Training Express is a leading course provider, established by a dedicated team of experts working across the UK. We deliver accredited certification and training to UK businesses looking to improve organisational performance. Our comprehensive courses cover a broad range of sectors and industries, with a focus on promoting high standards of food hygiene, business wellbeing and safety in the workplace.