Excel Dexterity: Minimizing Errors
CPE 2 | Computer Software & Applications | Self-Study

$49.00 each

Course ID: CPE Credits Field Of Study Author or Speaker:
DR-601.19  2 Credits   Computer Software & Applications  David Ringstrom
Instructional Method: Advanced Preparation: Program Prerequisites: Experience Level:
 Interactive Self Study  None   Experience with Excel Spreadsheets  Intermediate 

 

Course Description:

User-proofing Excel spreadsheets don't have to be a tedious task, nor does it have to feel Draconian for spreadsheet users. In this presentation Excel expert David Ringstrom, CPA shares how to implement internal control features within your spreadsheets. Techniques covered include Data Validation, Conditional Formatting, hiding worksheets securely, as well as protecting worksheets and workbooks. You'll also see how to improve the integrity of your spreadsheets with VLOOKUP and SUMIF, as well as Excel's Table feature.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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.