Creating Microsoft® Excel Dashboards

Click Here For More Information

Developing a user interface focused on streamlining tasks by utilizing lookup, text, and date functions in correspondence with ActiveX controls. This course also involves creating various Pivot Charts on a communal worksheet analyzed by using data slicers.

Course Objectives:

Upon completion of this course the user will be able to design worksheets for personal use as well as for other end users with a focus on simplifying input via complex methodology. Additionally, the user will define various Pivot Tables and Charts in order to analyze and slice data.

Course Highlights:

VLOOKUP, CONCATENATE, and Date functions; exploring ActiveX controls, Pivot Tables, Pivot Charts, chart dashboards, using timeline and multiple data slicers

Course Information
  • Course Level:Intermediate
  • Prerequisite:Experience with Excel Functions & Formulas
  • Credit:4 CPE hours
  • Fee:$199
  • Length:1/2 day
  • Delivery:Instructor Led/Virtual Live

Related Courses