This lesson covers user interfaces. Most Excel models are content with having users type in a number or text in a cell and then the formulas use that input.There are more user friendly way to interact with your users. In this lesson you will learn how to include option buttons, scroll bars, check boxes and other user form objects to give your users a familiar way to interact with Excel. You will also learn how to use new formulas (not covered in previous lessons) that connect the form objects with the data in the workbook.This lesson comes with two follow along workbooks so you can practice as you read the text.

Follow Along Workbooks

If you already have the book and you are looking for the follow along workbooks. Input your information below and I will send it to you in a few minutes. I won’t spam you. I send email tips and tricks every few weeks and I let you know when a new lesson is published. That’s all.

If you don’t see the sign up form below, try disabling any ad blockers. I promise you the form is there.

Enter your name and email below to get your follow along workbook