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...
Friday Challenge – Data Transformation
This weekend starts the ModelOff competition.
"ModelOff is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis and Financial Modelling." -Modeloff Site
If...
Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers
In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set. They...
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 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...
Do you have an Idea to Make Excel Better? Excel’s Suggestion Box is...
Great Ideas Wanted
Have you heard of Excel's Suggestion Box?
I just ran across this awesome user community feedback tool that Microsoft is using to gather...
How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel
How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel
On my post How-to Create a Stacked and Unstacked Column Chart I received...
The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Stop Excel Overlapping Columns on Second Axis for 3 Series
We have learned how to Stop Excel Overlapping Columns in a few posts on the site. A reader had a follow-up question that I...
How-to Create a Stacked Clustered Column Chart with 2 Axes
In response to another post of mine, EC wrote:
“My issue: This site has been really helpful so far! I have a follow up question....
