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:
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