Wrangling Large Spreadsheets

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Wrangling Large Spreadsheets December   12 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 after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   Don't let large Excel workbooks push you around! In this webinar, you'll learn about techniques you can use to manage unwieldy workbooks, save time, avoid repetitive tasks, improve the integrity of your large workbooks, and much more. Upon completion of this course, you'll be able to: Define how to use the Watch Window feature to monitor and navigate to key worksheet cells Manage the hidden/visible status of columns, rows, worksheets, print settings, and more using the Custom Views feature Create a keyboard shortcut for Excel's Freeze Panes feature Utilize tricks that make printing information from large workbooks or worksheets easier Identify techniques that let you reduce the file size of bloated Excel workbooks List the pros and cons of grouping worksheets Identify the risks of linked workbooks Determine if a workbook contains links and recognize how links can hide within Excel features Navigate large workbooks with ease by way of a hidden menu and keyboard shortcuts Recognize how Excel's INDIRECT function can save you time when aggregating data from multiple worksheets Apply Excel's Custom Views feature to hide and unhide multiple worksheets with ease Utilize the Group and Ungroup feature to expand or collapse rows and/or columns Use the Watch Window to easily monitor the ramifications of even minor changes to your workbook Explain how the INDIRECT worksheet function simplifies creating summary worksheets David Ringstrom teaches from the version of Excel in use by the majority of attendees, but he explains any differences in Excel 2007, 2010, 2013, and 2016. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. David's detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. He also provides an Excel workbook that includes a majority of the examples he uses during each session. Course Reviews from Past Attendees 100% of attendees said they would recommend this course to others. "Very informative." "Efficient and to the point!" "Great tips." Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is the owner and founder of Accounting Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom provides Microsoft Excel training and consulting services nationwide. He frequently presents on Microsoft Excel at webinars and conferences, regularly publishes articles about spreadsheets, and has edited dozens of books on accounting software. 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 850 on-demand courses Learn More Upcoming Webinars Using Relevant Ratios as the Basis for Key Business Decisions December 20 at 1 pm ET Learn More The 1099 & W-9 Annual Update Course January 3 at 3 pm ET Learn More Nexus and Drop Shipments and Sales and Use Tax January 4 at 3 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.