Data Analysis in Excel

Advanced

Now that you’ve got all of that information, what are you going to do with it? Senior managers and entry-level personnel all benefit from taking this class, where you’ll learn the ins and outs of Pivot Tables and Charts, as well as how to import data from databases. 

  • Creating Pivot Tables
  • Changing Pivot Table Data
  • Filtering and Sorting with Pivot Tables
  • Grouping Data
  • Slicers
  • Pivot Table Layout
  • Creating Pivot Charts
  • Scenarios and Goal Seek
  • The Solver Add In
  • Cleaning up Data
  • Hyperlinks
  • Importing Data
  • Data Connections

Class Length: 4 hours. Can include up to 15 attendees in one session.