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.