course description
custom views is one of the most overlooked features in excel. in this course, excel expert david h. ringstrom, cpa, shares a variety of ways to automate your work in excel by way of custom views. you'll be able to hide and unhide worksheets, apply filter settings, swap out print settings, and much more simply by applying a view.
david demonstrates every technique at least twice: first, on a powerpoint slide with numbered steps, and second, in the subscription-based microsoft 365 (formerly office 365) version of excel. david draws your attention to any differences in the older versions of excel (2021, 2019, 2016 and earlier) 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 course.
microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. conversely, the perpetual licensed versions of excel have feature sets that don't change. perpetual licensed versions have year numbers, such as excel 2021, excel 2019, and so on.
who should attend: practitioners seeking to improve the efficiency and integrity of their large excel workbooks using the custom views feature.
level: basic
topics covered:
- applying different filter settings with just a couple of mouse clicks using the custom views feature
- creating custom views that will enable you to display all worksheets in a workbook at once as well as hide/display selected worksheets
- gaining control of long lists of data by filtering instead of sorting.
- learning how to replace an existing custom view with new settings
- learning how to use a single line of programming code to unhide all worksheets within a workbook
- protecting hidden sheets from within a workbook
- streamlining custom views by adding a drop-down list to excel's quick access toolbar
- understanding the limitations and frustrations of manually hiding and unhiding worksheets within a workbook
- using the custom views feature to remember frequently selected cell ranges or cursor positions
learning objectives:
- identify how to use custom views to manage the hidden/visible status of columns and rows
- apply custom views to toggle a trial balance between a working trial balance view and a journal entry view
- recall how to replace an existing custom view with new settings
review our course policies and procedures page for further information