Velsoft Training Materials
Search
Client Login

Microsoft 365 Excel: Power Pivot

DOWNLOAD A FREE SAMPLE

FREE SAMPLE

$495.00

power pivot course

Microsoft 365 Excel Power Pivot, a complimentary add-in, significantly amplifies the functionalities of PivotTables by seamlessly integrating advanced calculations. Beyond this enhancement, it empowers users with the capability to import and process substantial datasets from diverse sources, both internal and external to Excel.

In this comprehensive course, participants will explore the various facets of the Microsoft 365 Excel: Power Pivot interface, gaining proficiency in manipulating and visually presenting Power Pivot data. The curriculum encompasses creating dynamic Power Pivot reports, unraveling the intricacies of Data Analysis Expressions (DAX) functions, and mastering strategies for the efficient distribution of Power Pivot data. Whether delving into interface features, honing data manipulation techniques, or understanding the intricacies of DAX functions, this course offers a holistic approach to harnessing the full potential of Power Pivot for robust data analysis and reporting.

About This Course

Course Prerequisites

Course Overview

Course Objectives

How To Use This Book

Lesson 1: Getting Started with Power Pivot

TOPIC A: Enable and Navigate Power Pivot

The Power Pivot Add-in

The Power Pivot Window

The Power Pivot Ribbon Interface

Power Pivot Worksheets

Activity 1-1: Exploring Power Pivot

TOPIC B: Import Data from Various Sources

Power Pivot Data Sources

Data Feeds

The Table Import Wizard

Data Types

How to Import Data From Various Data Sources

Activity 1-2: Importing Data from an Access Database

TOPIC C: Refresh Data from a Data Source

Data Refresh

Connections

Refresh Data from a Data Source

Activity 1-3: Refreshing Data from an Access Database

TOPIC D: Create Linked Tables

Linked Tables

How to Create Linked Tables

Activity 1-4: Creating Linked Tables

Summary

Review Questions

Lesson 2: Manipulating Power Pivot Data

TOPIC A: Managing Tables

Power Pivot Tables

How to Organize and Format Tables

How to Manipulate Columns in a Table

Activity 2-1: Managing Tables

TOPIC B: Creating Calculated Columns

Calculated Columns

Power Pivot Formulas

How to Create Calculated Columns

Activity 2-2: Creating Calculated Columns

TOPIC C: Sort and Filter Power Pivot Data

Sort Options

Filter Options

How to Sort and Filter Power Pivot Data

Activity 2-3: Sorting and Filtering Power Pivot Data

TOPIC D: Create and Manage Table Relationships

Table Relationships

Types of Relationships

The Create Relationship Dialog Box

The Manage Relationships Dialog Box

The Diagram View

How to Create and Manage Table Relationships

Activity 2-4: Creating and Managing Table Relationships

Summary

Review Questions

Lesson 3: Visualizing Power Pivot Data

TOPIC A: Create PivotTables

PivotTables

Flattened PivotTables

Create a Pivot Table from Power Pivot

The PivotTable Fields Pane

How to Create a PivotTable

Activity 3-1: Creating a PivotTable

TOPIC B: Create PivotCharts

PivotCharts

PivotChart Types

How to Create PivotCharts

Activity 3-2: Creating PivotCharts

TOPIC C: Create Key Performance Indicators (KPIs)

Create Measures

Add Measures to a PivotTable

Create KPIs

Manage KPIs

Delete KPIs

Activity 3-3: Create KPIs

TOPIC D: Filter Data Using Slicers

Slicers

How to Filter Data Using Slicers

Activity 3-4: Creating Slicers

TOPIC E: Create Sparklines

Sparklines

Types of Sparklines

The Sparkline Contextual Tab

How to Create and Customize Sparklines

Activity 3-5: Create Sparklines

TOPIC F: Apply Conditional Formatting

Apply Pre-Defined Conditional Formats

Types of Conditional Formats

Create Custom Conditional Formats

How to Use Conditional Formatting

Activity 3-6: Apply Conditional Formatting

Summary

Review Questions

Lesson 4: Using DAX Functions In Power Pivot

TOPIC A: Manipulate Power Pivot Data Using DAX Functions

Measures

DAX Functions

DAX Variables

Aggregate Functions

How to Manipulate Power Pivot Data Using DAX Functions

Activity 4-1: Manipulating Power Pivot Data Using DAX Functions

TOPIC B: Extract Data from Tables Using Functions

Filter Functions

How to Extract Data from Tables Using Functions

Activity 4-2: Extracting Data from Tables

TOPIC C: Work with Time Dependent Data

Time Intelligence Functions

Create a Date Table

How to Work with Time Dependent Data

Activity 4-3: Working with Time Dependent Data

Summary

Review Questions

Lesson 5: Distributing Power Pivot Data

TOPIC A: Protect Data

Workbook Protection

Worksheet Protection

How to Protect Data

Activity 5-1: Protecting Workbooks and Worksheets

TOPIC B: Saving Data in Different File Formats

File Formats

How to Save Data in Different File Formats

Activity 5-2: Saving Data in Different File Formats

Summary

Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson Lab 1-2

Lesson 2

Lesson Lab 2-1

Lesson Lab 2-2

Lesson Lab 2-3

Lesson 3

Lesson Lab 3-1

Lesson Lab 3-2

Lesson Lab 3-3

Lesson 4

Lesson Lab 4-1

