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 in distinct units, Don...
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 data.
Pete...
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...
How-to Add a Shape to a PowerPoint Table and Make it Move and Size...
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 words, they just want...
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 noticed a problem. My Excel formula wouldn’t copy correctly to...
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 user puts in...
Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous...
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't take into...
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...
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 currently have a table of various...
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...
