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



          • Sorry, there are no classes currently available for this course.