How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create...
Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
In this recent post:
Friday Challenge Answers – Cumulative Events Over Time
I created a formula that referenced a table. As I created my video I...
How-to Convert an Existing Excel Data Set to a Pivot Table Format
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...
How-to Fix Security Links Warnings in an Excel Spreadsheet
If you have the yellow bar show up at the top of your Excel Spreadsheet "! Security Warning - Automatic update of links has...
The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Pipeline Challenge Matching Stacked Bar Chart Colors to Products without VBA
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out...
How-to Make an Excel Death Star Pie Chart
While fooling around with Excel, I wondered if I could make an Excel chart look like a the Star Wars Death Star. Well, I...
How-to Find a Wild Card or Question Mark or Asterisk or Tilde in Excel
Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards...
Add % Difference Data Labels to Excel Horizontal Tornado Chart
Okay, the client is always requesting changes. How do you deal with these? I suggest increasing the contracted hours. In this case, I decided...
Add Vertical Line Between Columns in Excel Stacked Column Chart
Add Vertical Line Between Columns in Excel Stacked Column Chart
In this tutorial, you will learn how to QUICKLY add a vertical line between columns...