Excel for Accountants: Boost Accuracy and Efficiency

Summary

Many accounting and finance professionals are unaware of the full range of Excel’s features and functions they can utilize to improve the accuracy and efficiency of their spreadsheets.

 

In this comprehensive 100-minute webinar, Excel expert David Ringstrom, CPA, will share those valuable Excel fundamentals that will enable accounting professionals to do more with their spreadsheets.  

 

You will walk-away with tips and techniques that save you time, and truly empower you to work smarter – not harder!

 

 You will leave this program knowing how to:

  • Save significant time by automating manual tasks
  • Utilize templates to create dynamic spreadsheets
  • Summarize pertinent data for quicker and easier analysis
  • Use must-know keyboard shortcuts to fly through spreadsheets
  • Salvage crucial data by repairing damaged Excel workbooks
  • Take your Pivot tables to a whole new level like a pro

Bonus: Excel reference workbook demonstrating the techniques taught

Program Highlights

Automate, Automate, Automate: Dramatically Increase Your Productivity

  • Jump-start your spreadsheets with ease by utilizing prebuilt templates
  • Use Excel’s Data Table feature to avoiding writing repetitive formulas
  • Automate chart resizing using tables – no more manually resizing!
  • Insert totals into lists with a few mouse clicks using the SUBTOTAL function

Powerful Worksheet Functions to Easily Access Data

  • AGGREGATE function vs. SUBTOTAL function: When to use them
  • Quickly sum values related to multiple instances of criteria you specify
  • Simple design technique to improve the integrity of Excel’s SUM function

Save Time with These Little-know Spreadsheet Techniques

  • How the Table feature empowers you to safeguard spreadsheets
  • What steps to take if you can’t open a damaged workbook
  • Leverage Excel’s quick access toolbar & filter lists with a simple keystroke

Question & Answer Session – Have your specific questions answered!

About The Speaker

David H. Ringstrom, is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started back in 1991.

  • He is an author, Microsoft Excel spreadsheet expert, and consultant.
  • David teaches over 200 live webinars on Excel each year, and has written articles on spreadsheets that have been published internationally. He is the co-author of “Idiot’s Guide: Introductory Accounting” and has served as the technical editor for dozens of books in the “QuickBooks for Dummies” series.
  • Attendees often speak highly of David's well-prepared handouts that provide numbered steps that you can follow to carry out the techniques that he presents during his webinars.

Program Benefits

In this 100-minute program, you will learn how to save valuable time and avoid headaches by learning invaluable Excel tips, techniques, and shortcuts to better navigate masses of financial data. You will be able to work more efficiently, plus share pertinent data more clearly with decision makers.

If you'd like this program customized for your organization, call us at 1-800-964-6033. We're certain we can fulfill your training needs, while making it fit in your budget!

Credits

NASBA logo
Credit Hours:
2
Field of Study:
Finance; Computer Software & Applications
Program Level:
Intermediate
Prerequisites:
Prior Experience with Microsoft Excel
Advance Prep:
None
Delivery Method:
Group Internet Based
Progressive Business Conferences 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

Purchase this On-Demand Workshop

Excel for Accountants: Boost Accuracy and Efficiency

On-Demand $199 + applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 + applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 + applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

Full-Team Pass

Simply share the invite link with your team so you can learn and grow together!

Yours Forever

The event recording and materials are yours to rewatch and share as you choose.