|
|
| Accelerate Excel: Controlling Large Spreadsheets(151104_N) |
Course CPE: 2 hours
Field(s) of Study: Computer Software & Applications–2 hrs
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught. Such persons are often at a mid-level within the organization, with operational and/or supervisory responsibilities.
Advanced Preparation:
Delivery Method: Self-Study
|
Item
Number: 15PPM1104
Shipping Weight: 0lbs. 0oz. |
| Price:
$147.00 |
|
|
|
|
Recording Date: November 4, 2015
Presenter: David H. Ringstrom
Program Description:
Excel expert David Ringstrom, CPA coined the phrase “Either you work Excel, or it works you!” Large spreadsheets often stress users in myriad ways. In this presentation David shows you a number of ways that you can manage large workbooks with aplomb.
Topics typically covered:
- 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.
- Simplify repetitive tasks by creating your own 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.
- Add a drop-down list to your Quick Access toolbar that allows you to toggle custom views on the fly.
- Use the Group and Ungroup feature to expand or collapse
- Save time when aggregating data from multiple worksheets with Excel’s INDIRECT function.
- Master the versatile SUMIF function.
- Use the SUMIFS to sum value based on multiple criteria.
- Use Excel’s OFFSET function to dynamically reference data from one or more accounting periods.
- Learn how range names minimize errors, save time in Excel, serve as navigation aids, and can store information in a hidden location
- Simplify formula auditing by way of the Apply Names feature.
- 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.
After completing this webinar, attendees will be able to:
- Recognize and master Excel features that make managing large workbooks easier
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org. |
|
|
