Reclaiming Large Excel Spreadsheets

David Ringstrom
Instructor:
David Ringstrom
Duration:
60 Minutes
Product Id:
500474
Access:
6 months

More Trainings by this Expert

Price Details
$152 Recorded
Price Detail Options
Overview:

You've likely experienced the "blur" that sets in when you're working in a large spreadsheet. Or the frustration in tasks that consume far more time in Excel than you feel they should.

You'll be able to arrange two or worksheets onscreen at the same time, instead of repeatedly clicking back and forth between worksheet tabs. An unsung feature in Excel is the Custom Views feature that lets you hide and unhide rows/columns/worksheets with ease, as well as store different print settings for a single worksheet. Few users capitalize on the Watch Window feature which offers both monitoring of key worksheet cells but also instant access with a simple double-click. The Watch Window also doubles as a spreadsheet auditing feature. Excel is full of hidden nuances, such as the ability to bring back the full-screen Print Preview window in Excel 2010 and later, instead of suffering eye-strain and frustration with the Backstage print preview window on Excel's File menu. Many repetitive tasks in Excel are avoidable. For instance, you can reduce the repetitive tasks of manually freezing certain rows on screen from reports that you export daily from online systems such as CRM software or accounting packages down to a single keystroke.

You'll also see how to tamp down the size of large workbooks, in some cases back to a level where they can be emailed. This technique can also improve the performance of calculation-intensive workbooks. David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience.

Why should you Attend: Large spreadsheets slow users down in numerous ways. Navigating through large worksheets or workbooks often makes data blur, leading to unnecessary fatigue and loss of perspective. Other ripple effects such as unnecessary keyboard and mouse actions cause wrist strain-but this doesn't have to be your experience in Excel. In this webinar you'll learn about techniques and features-some hidden, others simply overlooked-that can enable you to finesse even the most unwieldy data sets and spreadsheets. Learn efficiencies that you can apply immediately from an expert who has spent more than two decades immersed in spreadsheets of all shapes and sizes.

Areas Covered in the Session:

  • See how to arrange two worksheets from within the same workbook onscreen at the same time.
  • Avoid repetitive work by creating a keyboard shortcut for Excel's Freeze Panes feature.
  • Use the Watch window to easily monitor the ramifications of even minor changes to your workbooks.
  • Navigate large workbooks with ease by way of a hidden menu, as well as keyboard shortcuts.
  • Learn the power--and the risks--of grouping worksheets.
  • Use Excel's Custom Views feature to hide and unhide multiple worksheets with ease.
  • Restore "classic" Print Preview functionality to Excel 2007 and later.
  • Learn tricks to simplify printing information from large workbooks or worksheets.
  • Learn techniques that let you reduce the file size of bloated Excel workbooks.

Who Will Benefit:
  • CFOs
  • Controllers
  • Investment Analysts
  • Financial Analysts
  • Business Analysts
  • Forecasting & Planning
  • M&A Specialists (Mergers & Acquisitions)
  • Risk Managers
  • Strategic Planners
  • Capital Expenditure Planners
  • Cost Accountants
  • Managerial Accountants


Speaker Profile
David Ringstrom CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 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.


You Recently Viewed