Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Excel Features No Accountant Can Live Without
Summary
In this dynamic, 60-minute program, Excel expert David Ringstrom, CPA demonstrates the best features in Excel that will make even the most experienced accountants more productive. Learn how to tame unwieldy worksheets, shortcuts that will save you time, and gain must-have tools to ensure accurate reports.
Join us to discover how to:
- Utilize Excel tools and features every accountant should know
- Avoid top Excel time-wasters that frustrate accountants
- Use Excel’s Table feature to process and analyze data faster
- Save time with must-know tips and shortcuts
- Prevent duplicate work with Conditional Formatting
- Bonus: All registrants will receive an Excel workbook that contains the demonstrated features
Program Highlights
Data Analysis Techniques for Accountants
- Improving the integrity of spreadsheets with Excel’s XLOOKUP function
- Creating a pivot table to transform lists of data into on-screen reports
- Adding fields to a blank pivot table to create instant reports
- Identifying duplicates in a list using Conditional Formatting
Time-saving Features You Can’t Miss
- How the Table feature improves the integrity of Excel spreadsheets
- Streamlining filtering of lists and using the Slicer feature with tables
- Gaining control of long lists of data by filtering instead of sorting
- Creating custom views to hide or display selected worksheets
- How you may be able to recover work after an Excel crash
Managing Time-wasters that Slow You Down
- Overcoming user interface annoyances with simple adjustments
- Jump-starting data visualization with the Quick Analysis feature
- Discover new worksheet functions available in Microsoft 365
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 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 presentations.
Program Benefits
Discover techniques that will enable you to work more efficiently, get the information you need faster, and avoid annoying time-wasters by using Excel’s best tools for Accountants.
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
Credit Hours:
1Field of Study:
Computer Software & ApplicationsProgram Level:
IntermediatePrerequisites:
NoneAdvance Prep:
NoneDelivery 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 Features No Accountant Can Live Without
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.
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.
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.
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.
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.
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.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
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.
