Excel Pivot Tables and Charts

Course Description

Excel Pivot Tables and Charts Training in Denver & Phoenix

excel_tip

Class Price: $235

What’s included – a $1,150 value with:

  • Face-to-face, live interactive class
  • Retake – allows you to retake the entire class if you need a refresher within 6 months
  • Workshop – get 1on1 help from an instructor on your own work projects to help you apply what you learned, up to 6 months after the class
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Quick Tip sheet – color reference card with the top tips from class
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

In this Microsoft Excel training in Denver & Phoenix, you will learn how to analyze data using these important tools. You will learn how to turn a table of data into a manageable analysis, without ever having to alter the original table. You will also learn how to give your data more visual impact, using the many different charts available in Excel. Your instructor will be available to help you with any questions, as well as lead you to a thorough understanding of these powerful visual tools.

Training Class Goal

In the Microsoft Excel Pivot Table and Charts training, students will come from the class with more confidence in using Pivot Tables and Charts, as well as have an understanding of how data in Excel can be displayed in a visual way. They will learn how to create Pivot Tables that can calculate, compare, and total data from a table. They will also feel confident in how to use all of the various formatting tools to make their Pivot Tables really pop. Students will also learn all of the different types of charts available in Excel, and when best to use each. Additional charting techniques will be covered, allowing the students make their charts really stand out from the default templates, including drop-lines and unique axis formatting, as well as using trending, and analysis tools.

PreRequisites

Students should enter the Excel Pivot Tables and Charts course with an understanding of Excel fundamentals, including formatting, navigation, and basic formulas.

Topics Covered

Pivot Tables training topics

  • Creating, sorting, and filtering data
  • Formatting styles
  • Numbers and layouts
  • Grouping data
  • Value Comparisons
  • Row and Column Comparisons
  • Adding running totals and percentage totals
  • Calculated fields and items
  • Combining multiple data sources
  • Creating Pivot Table charts with filters and design elements
  • Conditional formatting
  • Other classes covering Pivot Tables

Charts training topics

    • Creating charts
    • Understanding single versus multiple series charts
    • Modifying chart design, layout, and format
    • Creating charts from non-consecutive data
    • Drop-lines
    • Axis formatting
    • Replacing chart series with pictures or shapes
    • Analysis tools
    • Up-Down bars
    • Trending tools
    • Using secondary axis
    • Highlighting relationship differences with charts
    • Combining two charts into one
    • Doughnut Charts
    • Sub-Pie Charts
    • Paired Bar Charts
    • Radar Charts

The Microsoft Excel Pivot Tables and Charts training class will give you all the tools you need to understand both of these Excel features and how to use them like a master.

 

Upcoming Classes

