VIDEO DESCRIPTION:

Play, download and edit the free video Excel Accountant: Custom Views.

Step by step, Excel expert David Ringstrom, CPA, shows you many ways of automating your work via Custom Views—an often-overlooked feature in Excel. David demonstrates 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. After this course, you’ll be empowered to use Excel far more effectively. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, 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 webcast.Office 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 2019, Excel 2016, and so on.Who Would Be Interested in This Course:Practitioners seeking to improve the efficiency and integrity of their large Excel workbooks using the Custom Views feature.Topics Covered:Overviewing Excel’s Custom Views feature and the types of settings that can be managed in this fashion.Using Custom Views in Excel 2013 and later to instantly resize the application window for a given workbook.Using Excel’s Custom Views feature to make a single set of data serve multiple purposes.Turning screen elements—such as scroll bars, gridlines, worksheet tabs, and more—on or off by way of Custom Views.Using Excel’s Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet.Freezing or unfreezing worksheet panes on demand with a custom view.Gaining control of long lists of data by filtering instead of sorting.Setting a print range that includes multiple noncontiguous areas of a worksheet.Making the same edits on multiple worksheets at once by grouping worksheets.Using Custom Views to remember frequently selected cell ranges or cursor positions.Applying different filter settings with just a couple of mouse clicks using the Custom Views feature.Protecting hidden sheets from within a workbook.

Download, play and edit free videos and free audios from Excel Accountant: Custom Views using RedcoolMedia.net web apps