Spreadsheets

Visual Data Analysis in Excel 2016/2013

Learn how to use the power of Pivot Tables, Charts, and Dashboards to read and interpret your business metrics.

Dates & Times

CourseDate & TimeLocationCost
Visual Data Analysis in Excel 2016/2013February 20 - 9:00 - 4:00LathamRegister
Visual Data Analysis in Excel 2016/2013March 21 - 9:00 - 4:00LathamRegister

Course Outline

Corporate and NYS discounts do not apply for this course.

Do you have a large amount of data that needs to be formatted into a concise report? Excel’s 2016/2013 dashboard tools provide the ability to review large amounts of data. Key performance metrics for your organization can be organized onto a single page. To illustrate the outstanding indicators, charts and graphics can be integrated into the report.

This course is designed for students who already have foundational knowledge and skills in Excel 2016 or Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to summarize table data in Excel by using functions, charts, and pivot tables and display those elements in a dashboard format.

Includes:
Follow-up support by email or phone for an unlimited period

Lesson 1: Dashboard Fundamentals

  • Determine dashboard elements
  • Separate data, analysis, and presentation

Lesson 2: Using Range Names

  • Use range names in formulas
  • Use specialized functions

Lesson 3: Visualizing Data with Charts

  • Create basic charts
  • Modify and format charts
  • Use advanced chart features
  • Create sparklines

Lesson 4: Analyzing Data with PivotTables and PivotCharts

  • Create a PivotTable
  • Filter and sort PivotTable data
  • Modify PivotTables
  • Present data with PivotCharts

Lesson 5: Tools for Creating Dynamic Dashboards

  • Work with the OFFSET function
  • Use the Index Function
  • Use Slicers and Drop Downs for Dynamic Content
  • Apply Conditional Formatting
  • Using the Camera Tool
  • Align Objects