0
Explore Courses
Get Certificates
Discover Careers
More

Microsoft Excel 2016 PowerPivot

(12 students)
coureseImg
Start Now -It's Free

This course includes:

  • list-favs7 hours, 55 minutes
  • list-favsCPD Accreditation
  • list-favs17 units
  • list-favsFull lifetime access
  • list-favsAccess on mobile and TV
  • list-favsCertificate of completion
publisher
course plublisher
Course Cloud

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

cirrtitle Microsoft Excel 2016 PowerPivot

  • video Module 01 Sort and Filter PowerPivot Data.
    00:29:00
  • video Module 02 Save Reports in Different File Formats.
    00:21:00
  • video Module 03 Refresh Data from a Data Source.
    00:16:00
  • video Module 04 Protect Reports.
    00:35:00
  • video Module 05 Present PivotTable Data Visually.
    00:46:00
  • video Module 06 Organize and Format Tables.
    00:32:00
  • video Module 07 Manipulate Power Pivot Data Using DAX Functions.
    00:33:00
  • video Module 08 Import Data from Various Data Sources.
    00:39:00
  • video Module 09 Filter Data Using Slicers.
    00:19:00
  • video Module 10 Extract Data from Tables Using Functions.
    00:19:00
  • video Module 11 Enable and Navigate.
    00:24:00
  • video Module 12 Create Power Views.
    00:30:00
  • video Module 13 Create PivotTables.
    00:41:00
  • video Module 14 Create PivotCharts.
    00:21:00
  • video Module 15 Create Linked Tables.
    00:14:00
  • video Module 16 Create Calculated Columns.
    00:17:00
  • video Module 17 Create and Manage Table Relationships.
    00:39:00
cert

Certify Your Skills

A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.

cert

Stand Out From The Crowd

Add your Adams Certification to your resume and stay ahead of the competition.

cert

Advance in Your Career

Share your Adams Certification with potential employers to show off your skills and capabilities.

cert

About Course Publisher

Course Cloud
courseCount Courses

Unlock your potential with Course Cloud, the UK's leading online provider of career-enhancing skills. With everything from IT and business to healthcare and skilled trades, our diverse range of courses are researched diligently and accredit-rated. Enjoy interactive, self-paced learning through diverse formats that include instructor-led sessions, multimedia lessons and expansive study material. You could be the next to power your career with us. Don't miss out on the opportunity of learning anything at any place with unprecedented flexibility through courseware available on any device. With dedicated tutor support, Course Cloud assures a learning journey that is not just informative but transformative. Join us in taking the first step towards achieving your career aspirations. Request the information today in English (UK) language.

More Free Online Courses by This Publisher

cert

Certificate

Learn MySQL from Scratch for Data Science and Analytics
book 88 Lessons std 30 Students
cert

Certificate

Complete Python from Scratch: Start your career in Python 3+
book 60 Lessons std 28 Students
cert

Certificate

Microsoft SQL Server Bootcamp 2022
book 88 Lessons std 17 Students
cert

Certificate

Email Marketing for Beginners
book 18 Lessons std 19 Students
cert

Certificate

Master JavaScript with Data Visualization
book 76 Lessons std 31 Students