Class / Schedule

-

Information Technology

Excel Interacting with Forms and Formulas (1 Day)

01-04-T905

Why use form control tools in Excel???  Excel has a variety of options available to reduce the amount of input for the user and set up 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 products 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 and list boxes for drop-down choices, option buttons, scroll bars, 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, lists, option buttons, and check boxes
      • Create and understand formulas that provide form objects and data
      • Start and utilize simple dashboard interfaces

      Competencies covered in this course: Fundamentals of Excel Formulas, Forms and Dashboards

        Intended Audience: Anyone who works with large amounts data and forms in Excel

          Recommended Pre-requisites: : 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
          Lacey SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Mar 13 2019 8:00am-4:30pm
          $159.00 Sun, 02/24/2019 - 16:00 Debbie Lonborg