Excel’s Custom Views Feature

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel's Custom Views Feature September   28 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, author and nationally recognized Excel instructor 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 after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Course Reviews: View Testimonials Learn More Register Today Course Description   One of the most overlooked features in Excel is Custom Views. 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. Upon completion of this course, you'll be able to: Define how to replace an existing custom view with new settings Identify how to remove all custom views from a given workbook and unhide all worksheets within a workbook Recall how to freeze or unfreeze worksheet panes Apply different filter settings with just a couple of mouse clicks Resize the application window for 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, worksheet tabs, and more—on or off Explain how shared workbooks automatically create a custom view for each user Describe the types of settings that can be managed Explain the power—and the risks—of grouping worksheets Identify which features, such as Custom Views, you can't use when one or more tables exist in a workbook Set a print range that includes multiple non-contiguous areas of a worksheet Remember frequently selected cell ranges or cursor positions Toggle a trial balance between a working trial balance view and a journal entry view Apply different print settings, including orientation and margins, to a single worksheet Hide and unhide multiple worksheets with ease Make a single set of data serve multiple purposes Wrangle long lists of data by filtering instead of sorting Course Reviews from Past Attendees 100% of attendees recommend this webinar. "I learned something very useful that I did not know." "The graphics were detailed and well laid out." "Very self explanatory with great examples." "I love learning anything and everything about Excel. The presenter was excellent!" "I was not familiar with many of the custom view features, and will be interested in seeing how they might apply to my existing workbooks." "It was targeted towards accountants so I could really see immediate applications to what I do." 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 1,300 on-demand courses Learn More Upcoming Webinars How to Detect and Prevent Employee Fraud September 19 at 1 pm ET Learn More Microsoft Excel Data Visualization September 20 at 3 pm ET Learn More Post-Acquisition Disputes Involving Earnouts September 21 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 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.