logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel Adding Form Controls to Worksheets (non-VBA): MegaBytes

SS Course: 3000847

Course Overview

TOP

During 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

TOP
07/06/26 - HC1 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
10/19/26 - HC3 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During 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
  1. Inserting the PMT function
  2. Adding the developer tab to ribbon
  3. Inserting controls to adjust values
    1. Drop downs (combo boxes)
    2. Spin Controls
    3. Scroll bars
  4. Adjusting the control's properties

Prerequisites

TOP
Students 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.

    Who Should Attend

    TOP

    Next Step Courses

    TOP