Create Dependent Drop-down Lists with Conditional Data Validation

This post explores macro-free methods for using Excel’s data validation feature to create an in-cell drop-down that displays choices depending on the value selected in a previous in-cell drop-down. Overview As with just about anything in Excel, there are several ways to achieve the goal. This post explores three such solutions, and if you have a […]

Volume 3 Table of Contents

Excel University Volume 3 is far enough along for me to share the table of contents. I have to say, I’m very excited about this volume as we cover some very cool things. I can’t wait for this volume to make its way through the editing and interior design stages. We are targeting a Q3 […]

Use the Column Header to Retrieve Values from an Excel Table

This post discusses ways to retrieve aggregated values from a table based on the column labels. Overview Beginning with Excel 2007, we can store data in a table with the Insert > Table Ribbon command icon. If you haven’t yet explored this incredible feature, please check out this CalCPA Magazine article Excel Rules. Frequently, we […]

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 […]