Microsoft Excel Pivot Tables Training Course Beginners

Beginners Microsoft Excel Pivot Tables Course Overview

You need to get answers to questions and you need them quickly. How many people buy a certain product? In which month should we discount that product? If you've yet to embrace Pivot Tables, then you won't know how quickly you can get answers. Not only that but you can within minutes create effective summary tables and charts to be used in presentations and reports.

This course is designed specifically to look at Pivot Tables. You will learn how to correctly structure data, learning various Excel formulas and functions to enable you to do this. We will also take a look at the PowerPivot plugin in Excel, giving you an opportunity to use DAX with multiple data sources.

Previous Excel experience such as writing simple formulas, along with a basic understanding of how to add rows and columns would be beneficial.

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

Complete Course Outline

Pivot Table Formulas

• If Function
• SUMIF
• Flash Fill
• VLookup
• Index Match Function

Tables

• Creating Tables
• Using Functions with Tables
• Sorting Data in Tables
• Adding & Deleting Rows
• Converting a Table back to a Range

Pivot Tables

• Creating a Pivot Table from existing data in Excel
• Formatting Pivot Table Data
• Filtering and Sorting Data in Pivot Tables
• Dates and Pivot Tables
• Slicers and Timelines
• Connecting Pivot tables using Slicers
• Timelines
• Pivot Charts

PowerPivot

• Installing PowerPivot
• Adding a Table to PowerPivot

Performing Basic DAX calculations

• Inserting a column in PowerPivot
• Creating a calculated column
• Formatting data in columns
• Adding data from a text file
• Creating relationships
• Pivot Tables the PowerPivot way
• Date calculations in DAX
• Setting a Date Order
• Calculated Fields
• Year to Date function in DAX
• Viewing Sales from previous day
• Using a Calendar Table

Although this course is designed with Excel 2013 in mind, the principles used could be applied to 2010 & 2016 as well.

You may also be interested in the following courses:

• Excel PowerPivot Intermediate Training Course
• Excel Advanced Training Course

Or the following training courses may be of interest:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel PowerPivot training course intermediate