| Attend upcoming webinar and earn continuing education credits. | Wrangling Large Spreadsheets | | | | | | | | December | | | | 16 | | 1 pm - 2:40 pm ET | | | | | | | | | | 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." | | | | | | | | | | 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. | | | | | | | | | | | ● 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 | | | | | | |
No comments:
Post a Comment