Calendar of Events

Creating Error-Proof Excel Spreadsheets

02/02/2018, 10:00 AM to Noon

No location provided

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

Description:

Excel Explained: Building Error-Proof Spreadsheets


Presented by David H. Ringstrom
Friday, February 2nd, 2018
10:00 am - 12:00 pm CT
 

Topics Covered

  • Using Conditional Formatting to identify unlocked cells into which data can be entered.
  • Preserving key formulas using hide and protect features.
  • Discovering techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet.
  • Summing disparate sections of a spreadsheet quickly with the SUBTOTAL function.
  • Learning a simple design technique that greatly improves the integrity of Excel’s SUM function.
  • Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut.
  • Limiting access to sensitive workbooks by way of password protection
  • Performing dual lookups, which allow you to look across columns and down rows to cross-reference the data you need.
  • Switching between Custom Views by way of a hidden drop-down list you can enable on Excel’s Quick Access Toolbar.
  • Using the TEXT function to create report titles that update themselves.
  • Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
  • Seeing how to view two worksheets from within the same workbook at the same time.
Register here