Excel Yourself/Master Excel's Form Controls

Master Excel's Form Controls

Learn how to build better spreadsheet interfaces using form controls like
  • check boxes
  • scroll bars
  • option buttons
  • combo boxes
Form controls can reduce the number of input errors; simplify and speed up input plus add structure to a file.

Discover the function that you need to use to get the most out of these controls. Find out a few tips and tricks to make creating and using form controls easier. The session finishes with a loan calculator that incorporates all four controls.

As always I share a few other tips.

  • Free

Master Excel's Form Controls

Learn how to create easy to use interfaces.

Contents

Course materials

Mastering Excel's Form Controls 2019.pdf
Form Controls Examples - webinar - 2019.xlsx
Form Controls Examples - webinar - 2019 - complete.xlsx

Course Video recording

Master Excel Form Controls.mp4