Bottom line: It can be difficult to see the variance between two lines on a line chart. In this post I explain some alternative techniques to help highlight variances.
Skill level: Beginner
Bottom line: Learn how to create cascading or dependent drop-down lists (also known as cascading validation) in Excel. This technique does NOT require named ranges. If you don’t mind using named ranges then there are a few links at the bottom of the page with solutions that will be easier to implement.
Skill level: Intermediate
Functions used: OFFSET, MATCH, COUNTA, COUNTIF, INDIRECT Continue reading
I received a lot of great questions about the Dashboard and PowerPivot courses from MyOnlineTrainingHub. I’m guessing that you might have these same questions, and in this post I will try to provide some answers.
In this post and video I explain how to add the sum (subtotal) to all the cells in the Total Row of an Excel Table.
This post and video answers a question on how to resize the plot area of a chart to prevent the axis titles and labels from overlapping. If you can’t read the titles or labels this tip will help cleanup your chart to make it more presentable.