Calendar of Events

Excel Explained: Building Interactive Spreadsheets

04/13/2018, 10:00 AM to Noon

No location provided

Amy Davis adavis@msbankers.com 601-948-6366

Description:

Excel Explained:
Building Interactive Spreadsheets


Presented by David Ringstrom
Friday, April 13th, 2018
10:00 am - 12:00 pm CT


Covered Topics:

  • Limiting users to a single choice by way of Excel’s OptionButton form control.
  • Using the ComboBox form control to create a searchable drop-down list.
  • Using Excel’s Go to Special feature to easily select form controls you wish to remove en masse.
  • Preserving key formulas using hide and protect features.
  • Specifying a range of whole numbers that a user can enter in a worksheet cell.
  • Creating an input rule that requires names to be entered in a last-name, first-name format.
  • Streamlining data entry in Excel with the CheckBox form control.
  • Creating an in-cell list by way of Excel’s Data Validation feature.
  • Limiting the number of characters that a user can enter in a worksheet cell.
  • Using form controls to simplify data entry as well as to control the input of other users.
  • Restricting users to enter dates within a given range, or before/after a given date.
  • Learning how the Table feature allows you to transform filtering tasks.

Register here