Excel Pivot Tables in-depth, PowerPivot, and Data Analysis Functions and Tips

Description

Excel includes sophisticated features to present data in Pivot Table reports. This course covers the many Excel features and functions to test, organize, calculate and find trends in data as well as report the results. The free PowerPivot add-in for Excel takes PivotTable analysis to a new level. PowerPivot is a business intelligence tool that will provide you with additional features to build complex relationships between sets of data. This course applies to Excel 2016/2013/2010. Participants will learn many timesaving tips, work through many examples, and receive take-aways for after class use.

Please note this course will be hands-on. We recommend bringing your own laptop to this program with excel loaded. You can attend without one but you would not be able to participate during the hands on exercises.

Learning Objectives
  • Use the Pivot Table feature for quick analysis and subtotal reporting
  • Use new Pivot Table filter features including the slicers and timeline and Pivot Charts
  • Learn Pivot Table tips for recalculation and adding custom calculations
  • Clear the Pivot Cache, copy a Pivot Table, and create separate Pivot Tables and Pivot Charts
  • Identify Options settings to control formatting and also generating multiple reports automatically
  • Apply new color scales and icon sets to visually spot trends in data
  •  Use data functions, data import techniques, text to columns, and FlashFill features
  • Use Excel’s conditional formatting features and icon sets for tracking key performance indicators
  • Discover the benefits of the Excel PowerPivot Data Model
  • Add data to the PowerPivot Data Model for Pivot Tables and use DAX functions for calculating within the Data Model
Major Topics
  • Master the creation of complex Pivot Table reports with calculated fields
  • Understand the pivot cache and how to protect your data
  • Use Pivot Tables to analyze data by category with subtotals
  • Learn Pivot Table tips for recalculation and duplicating Pivot Tables
  • Understand required design rules for Excel data and test data for validity
  • Use multiple key Sort techniques comparing the Quick Sort tools and the Data Sort dialog box
  • Generate automatic Subtotals by list category and show/hide details
  • Use the new Table feature to save time manipulating lists in place
  • Use Right, Left, Mid, Search, and Len functions to extract portions of cell contents
  • Learn to test data for accuracy and cleanup data using important Excel functions
  • Use concatenate features to combine information from multiple cells into one cell
  • Use Text to Columns to import text or .csv files
  • Create recorded macros for data cleanup and Pivot Table refresh
  • Apply Conditional Formatting to identify data patterns in color and find duplicates
  • Learn how to connect to an external data source and run an Excel query
  • Understand the benefits of and use the PowerPivot Data Model
  • Import Data from Various Data Sources
  • Create Linked Tables
Provider
SCG Training & Consulting
Course Level
Advanced
Professional Area of Focus
Business & Industry
Technology
CPE Field of Study
Computer Software & Applications
8
Who Should Attend
CPAs and Professionals at all levels of an organization needing to manipulate data within Excel or from data connections to external data sources with the time-saving Pivot Table, PowerPivot and other important Excel data analysis features
Instructor(s)
Judith Borsher
Prerequisites

Intermediate Excel experience

Location

Loyola University Maryland Graduate Center Columbia Campus, 8890 McGaw Rd Columbia, MD 21045-4743

View in Google Maps
Register Now
When
Aug 2, 2018
8:00 am - 3:30 pm
Location
Loyola University Maryland Graduate Center Columbia Campus, 8890 McGaw Rd Columbia, MD 21045-4743
Total CPE Credits
8
Format
In-Person
Instructor
Judith Borsher

MEMBER


$ (% off)
$300.00
Price includes $50 early registration discount(s) - expires 07/03/2018
Price increases to $350.00 on 07/04/2018

NON-MEMBER


$ (% off)
$400.00
Price includes $50 early registration discount(s) - expires 07/03/2018
Price increases to $450.00 on 07/04/2018
Become a Member

Register for this Event

Excel Pivot Tables in-depth, PowerPivot, and Data Analysis Functions and Tips


Loading