Excel Basic
Apr 26 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 26-04-2018T08:00 26-04-2018T12:00 Active
Active 26-04-2018 Active 235.00 26-04-2018
Register Now
Excel Macros
Apr 30 8:00 am - 12:00 pm Excel Macros Tech Center Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 30-04-2018T08:00 30-04-2018T12:00 Active
Active 30-04-2018 Active 235.00 30-04-2018
Register Now
Excel Basic
May 7 1:00 pm - 5:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 07-05-2018T13:00 07-05-2018T17:00 Active
Active 07-05-2018 Active 235.00 07-05-2018
Register Now
Excel Basic
May 21 1:00 pm - 5:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 21-05-2018T13:00 21-05-2018T17:00 Active
Active 21-05-2018 Active 235.00 21-05-2018
Register Now
Excel Macros
May 22 8:00 am - 12:00 pm Excel Macros Phoenix Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 22-05-2018T08:00 22-05-2018T12:00 Active
Active 22-05-2018 Active 235.00 22-05-2018
Register Now
Excel Basic
May 23 1:00 pm - 5:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 23-05-2018T13:00 23-05-2018T17:00 Active
Active 23-05-2018 Active 235.00 23-05-2018
Register Now
Excel Basic
Jun 5 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 05-06-2018T08:00 05-06-2018T12:00 Active
Active 05-06-2018 Active 235.00 05-06-2018
Register Now
Excel Pivot Tables and Charts
Jun 6 1:00 pm - 5:00 pm Excel Pivot Tables and Charts Tech Center Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 06-06-2018T13:00 06-06-2018T17:00 Active
Active 06-06-2018 Active 235.00 06-06-2018
Register Now
Excel Basic
Jun 21 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 21-06-2018T08:00 21-06-2018T12:00 Active
Active 21-06-2018 Active 235.00 21-06-2018
Register Now
Excel Basic
Jun 27 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 27-06-2018T08:00 27-06-2018T12:00 Active
Active 27-06-2018 Active 235.00 27-06-2018
Register Now
Excel Basic
Jul 9 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 09-07-2018T08:00 09-07-2018T12:00 Active
Active 09-07-2018 Active 235.00 09-07-2018
Register Now
Excel Macros
Jul 19 8:00 am - 12:00 pm Excel Macros Westminster Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 19-07-2018T08:00 19-07-2018T12:00 Active
Active 19-07-2018 Active 235.00 19-07-2018
Register Now
Excel Basic
Jul 25 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 25-07-2018T08:00 25-07-2018T12:00 Active
Active 25-07-2018 Active 235.00 25-07-2018
Register Now
Excel Basic
Jul 25 1:00 pm - 5:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 25-07-2018T13:00 25-07-2018T17:00 Active
Active 25-07-2018 Active 235.00 25-07-2018
Register Now
Excel Basic
Aug 6 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 06-08-2018T08:00 06-08-2018T12:00 Active
Active 06-08-2018 Active 235.00 06-08-2018
Register Now
Excel Basic
Aug 13 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 13-08-2018T08:00 13-08-2018T12:00 Active
Active 13-08-2018 Active 235.00 13-08-2018
Register Now
Excel Macros
Aug 14 1:00 pm - 5:00 pm Excel Macros Phoenix Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-08-2018T13:00 14-08-2018T17:00 Active
Active 14-08-2018 Active 235.00 14-08-2018
Register Now
Excel Basic
Aug 21 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 21-08-2018T08:00 21-08-2018T12:00 Active
Active 21-08-2018 Active 235.00 21-08-2018
Register Now
Excel Basic
Sep 5 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 05-09-2018T08:00 05-09-2018T12:00 Active
Active 05-09-2018 Active 235.00 05-09-2018
Register Now
Excel Basic
Sep 11 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 11-09-2018T08:00 11-09-2018T12:00 Active
Active 11-09-2018 Active 235.00 11-09-2018
Register Now
Excel Basic
Sep 18 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 18-09-2018T08:00 18-09-2018T12:00 Active
Active 18-09-2018 Active 235.00 18-09-2018
Register Now
Excel Basic
Oct 1 1:00 pm - 5:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 01-10-2018T13:00 01-10-2018T17:00 Active
Active 01-10-2018 Active 235.00 01-10-2018
Register Now
Excel Pivot Tables and Charts
Oct 3 8:00 am - 12:00 pm Excel Pivot Tables and Charts Tech Center Excel Pivot Tables and Charts Excel Pivot Tables and Charts Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake... Mission Critical Systems 03-10-2018T08:00 03-10-2018T12:00 Active
Active 03-10-2018 Active 235.00 03-10-2018
Register Now
Excel Basic
Oct 9 1:00 pm - 5:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 09-10-2018T13:00 09-10-2018T17:00 Active
Active 09-10-2018 Active 235.00 09-10-2018
Register Now
Excel Macros
Oct 11 8:00 am - 12:00 pm Excel Macros Tech Center Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 11-10-2018T08:00 11-10-2018T12:00 Active
Active 11-10-2018 Active 235.00 11-10-2018
Register Now
Excel Basic
Oct 17 1:00 pm - 5:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-10-2018T13:00 17-10-2018T17:00 Active
Active 17-10-2018 Active 235.00 17-10-2018
Register Now
Excel Basic
Nov 7 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 07-11-2018T08:00 07-11-2018T12:00 Active
Active 07-11-2018 Active 235.00 07-11-2018
Register Now
Excel Basic
Nov 8 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 08-11-2018T08:00 08-11-2018T12:00 Active
Active 08-11-2018 Active 235.00 08-11-2018
Register Now
Excel Basic
Nov 19 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 19-11-2018T08:00 19-11-2018T12:00 Active
Active 19-11-2018 Active 235.00 19-11-2018
Register Now
Excel Basic
Dec 4 8:00 am - 12:00 pm Excel Basic Tech Center Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 04-12-2018T08:00 04-12-2018T12:00 Active
Active 04-12-2018 Active 235.00 04-12-2018
Register Now
Excel Basic
Dec 10 8:00 am - 12:00 pm Excel Basic Phoenix Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 10-12-2018T08:00 10-12-2018T12:00 Active
Active 10-12-2018 Active 235.00 10-12-2018
Register Now
Excel Macros
Dec 13 1:00 pm - 5:00 pm Excel Macros Phoenix Excel Macros Excel Macros Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 13-12-2018T13:00 13-12-2018T17:00 Active
Active 13-12-2018 Active 235.00 13-12-2018
Register Now
Excel Basic
Dec 19 8:00 am - 12:00 pm Excel Basic Westminster Excel Basic Excel Basic Training in Denver & Phoenix Class Price: $235 What’s included – a $1,150 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 19-12-2018T08:00 19-12-2018T12:00 Active
Active 19-12-2018 Active 235.00 19-12-2018
Register Now
Excel Pivot Tables and Charts Tech Center Jun 6  1:00 pm - 5:00 pm

235.00

Attendee 1