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
|Course||Date & Time||Location||Cost|
|Visual Data Analysis in Excel 2016/2013||February 20 - 9:00 - 4:00||Latham||Register|
|Visual Data Analysis in Excel 2016/2013||March 21 - 9:00 - 4:00||Latham||Register|
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.
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