Excel Agility: Gaining Control of Large Spreadsheets

On Demand Webinar

Webinar Details $219

  • Webinar Length: 100 Minutes
  • Guest Speaker:   David Ringstrom
  • Topic:   Business Administration, Finance, Taxation and Accounting, Business Skills, Software
  • Credit:   ATAAA 1.5, ATATX 1.5, ATAOP 1.5
All Access Membership

As Excel expert David Ringstrom says, “Either you work Excel or it works you.” After attending his presentation, you’ll be aware of techniques and keyboard shortcuts that will help you gain control of large spreadsheets, save time, avoid repetitive tasks, and improve the integrity of your workbooks. 

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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.  

Topics Typically Covered: 

•      Saving time when aggregating data from multiple worksheets with Excel’s INDIRECT function. 
•      Understanding Excel’s Freeze Panes feature 
•      Understanding the difference between manual and automatic calculation modes in Excel. 
•      Learning how to deal with annoying changes to Print Preview in Word 2010 and later. 
•      Seeing how to view two worksheets from within the same workbook at the same time. 
•      Using the Group and Ungroup feature to expand or collapse rows and/or columns. 
•      Learning the power—and the risks—of grouping worksheets.
•      Double-click tricks for navigating within a large worksheet.
•      Using the Watch Window to easily monitor the ramifications of even minor changes to your workbooks.
•      Using Excel’s OFFSET function to dynamically reference data from one or more accounting periods.
•      Using Excel’s Custom Views feature to hide and unhide multiple worksheets with ease. 
•      Using the SUM Function to drill through two or more worksheets. 

Learning Objectives:

•      Define how to use the Watch Window feature to monitor and navigate to key worksheet cells.
•      Apply the Custom Views feature to manage the hidden/visible status of columns, rows, worksheets, print settings, and more.
•      State how the INDIRECT worksheet function simplifies creating summary worksheets.


Guest Speaker

  • David H. Ringstrom, CPA

Webinar Survey Overall Rating

This webinar received a total of 2 survey responses. Attendees have given an average rating of 5.0 stars out of a possible 5, reflecting the quality and value of the content presented.

Average rating

5.0 / 5
Webinar Presentation
How many of the objectives of the event were met?
5.0 Stars
How useful was the information presented at this event?
5.0 Stars
Overall, how satisfied were you with this event?
5.0 Stars
Speaker Performance
Overall, how satisfied were you with this presenter?
5.0 Stars
How closely did the presenter follow the schedule?
5.0 Stars

Reviews From Webinar Survey

Our webinars are crafted to deliver exceptional value and insight to business professionals. To ensure we meet and exceed your expectations, we conduct thorough post live webinar surveys. Below, you'll find genuine feedback from attendees, sharing their thoughts on the event and the speaker's performance. These reviews highlight our commitment to continuous improvement and excellence in providing top-tier educational experiences.

Aurora R.
March 4, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
"This was an exceptional training! I learned things I did not know but always wanted to know. I would attend this training again!"

Aurora R.
March 4, 2019
5.0 / 5
Webinar Rating:
5.0 Stars
Speaker Rating:
5.0 Stars
Do you have any other comments, questions or concerns?
David Ringstrom continues to be my favorite Aurora presenter. His materials are clear and he walks you slowly through the process. I also find his insight and tips far more handy than many other Excel presenters I have encountered.

ATAAA Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.

ATATX Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.

ATAOP Credit

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.