713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas

>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

Microsoft® Office Excel: Power Query

Training Course Content

Course Objective: In this course, students will create and analyze PivotTable data.

Prerequisites: Before starting this course, students are recommended to take the following courses or have equivalent knowledge: Microsoft® Office Excel® Level 1 and Level 2.

Contact us to discuss if this class is right for you.

  • Excel 2016, 2013 and 2010 users: Please note that our standard class is currently taught using version 2013 due to the similarities between versions.

Lesson 1: Inserting a PivotTable

Topic 1A: Insert a Pivot from Worksheet Data
Topic 1B: Insert Pivot from Table
Topic 1C: Insert Pivot from External Data 
Topic 1D: Insert from Blank Worksheet

Lesson 2: Modifying a PivotTable

Topic 2A: Sort a Pivot
Topic 2B: Move and Delete Pivot
Topic 2C: Use Pivot Drop Zones
Topic 2D: Rearrange Pivot Fields

Lesson 3: Customizing a PivotTable

Topic 3A: PivotTable Tools Menu 
Topic 3B: PivotTable Options
Topic 3C: Field Settings
Topic 3D: Format a Pivot

Lesson 4: Analyzing with a PivotTable

Topic 4A: Use Multiple Value Fields
Topic 4B: Create Calculated Fields
Topic 4C: Use Value Field Properties
Topic 4D: Group Pivot Data

Lesson 5: Filtering a PivotTable

Topic 5A: PivotTables from Multiple Tables
Topic 5B: Filter by Grouped Data
Topic 5C: Filter by Slicers

Lesson 6: Creating a PivotChart

Topic 6A: Create PivotChart
Topic 6B: Modify PivotChart

Appendix: 2013 Only Content

Topic A: Recommended PivotTables
Topic B: PivotTables from Multiple Tables
Topic C: Filter by Timeline


Excel 2010 Training Class Outlines:

Excel 2016 Level 1: Fundamentals of Excel
Excel 2016 Level 2: Intermediate Functions and Features
Excel 2016 Level 3: Advanced Tools and Collaboration Features
Excel 2016 Level 4: Advanced Formulas and Functions
Excel 2016 Level 5: Introduction To VBA Macros
Excel 2016 Level 6: Advanced VBA Macros

 

 

 
   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |