Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Here is Pete's answer to the recent Music Festival Schedule Challenge.
In this video, see how he used Index/Match functions as well as a helper...
Alternate Ways to Select Large and Non-Contiguous Ranges in Excel
Selecting Ranges in Excel
Have you ever had an issue using your mouse to select a large set of data in your Excel spreadsheet? Have...
Leonid’s Friday Challenge Answer – Pipeline Usage Stacked Bar Chart
Here is a late entry :) Thanks Leonid. This is an Awesome response!
Leonid was responding to this recent challenge: Friday Challenge – Pipeline Usage...
3 Ways to Make Excel Chart Horizontal Categories Fit Better
Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable?
Check out this chart to see what...
How-to Make an Excel Chart Go Up with Negative Values
In a follow-up to my recent Terrible Chart Tuesday, I wanted to show you 2 different techniques that you can use to create a...
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...
How-to Hack Excel Protect Workbook Feature When You Forgot the Password
Hack Excel Protect Workbook
So you forgot / lost your password and need to update your workbook tabs or structure? Well don't cry, don't...
Friday Challenge – Make an Excel Movie Database Dashboard
Movie fans are going to love this one. Today, I present to you a full Excel Dashboard challenge.
I am big movie fan. Seen tons...
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?
Notice how the...
Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List
Before we begin, I am going to show...
