Course Overview
TOPDuring this two-hour live hands-on training, our top-rated instructor will demonstrate how to add controls to input data into an excel spreadsheet designed as an input form. Students are encouraged to ask questions in the chat window at any time during the class.
Scheduled Classes
TOPWhat You'll Learn
TOPDuring this class you will learn to:
Insert the PMT Function
Add the developer tab to the ribbon
Insert controls to adjust values
Adjust the controls properties
Outline
TOP- Inserting the PMT function
- Adding the developer tab to ribbon
- Inserting controls to adjust values
- Drop downs (combo boxes)
- Spin Controls
- Scroll bars
- Adjusting the control's properties
Prerequisites
TOPStudents should have intermediate Excel skills and be comfortable enabling the Developer tab, inserting and configuring spreadsheet controls, and working in Excel for Windows (desktop). This course uses legacy Excel controls that may be disabled in some secured environments.