adams-academy-logo
Explore Courses
Get Certificate
Discover Careers
More

Microsoft Excel 2016 PowerPivot

(4 students)

This course includes:

07:55:00 hours

CPD Accreditation

17 units

Full lifetime access

Access on mobile and TV

Certificate of completion

Share:
Training Express
Course Publisher

Training Express

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.
Course content

Microsoft Excel 2016 PowerPivot

01 Sort and Filter PowerPivot Data.

00:29:00

02 Save Reports in Different File Formats.

00:21:00

03 Refresh Data from a Data Source.

00:16:00

04 Protect Reports.

00:35:00

05 Present PivotTable Data Visually.

00:46:00

06 Organize and Format Tables.

00:32:00

07 Manipulate Power Pivot Data Using DAX Functions.

00:33:00

08 Import Data from Various Data Sources.

00:39:00

09 Filter Data Using Slicers.

00:19:00

10 Extract Data from Tables Using Functions.

00:19:00

11 Enable and Navigate.

00:24:00

12 Create Power Views.

00:30:00

13 Create PivotTables.

00:41:00

14 Create PivotCharts.

00:21:00

15 Create Linked Tables.

00:14:00

16 Create Calculated Columns.

00:17:00

17 Create and Manage Table Relationships.

00:39:00

Complete This CPD Accredited Course & Get Your Framed Certificate!

vector

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.

Certificate Promo

About Course Publisher

Training Express
Training Express

185 Courses

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.

Adams Academy Logo

At Adams Academy, we're reinventing the online learning landscape by creating an immersive global platform with a wide range of engaging and top-notch courses. Our thriving learner and course provider community accommodates many interests and academic levels, building a culture where curiosity flourishes and potential is awakened.

Beaufort House, 15 St Botolph Street, London EC3A 7BB
Adams Learning facebook profile - /adamsacademylive
Twitter
Instagram
Linkedin
Google
Youtube
Youtube

© 2023 Adams Academy Inc. All rights reserved.