Blog

Find the Last Occurrence of a Delimiter to Retrieve the Lowest Sub Account from Quickbooks in Excel

In this post, we’ll explore a formula-based approach that does not use VBA to find the last occurrence of a delimiter and use it to retrieve the lowest sub account from a Quickbooks account list in Excel. When I was doing some research for a project I had a couple of years ago, I was […]





Online Excel Lessons

I’m pleased to announce the immediate availability of the Excel University Chapter Evaluation Courses, which are online Excel lessons that cover a single chapter and topic and can be used to evaluate our online Excel training. These mini-classes typically take about 30 minutes to complete, and contain a lecture video, homework activities, the practice Excel […]


Quickly Insert the SUM Function

Let’s face it, Excel users probably insert the SUM function more often than any other function. As you know, we can improve our productivity by keeping our hands on our keyboards. This post discusses my favorite keyboard shortcut for inserting the SUM function. Keyboard Shortcut The SUM function is easily inserted into a workbook with […]


Excel University Volume 2 Course

It is with great excitement we announce the immediate availability of Excel University On-Demand, the online Excel training course that teaches the content of Excel University Volume 2 through videos, homework activities, quizzes, forums, and blogs, in a fun, self-paced and social way. Overview Excel University Volume 2 continues exploring the Excel features, functions and […]


Excel University Volume 2 Now Available!

I am pleased to announce the immediate availability of Excel University Volume 2. The next installment in the series covers a task common to accounting and finance professionals: reporting. Since there are many different types of reports in Excel, let’s dig into the details a bit. This book focuses on how to build hands-free formula-based […]