Key Take Away:
Learn about techniques and features-some hidden, others simply overlooked-that can enable you to finesse even the most unwieldy data sets and spreadsheets.
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.
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 workbooks.
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 Excel spreadsheet templates of all shapes and sizes.
Areas Covered In This Webinar:
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
Learning Objectives:
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 Analysts
Mergers & Acquisitions Specialists
Risk Managers
Strategic Planners
Capital Expenditure Planners
Cost Accountants
Managerial Accountants
For more information, please visit :
https://www.atozcompliance.com/trainings-webinar/banking-financial-services/accounting-taxation/reclaiming-large-excel-spreadsheets/david-ringstrom/300077
Email: support@atozcompliance.com
Toll Free: +1- 844-414-1400
Tel: +1-516-900-5509
Level:
Intermediate
Speakers Profile:
David Ringstrom
David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David's catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.
Comments