Excel Pivot Tables & Charts Training

Class Price: $250

What’s included – a $1,180 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!

excel_tipIn this Microsoft Excel Pivot Tables and Charts course in Denver and 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, in our Denver and Phoenix training centers, students will come from 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 in both the Phoenix and Denver markets, will give you all the tools you need to understand both of these Excel features and how to use them like a master. Our courses are designed specifically for companies and their employees.

 

Request More Information

  • Class Retakes

    If you need to retake a class you've already attended, you're welcome to take it for free up to 6 months later......Read more

  • Hands-on Learning

    We take pride in making our classes engaging and interactive because we feel hands-on learning......Read more

  • Customized Training

    When we train privately, materials may be developed to fit better the company, organization, or students......Read more

  • Individual Attention

    Because we limit our computer training classes to only 12 students and average around half......Read more

  • Live Training

    Get the most from your training investment by working with a live training instructor......Read more

  • Small Class Sizes

    Our computer training center holds only 12 students, and that’s how we like it......Read more