Blog

Slicers as an Alternative to Conditional Drop Downs

Slicers by Jeff Lenning

Beginning with Excel 2013 for Windows, we can use Slicers to filter table data. In this post, we’ll explore how to use Slicers as a relatively easy alternative to conditional drop-downs. Objective When we want to allow a user to select a choice from a list of items, we often consider using the Data Validation feature to […]



Center Across Selection QAT

Excel’s Merge and Center command has an icon, but, it is often better to Center Across Selection instead of merging cells. Unfortunately, the current version of Excel doesn’t have a Center Across Selection Ribbon icon. In this post, we’ll create a simple macro that we can activate with a Quick Access Toolbar (QAT) icon. Objective Let’s […]


PivotTable Report Group Formatting

In this post, we’ll check out a few PivotTable formatting techniques that help get our report looking just right. Objective Our objective is to create the following PivotTable report. There are a few formatting points to note about the report. First, the region groups, such as Midwest and Northeast, are in the same column as the […]


Income Tax Formula

In this post, we’ll examine a couple of ideas for computing income tax in Excel using tax tables. Specifically, we’ll use VLOOKUP with a helper column, we’ll remove the helper column with SUMPRODUCT, and then we’ll use data validation and the INDIRECT function to make it easy to pick the desired tax table, such as single or married […]




Excel University V3 Course is Available!

I am pleased to announce the immediate availability of the Excel University Volume 3 online course! This online course teaches the content of Volume 3 through online videos, homework activities, quizzes, and includes instructor-moderated forums in case you get stuck. It picks up right where Volume 2 ends. More Info   The topics include PivotTables, external […]



Bullet Graphs in Excel

I recently picked up a copy of Stephen Few’s outstanding book Information Dashboard Design. First of all…wow! If your reports include any type of chart or graph, you owe it to yourself to pick up a copy of this incredible resource. Stephen developed a graph called a Bullet Graph, and in this post, I’ll walk through […]