Description

Learn from Excel expert David Ringstrom, CPA, how to implement multiple techniques to create spreadsheets that are interactive, accurate, and user friendly in this on-demand webcast. He explains how to use a variety of Excel’s form controls and features to control the data input of other users, simplify data entry, preserve key formulas, minimize spreadsheet maintenance, and more.

Topics Covered:

  • Creating an in-cell list by way of Excel’s Data Validation feature.
  • Unlocking all data validation cells at once within a worksheet as opposed to tracking cells individually.
  • Using the ComboBox form control to create a searchable drop-down list.
  • Creating an in-cell list by way of Excel’s Data Validation feature.
  • Contrasting Form Controls in Excel versus ActiveX Controls.
  • Tweaking the Data Validation settings for a given range of cells.
  • Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets.
  • Viewing properties that can be set for specific form controls; for example, whether the object should be printed or not.
  • Streamlining filtering of lists in Excel 2013 and later by using the Slicer feature with tables.
  • Specifying a range of whole numbers a user can enter in a worksheet cell.
  • Limiting users to a single choice by way of Excel’s OptionButton form control.

Learning Objectives:

  • State which Go To Special option allows you to select all form controls on a worksheet at once.
  • Recall what the linked cell for a checkbox displays when a user clicks the checkbox on.
  • Identify the feature that offers the most efficient means of storing a paragraph or more of text in a worksheet.