Tomorrow: Excel’s Custom Views Feature

Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel's Custom Views Feature August   10 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time for 6 months, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   Custom Views is one of the most overlooked features in Excel. In this webinar, you'll learn how to use the Custom Views feature to automate many aspects of Excel and improve your large Excel workbooks. You'll learn how to hide and unhide multiple worksheets at once, freeze or unfreeze worksheet panes on demand without repositioning your cursor, store multiple print ranges/settings for a given worksheet, and much more. Upon completion of this course, you'll be able to: Apply different filter settings with just a couple of mouse clicks List techniques for quickly printing information from large workbooks or worksheets Freeze or unfreeze worksheet panes on demand Apply the Zoom to Selection feature to make areas of a worksheet fit exactly on screen Manage the hidden/visible status of columns and rows Identify the commonly used feature in Excel that disables Excel's Custom Views feature in the Windows-based versions of Excel In Excel 2013 and later, use Custom Views to instantly resize the application window for a given workbook Replace an existing custom view with new settings Use a single line of programming code to unhide all worksheets within a workbook and remove all custom views from a given workbook Switch between Custom Views by way of a hidden drop-down list you can enable on Excel's Quick Access Toolbar Turn screen elements, such as scroll bars, gridlines, and worksheet tabs, on or off Explain how shared workbooks automatically create a custom view for each user Recognize frequently selected cell ranges or cursor positions Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 750 on-demand courses Learn More Upcoming Webinars Multistate Overview of Abandoned Property Laws Across the US August 15 at 1 pm ET Learn More Creating an Effective Accounts Payable Policy and Procedures Manual August 16 at 1 pm ET Learn More Excel Dashboards (2-part series) August 17 and 18 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.