Class / Schedule

-

Information Technology

Excel: Interactive Reports (1 Day)

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

Scheduled Class Location and Dates
City / Facility Date and Time Course Cost Cancel Date Instructor
1 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Sep 16 2019 8:00am-4:30pm
$179.00 Wed, 08/28/2019 - 17:00 Debbie Lonborg
2 Lacey

SPSCC - LACEY
4220 6th Ave SE Bldg. 1
Lacey, WA 98503
  • Dec 11 2019 8:00am-4:30pm
$179.00 Sun, 11/24/2019 - 16:00 Debbie Lonborg