Challenge
Pipeline Usage Chart – Don’s Answer
Here is another response that I received from Don for our recent Friday Challenge: Friday Pipeline Usage Challenge Since we weren’t sure from the client if the pipeline usage had to remain i
EXPLORE THE LIBRARY
Excel Dashboard Templates Home
Challenge
Match Product Chart Colors to Excel Spreadsheet Cells – Pete’s VBA Solution
In the recent Friday Challenge: Create Pipeline Usage Chart A user wanted to create a bar chart where the values had a specific color by product and also matched represented the size of the
Bar Chart
Friday Challenge – Pipeline Usage Chart
I recently got a request from a subscriber that asked if I could help them create a cylinder chart. However the sample that was received looked just like an Excel Bar Chart so I went with th
Excel tutorial
How-to Add a Shape to a PowerPoint Table and Make it Move and Size with the Table Cell
As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives. Typically, company executives don’t want to see lots of wo
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
Array
Challenge Answer – Negative AverageIf for Non-Continuous Range
In our last Friday challenge: Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges I wanted to see how you could also take into account when a us
Averageif
Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges
In a recent Friday Challenge, you were tasked with creating a formula that would work out for a non-contiguous (not connected) range that ignored Zero and Ignored Blanks. But, what we didn
Chart
Things You Cannot Do in Excel Online
Have you had a chance to use Excel Online Yet? Well I have had a little time recently when I was working away from my office with a client. Here is the scenario: A) A User asked me how to do
Challenge
Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge, Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time where a user wanted the following: Creating a graph of cumulative events over time I
Challenge
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
Here is a Friday Challenge that a lot of Excel users may run into. Essentially, you are given a date and incident type that occurred on that date. However, the user wants to take those colu
Help
How-to Quickly Get Excel Function Help Plus a Bonus Tip
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 AverageA Excel function. So I thought I would share how I q
3D Chart
Terrible Chart Tuesday – Excel 3-D Clustered Column Chart
Welcome to another edition to Terrible Chart Tuesday. Here we see an example of what I think is a Terrible Chart that was create in Excel. What do you think? Let me know in the comments be