Microsoft Excel 2016: (C) Charts and PivotTables - EOD

Back to List

Course: 2112890 - Microsoft Excel 2016: (C) Charts and PivotTables - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn more advanced features of Microsoft Excel and spreadsheets, including advanced charting features, how to modify each chart element to meet your design standards, and how to create a chart template for consistent visual presentations. Discover how to apply trendlines from historical data to project future estimates. Learn to use pivot tables to reorganize, filter, and sort data to manage the information you need.

Prerequisites

Course Outline

  • Creating Charts
  • Resizing and Moving Charts
  • Modifying and Formatting Charts
  • Formatting Charts with a Style
  • Adding a Legend to the Chart
  • Creating a Trendline
  • Formatting Trendlines
  • Creating Advanced Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Creating a PivotTable
  • Summarizing Data in a PivotTable
  • Exploring PowerPivot Functions
  • Filtering Data by Using Slicers
  • Analyzing Data with PivotCharts
  • Applying Styles to a PivotChart
Course Type: In Classroom
CEU: 0.30
Sections:
Section#: 4474
Section Meeting Dates and Times:
10/23/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description:


Section#: 4617
Section Meeting Dates and Times:
12/14/2017: 8:30 AM - 11:30 AM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description:

Category: Technology Training - Spreadsheets

Register and View Schedule

Add to Course Waitlist