High Impact Excel: Tips and Tricks for All Excel Users

About The Instructor
David Ringstrom, CPA is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. He teaches dozens of webinars each year and speaks at conferences on Excel, along with writing freelance articles about spreadsheets that appear internationally. Webinar attendees are often amazed by how much ground David can cover in a short period of time. He is quite fond of saying, "Either you work Excel, or it works you!"

Upcoming Webinars

In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Coming up on 09/24/14Register Now
Many Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages.
Coming up on 10/30/14Register Now
In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets. Users often get stopped in their tracks by disabled features, inscrutable error prompts, or just quirky behavior in Excel.
Coming up on 11/18/14Register Now
Do you work Excel? Or does it work you? In this presentation Excel expert David Ringstrom, CPA focuses exclusively on how to perform repetitive tasks more efficiently in Excel. Hidden techniques abound in Excel, as a simple double-click or right-click with your mouse can uncover hidden...
Coming up on 12/10/14Register Now

Articles by David Ringstrom

Posted on 08/07/14
My unscientific observation is that the SUM function is likely the most used—and abused—of all worksheet functions in Excel. Although the SUM function is far better than manually adding...
Posted on 08/04/14
Alt-Down Arrow is one of my favorite keyboard shortcuts in Excel. First off, it gives me an easy means to speed through repetitive data entry within a column. Second, it allows me to access Excel...
Posted on 06/19/14
As you're most likely aware, it's easy to instantly create a list of days of the week or months of the year. Simply type either the first three letters or the full name of a day or month in a...
Posted on 06/12/14
I’ve been tracking solid state drives (SSD) for years now, always thinking they were beyond my financial grasp. I finally chose to make the leap recently, thanks in part to a brief mention of...
Posted on 06/09/14
Recently I lamented that Excel has functions like SUMIF, COUNTIF, and AVERAGEIF, but that it didn’t have the equivalent of a MAXIF function. I then described a valid technique that involves...
How do I get CPE? >>
Qualifying for CPE is easy. Just follow these three simple steps.
  1. Register for the webinar of your choice from the "Upcoming Webinars"
  2. Attend the live session for at least 50 minutes.
  3. Answer 3 polling questions that pop up on your screen during the session.
That's it! We track your time and your answers and you receive your credit by email within one week at the address you used to register.

CPE credit is only available during the live event. Recordings of past webinars do not qualify for credit.

Past Webinars

Took place on 08/28/14
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
Took place on 07/24/14
In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.
Took place on 07/31/14
In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Took place on 06/26/14
In this presentation Excel expert David Ringstrom, CPA covers Excel for iPad from top to bottom. In one hour you'll learn everything you can—and cannot—do in Excel for iPad. You'll be able to determine whether Excel for iPad is worth $99/year to you or not.
Took place on 05/29/14
In this presentation Excel expert David Ringstrom, CPA brings you up to speed on the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well. Uncover power of this feature, but...
Took place on 04/24/14
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Took place on 04/17/14
In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!
Took place on 03/25/14
In this session Excel expert David H. Ringstrom, CPA shares numerous techniques that you can use to work with charts more efficiently.
Took place on 02/27/14
In this session Excel expert David Ringstrom introduces beginners to the VLOOKUP function, and then go beyond the basics with a discussion of with the MATCH, CHOOSE, INDEX, SUMIF, SUMIFS, and SUMPRODUCT functions.
Took place on 01/30/14
In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!

Pages