Lesson 5

Lesson Lab 5-1

Course Wrap-Up

Post-Course Assessment

Course Summary

Appendices

Keyboard Shortcut Quick Reference Sheet

Glossary

About This Course

Course Prerequisites

Course Overview

Course Objectives

How to Use This Book

Lesson 1: Using Additional Features

TOPIC A: Reviewing a Presentation

Collaborate

Check Slides

Check Accessibility

Activity 1-1: Review a Presentation

TOPIC B: Inserting Links and Online Video

Insert Links

Insert Online Video

Activity 1-2: Inserting a Link

TOPIC C: Viewing a Presentation

View a Presentation from Start

View a Presentation from Current Slide

View Subtitles in a Presentation

Activity 1-3: Change the Language of a Subtitle

Summary

Review Questions

Lesson 2: Unique ShortCuts

TOPIC A: Shortcuts for Presenting

Forward and Back

Specific Slides

Exiting

TOPIC B: Navigating Ribbons and Panes

Panes

Ribbon

TOPIC C: Editing Slides

Insert a New Slide

Copy and Paste

Reorder Thumbnails

Summary

Review Questions

Lesson 3: Integrating Versions of PowerPoint

TOPIC A: Differences in PowerPoint 365

File Tab

Home Tab

Insert Tab

Design Tab

Transitions Tab

Animations Tab

Review Tab

View Tab

TOPIC B: Using OneDrive to Integrate Flexibility

Using Multiple Versions

Using OneDrive

Create a New Integrated PowerPoint Presentation

Activity 3-2: Insert Alternative Text

Summary

Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson Lab 1-2

Lesson 2

Lesson Lab 2-1

Lesson 3

Lesson Lab 3-1

Course Wrap-Up

Post-Course Assessment

Course Summary

Appendices

Keyboard Shortcut Quick Reference Sheet

Glossary

Velsoft is an educational technologies company focusing on content, platforms and custom development.

Explore Velsoft
Contact Us

Fully customizable courseware

Twitter Linkedin Instagram Facebook-f

Company

Content

Platforms

Resources

© 2024, Velsoft Training Materials, Inc. All rights reserved.

The Top 12 courses are:

Choose from 81 courses available in Articulate Storyline (.story) format.

  • Social Selling for Small Businesses
  • 10 Minute Presentation
  • Successfully Managing Change
  • Performance Management: Managing Employee Performance
  • Building Better Teams
  • Anger Management: Understanding Anger
  • Conflict Resolution: Getting Along in the Workplace
  • Hiring for Success: Behavioral Interviewing Techniques
  • Creating a Top Notch Talent Management Program
  • Conducting Effective Performance Reviews
  • Stress Management
  • Managing Customer Service
  • Closing the Generation Gap in the Workplace
  • Accounting Skills for the New Supervisor
  • Onboarding: The Essential Rules for a Successful Onboarding Program
  • Employee Recognition: Appreciating Your Workforce
  • Creativity In The Workplace
  • Diversity, Equity, and Inclusion
  • Unconscious Bias
  • Becoming Management Material
  • Coaching and Mentoring
  • Motivation Training: Motivating Your Workforce
  • The ABCs of Supervising Others
  • The Professional Supervisor
  • Delegation: The Art of Delegating Effectively
  • Team Building: Developing High Performance Teams
  • Meeting Management: The Art of Making Meetings Work
  • Leadership Skills for Supervisors
  • Managing Difficult Conversations
  • Giving Effective Feedback
  • Managing the Virtual Workplace
  • Managing Across Cultures
  • Women Leadership: Owning Your Strengths and Skills
  • Dealing With Difficult People
  • Vendor Management Essentials
  • How to Become a Leader with Integrity
  • Corrective Action
  • Project Management Principles and Performance Domains
  • Advanced Writing Skills
  • Public Speaking: Presentation Survival School
  • Emotional Intelligence
  • Communication Strategies
  • Critical Elements of Customer Service
  • Skills for the New Employee
  • Business Etiquette: Gaining that Extra Edge
  • Conquering Your Fear of Speaking in Public
  • Time Management
  • Business Writing That Works
  • Critical Thinking
  • Goal Setting
  • Personal Brand: Maximizing Personal Impact
  • Self Leadership
  • Managing Pressure and Maintaining Balance
  • Active Listening
  • Fostering Innovation
  • Delivering Dynamic Virtual Presentations
  • Entrepreneurship 101
  • Workplace Harassment: What It is and What to Do About It
  • Workplace Violence: How to Manage Anger and Violence in the Workplace
  • Lean Process Improvement
  • Employee Accountability
  • Disability Awareness: Working with People with Disabilities
  • Crisis Management
  • Strategic Planning
  • Continuous Improvement with Lean
  • Creating a Positive Work Environment
  • Developing a Safety Procedures Manual
  • Beyond Workplace Politics
  • Digital Transformation
  • GDPR Readiness: Creating a Data Privacy Plan
  • Cybersecurity Fundamentals
  • Respect In The Workplace
  • Advanced Skills for the Practical Trainer
  • Facilitation Skills
  • Survival Skills for the New Trainer
  • Using Activities to Make Training Fun
  • Developing a Training Needs Analysis
  • Measuring Training Results
  • Risk Management
  • Safety in the Workplace

Download a Free Sample

Your privacy is important to us. For more information, take a look at our Privacy Policy.