Daily Bank Balance with a PivotTable


When you download banking activity, you typically get the transactions, but not the daily bank balance. To compute the daily bank balance, you need to summarize the transactions by day and display a running total for all days, even those without any activity. This post demonstrates how to build such a report using a PivotTable. Overview […]

Three Excel University Announcements


I have three exciting Excel University announcements! They are about QBConnect, Top 10 CPE Courses, and Volume 4. First up, QBConnect! QBConnect I’ll be presenting an Excel session at the QBConnect conference in San Jose, and if you are going, I’d love to see you there! The title of the session is Excel: The Power […]

Get & Transform Article


If you haven’t played with the Get & Transform commands in Excel 2016 for Windows, they’re probably worth checking out. I don’t want to sound overly dramatic here, but this set of capabilities is a game changer. These tools provide new ways to approach tasks, and enable us to do things that were previously time-consuming, impractical or required macros. If you’d like to […]

Get & Transform: An Alternative to Finding the Last Delimiter with Formulas


Sometimes, our data has multiple delimiters. Finding the first delimiter with formulas has been pretty easy over the years. Finding the final delimiter hasn’t been as easy…until now. In this post, we’ll use a Get & Transform query to grab the characters after the last delimiter. Objective Before we jump into the mechanics, let’s be clear about […]

Excel University Scholarship Winners!


It is with great pleasure that I’m able to announce this year’s Excel University scholarship winners! The scholarship is supported by Excel University enrollments, so, thanks to all of you who have helped to make this possible. Both of these winners are wonderful examples of the type of accounting student that the Excel University scholarship was […]