Excel Dexterity - Custom Views
CPE 2 | Computer Software & Applications | Self-Study

$49.00 each

 

Course ID: CPE Credits Field Of Study Author or Speaker:
DR-616.19  2 Credits   Computer Software and Applications  David Ringstrom
Instructional Method: Advanced Preparation: Program Prerequisites: Experience Level:
 Interactive Self Study  None   None   Overview 

 

Excel Dexterity: Custom Views

Presented by David H. Ringstrom, CPA

In this empowering presentation, Excel expert David Ringstrom, CPA, demonstrates multiple ways to automate your work in Excel by way of the Custom Views feature—one of the most underutilized features in Excel. David explains how to hide and unhide multiple worksheets at once, freeze or unfreeze worksheet panes on-demand, store multiple print ranges/settings for a given worksheet, gain control over long lists of data by filtering instead of sorting, and more.

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.