Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Automations that Boost the Quality of Your Excel-Based Financial Statements

Share

Summary

Do you build cumbersome Excel worksheets for each month of the year when it comes to financial statements?

Are you worried about the integrity and accuracy of your Excel-based statements?

Do your workbooks often result in worksheet creep – deeming them a practically unusable database or report?

If you answered yes to any of these questions, this workshop is for you.

Join Excel expert and CPA, David Ringstrom, for this workshop to create dynamic accounting reports for any month of the year on a single worksheet. As an alternative to too many worksheets, he will explain how to use Excel functions, such as OFFSET and SUMIFS, to quickly create accounting reports that can be toggled to any reporting period with only two mouse clicks. In addition, he outlines how to export data from your accounting package, improve the integrity of your spreadsheets, and how to consolidate reports from two or more departments or entities. Much of the discussion shows how to use Power Query in Excel to clean-up and combine reports from accounting software and other sources.

In this workshop training, you’ll learn how to:

  • Create dynamic sums with the OFFSET function for increased efficiency
  • Use Power Query to create self-updating spreadsheets to minimize your manual tasks
  • Use Power Query to quickly clean up issues in reports exported from accounting software
  • Create in-cell dropdown lists with Data Validation for increased accuracy

Program Highlights

Overcome common issues in exported reports:

  • How to build a 12-month Profit & Loss report that looks just like QuickBooks
  • Learn the most efficient way to consolidate financial statement exports from two or more entities into a single list

Cut down on manual updates and tasks:

  • Create self-updating financial spreadsheets with automated queries
  • Automate the extraction of data for a given month or year to date
  • Create a workbook with just two worksheets that will present data for any month of the year
  • Functions you should be using to automate more in your reports

Increase the accuracy of your Excel-based reports:

  • Create an in-cell list for better data validation
  • Discover how to incorporate Check Figures and Alarms into your work
  • Use a refinement feature to be able to toggle your display of company-wide and departmental numbers

About The Speaker

David H. Ringstrom, CPA is a nationally recognized Microsoft Excel expert as well as the president and founder of Accounting Advisors, Inc. based in Atlanta, Georgia. He founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel.

David demonstrates every technique at least twice, so you leave his trainings ready to execute. First, he’s goes over the technique on a Point slide with numbered steps, and second, in the subscription-based Microsoft 365 version of Excel. He draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Program Benefits

When you leave this workshop training, you’ll be able to:



  • Create accounting reports for any month of the year on a single worksheet

  • Apply Conditional Formatting to draw attention to reports that don’t balance to the source data

  • State how to export data from an accounting package to create a “set-and-forget” link to accounting data in Excel

Purchase this On-Demand Workshop

Automations that Boost the Quality of Your Excel-Based Financial Statements

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.

Purchase This On-Demand Webinar

Automations that Boost the Quality of Your Excel-Based Financial Statements

On-Demand $199 + applicable taxes
3 Workshop Bundle $300 + applicable taxes
One-year subscription (All Access Membership) $699 + applicable taxes
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.

HRCI Credits

HRCI logo

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

Credits

NASBA logo
Credit Hours:
1
Field of Study:
Accounting
Program Level:
Basic Knowledge
Prerequisites:
None
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

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.