Instructor for this course
more

Excel expert David Ringstrom, CPA, takes you beyond basic dashboard techniques in this informative course. David digs deeper into the benefits of creating and using dashboards to quickly assimilate large amounts of data. He covers pivot tables, pivot charts, slicers, and other features that allow you to present data in summary form, yet still give you easy access to underlying details. David shows you how to create: dashboards that look less like Excel spreadsheets, dynamic and interactive graphs, self-updating titles for charts and pivot charts, and much more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.  

Topics Covered:

  • Using linked pictures as a navigation tool to return to the source pivot table.
  • Exploring how to amend queries exported from Microsoft Query.
  • Understanding the conflict that a linked picture overlaying a slicer can pose.
  • Creating self-updating chart titles that change automatically as you filter or slice data related to the chart.
  • Getting past the “PivotTable field name already exists” prompt once and for all.
  • Jump-starting data visualization with the Quick Analysis feature.
  • Learning how to hide or reveal Excel’s Ribbon interface using a simple macro technique.
  • Streamlining the filtering of lists in Excel 2013 and later by using the Slicer feature with tables.
  • Utilizing the Timeline feature in Excel 2013 and later to filter pivot tables based on date ranges.
  • Using the Group command to interactively hide/unhide columns (and/or rows) within Excel worksheets.

Learning Objectives

  • Identify the key you hold down to select two or more nonadjacent columns or rows.
  • Identify which versions of Excel permit using slicers with both tables and pivot tables.
  • Recognize how Microsoft Query can be used to create self-updating links to a variety of data sources.
Last updated/reviewed: November 11, 2019

2 Reviews (14 ratings)Reviews

5
Member's Profile
The course was very effective. Learned lots of techniques which I wasn't aware of.
4
Anonymous Author
This was a great course. I liked it very, very, very, very much.

Prerequisites

Course Complexity: Advanced

Program Prerequisites: Experience with Pivot Tables Is Recommended. It is recommended to take the first course in this series prior to completing this one.

Advance Preparation: None

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCITON AND OVERVIEW
  11:51Introduction to Excel Efficiency: Dashboards Part 2
  10:18Dynamic Pivot Chart Titles, Linked Picture/Slicer Conflict and Linked Picture/Drill Down
  9:40Slicers with Tables (Excel 2013+) and Timeline Feature (Excel 2013+)
  8:22Protecting Workbooks to Block Drill-Down, Sparklines and Timelines Compatibility Issues, Sparkline Features
  8:17Dashboard Sparklines, Removing Sparklines and Quick Analysis (Excel 2013+)
  10:23Dashboard Data Source, Opening Source Files in Excel and Enabling From Text in Office 365
  10:46Text Import Wizard and Properties
  12:05Combine Multiple Worksheets and Set PivotTable to Refresh Automatically
  7:50Add Formulas to Query Results; Group and Ungroup Rows and Columns
  4:56Custom Views - Multipurpose Worksheets
  7:11Streamlining Custom Views, Tables Conflict With Custom Views and Controlling Excel's Look and Feel
  6:10Show/Hide Excel Ribbon and Conclusion
CONTINUOUS PLAY
  1:47:53Excel Efficiency: Dashboards Part 2
SUPPORTING MATERIALS
  PDFSlides: Excel Efficiency: Dashboards Part 2
  PDfExcel Efficiency: Dashboards Part 2 Glossary/Index
  XLSXWorkbook: Excel Efficiency: Dashboards Part 2
  CSVTransactions
  XLSB12 Month Income Statement
  XLSMDashboard Example
  CSVFruit Sales
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM