Interactive Spreadsheets in Excel

On Demand Webinar

Webinar Details $219

  • Webinar Length: 100 Minutes
  • Guest Speaker:   David Ringstrom
  • Topic:   Business Administration, Business Skills, Finance, Software, Taxation and Accounting
  • Credit:   ATAAA 1.5, ATATX 1.5, ATAOP 1.5
All Access Membership

In this comprehensive webcast, Excel expert David Ringstrom, CPA, teaches multiple techniques for creating spreadsheets that are interactive, accurate, and user friendly. He shows you how to use a variety of Excel’s form controls to regulate the data input of other users, simplify data entry, create searchable drop-down lists, and more. David also explains such beneficial Excel features as the Table feature, the Data Validation feature, the Text Box feature, and the Go To Special feature. 

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Topics Typically Covered:

Allowing users to make multiple choices by way of the ListBox form control.

Contrasting data validation–based lists versus form control–based lists.

Using the ComboBox form control to create a searchable drop-down list.

Viewing properties that can be set for specific form controls; for example, whether the object should be printed or not.

Creating an in-cell list by way of Excel’s Data Validation feature.

Minimizing ongoing spreadsheet maintenance with Excel’s Table feature.

Streamlining data entry in Excel with the CheckBox form control.

Using Excel’s Go to Special feature to easily select form controls you wish to remove en masse.

Contrasting form controls in Excel versus ActiveX controls.

Limiting the number of characters a user can enter in a worksheet cell.

Specifying a range of whole numbers a user can enter in a worksheet cell.

Unlocking all data validation cells at once within a worksheet as opposed to tracking cells individually.

Learning Objectives:

Describe how Excel’s Table feature can be used to minimize spreadsheet maintenance.

Recall how to restrict users from entering dates within a given range.

Identify the form control that allows users to make multiple choices.


Guest Speaker

  • David H. Ringstrom, CPA

Webinar Survey Overall Rating

This webinar received a total of 5 survey responses. Attendees have given an average rating of 4.4 stars out of a possible 5, reflecting the quality and value of the content presented.

Average rating

4.4 / 5
Webinar Presentation
How many of the objectives of the event were met?
4.6 Stars
How useful was the information presented at this event?
4.4 Stars
Overall, how satisfied were you with this event?
4.4 Stars
Speaker Performance
Overall, how satisfied were you with this presenter?
4.4 Stars
How closely did the presenter follow the schedule?
4.2 Stars

Reviews From Webinar Survey

Our webinars are crafted to deliver exceptional value and insight to business professionals. To ensure we meet and exceed your expectations, we conduct thorough post live webinar surveys. Below, you'll find genuine feedback from attendees, sharing their thoughts on the event and the speaker's performance. These reviews highlight our commitment to continuous improvement and excellence in providing top-tier educational experiences.

Robin S.
August 7, 2019
4.8 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
4.5 Stars
Do you have any other comments, questions or concerns?
no comment

DORIS C.
August 7, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
A lot of information to take in within the hour and forty minutes.Although very well presented, some brain overload after an hour.

Haleh Y.
August 7, 2019
4.0 / 5
Webinar Rating:
4.0 Stars
Speaker Rating:
4.0 Stars
Do you have any other comments, questions or concerns?
no comment

Jackie H.
August 7, 2019
4.0 / 5
Webinar Rating:
4.0 Stars
Speaker Rating:
4.0 Stars
Do you have any other comments, questions or concerns?
no comment

Nereida Y.
August 7, 2019
4.2 / 5
Webinar Rating:
4.3 Stars
Speaker Rating:
4.0 Stars
Do you have any other comments, questions or concerns?
no comment

ATAAA Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.

ATATX Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.

ATAOP Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.