Quantcast
Home Tags Tips and Tricks

Tag: Tips and Tricks

How-to Draw a Straight Line with Excel Shapes

4
Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating :) to be off by...

Excel Pranks: Non-VBA Edition 1

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

How-to Make a Music Festival Schedule Using Excel Conditional Formatting

4
Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts. However, he originally created the...

How-to Create a Dynamic Excel Pivot Table Dashboard Chart

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

Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution

0
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 Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook

3
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook.  However, if you create...

Pipeline Challenge Matching Stacked Bar Chart Colors to Products without VBA

2
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

8
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 Quickly Get Excel Function Help Plus a Bonus Tip

0
In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the...

How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)

2
In are recent post, I showed you how to create a Bullet Chart in Excel.  Pete, then sent me another way to create a...
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