Objective

In this Microsoft Excel Pivot Tables and Charts course, 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. ​

In the Microsoft Excel Pivot Table and Charts training, 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.

Outline

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

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

 

Credits

0.40 Continuing Education Units
Course ID #TECH252



Class Details

Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:01/09/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:03/07/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:05/20/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:07/02/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:09/10/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:11/19/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:02/14/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:05/22/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:08/19/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:11/13/2019
Time:8:00 am to 12:00 pm
List Price:$220.00

Don't see what you are looking for?

Contact Us