Excel for Accountants: Boost Accuracy & Efficiency Beyond 2024
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!
SHRM Credits
Premier Learning Solutions is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CP® or SHRM-SCP®. This program is valid for 1 PDCs for the SHRM-CP® or SHRM-SCP®. For more information about certification or recertification, please visit www.shrmcertification.org.
HRCI Credits
This program has been approved for 1 (HR (General)) recertification credit hour toward aPHRTM, aPHRiTM, PHR®, PHRca®, SPHR®, GPHR®, PHRiTM and SPHRiTM recertification through the HR Certification Institute. Learn more at hrci.org
Purchase this On-Demand Workshop
Excel for Accountants: Boost Accuracy & Efficiency Beyond 2024
$199 + applicable taxes
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.
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.
$300 + applicable taxes
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.
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.
$699 + applicable taxes
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.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
$899 + applicable taxes
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.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
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.
