Quantcast
Home Tags Video Tutorial

Tag: Video Tutorial

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...

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 And then I...

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, we explore the...

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...

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...

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...

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...

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 AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel

In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude...

How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4...

This is an awesome guest post from our great friend Pete.  He came up with this awesome technique to make a dynamic pie chart...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link