Information Technology

Excel: Interactive Reports

Course Code: 01-04-T935

Excel has a variety of options available to reduce the amount of input for the user and set up interactive sheets that are streamlined for your users and your data! Come to this one day class to learn about your options to make dynamic excel reports that will provide user friendly interactions and data presentation that will impress!

In this course you will learn how to include macros with their own interactive buttons, combo boxes and data validation for drop-down choices, option buttons, check boxes and other form objects to give your users a familiar way to interact with Excel.

Performance Objectives: Upon completion of this course you should be able to:

  • Use macros and interactive buttons
  • Format drop downs, option buttons, and check boxes
  • Create and understand formulas that provide form objects and data
  • Start and utilize simple report interfaces

Competencies covered in this course: Fundamentals of Excel Formulas, reporting, Macros and interface

Intended Audience: Anyone who works with large amounts data and can utilize interactive reports in Excel

Recommended Prerequisite: Recommend completing Excel Level 1 and Excel Level 2. To be successful in this course, you should have a good understanding of Excel, to include familiarity with common formulas