Microsoft Office - Excel: Introduction to Power Pivot

Content
2 modules
Difficulty
Intermediate
Rating
Course Length
70 mins
Instructor
Pantry of Knowledge

Description

Learn how to transform Excel into your big data power tool Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. In this course we’ll show you everything you need to know in order to install and use Power Pivot in Excel. We strongly recommend you take our “Mastering Excel” courses before you proceed with Power Pivot, unless you are already comfortable with advanced Excel topics including basic PivotTables.

Objectives

  • Enable the Power Pivot add-in and navigate its interface
  • Manage Data Relationships
  • Create a Power Pivot Report
  • Create calculations in Power Pivot
  • Create a Key Performance Indicator
  • Work with dates and time in Power Pivot

Certificate

By completing/passing this course, you will attain the certificate POK Microsoft Skills Certificate

Learning Credits

CEU
1.25

Badges

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value') }}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved_for_selected_score_and_over')}}

{{ vm.percentage_badges[vm.selected_badge].greater_than_or_equal }}%

{{ badge.name }}

{{ vm.helper.t('lup.gamification.value')}}

{{ badge.points }} {{ vm.helper.t('lup.gamification.points') }}

{{ vm.helper.t('lup.gamification.achieved') }}

{{ vm.helper.t('lup.gamification.learning_awards.on_course_completion') }}
1.
Microsoft Office - Excel: Introduction to Power Pivot
{{ vm.helper.t('courses.scorm') }}
2.
Microsoft Office - Excel: Introduction to Power Pivot Survey
{{ vm.helper.t('courses.survey') }}
Currently no reviews submitted

Shopping Cart

Your cart is empty