How-To
Excel Pranks: Non-VBA Edition 1
We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have fun than with some pranks. And better yet, Excel Pranks. I saw a great thread
EXPLORE THE LIBRARY
Tag
Chart
How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on a chart”. Here is the basis of the question at hand: “I’m not su
Formatting
How-to Display Military Time in an Excel Spreadsheet
A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel. It is pretty simple to display in Excel but only if you know how Excel treats tim
Chart
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
Chart
How-to Insert Slicers into an Excel Pivot Table
In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post,
Chart
Think Like a Database Designer Before Creating an Excel Dashboard Chart
Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so I thought I would share those concepts with you. Now, let me pr
Excel tutorial
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid 🙂 for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart Here was
Challenge
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is not date based, but time based. The use case is a medical study on s
Area Chart
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 the challenge here: Original Challenge: friday-chal
Copy
Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
Facebook Twitter Pinterest WhatsApp Linkedin 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