Bottom line: Learn two different ways to quickly (join) concatenate a range of cells. This includes the Ctrl+left-click method, and a free VBA Macro that makes it quick & easy to create the concatenate or ampersand formulas.
Skill level: Intermediate
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.
This post contains a free VBA Macro that will convert any pivot table into a report containing SUMIFS, COUNTIFS, or AVERAGEIFS formulas. If you want a very quick way to create a long SUMIFS formula, this is your ticket. 🙂
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.
The VBA Immediate Window is an awesome tool that allows you to get immediate answers about your Excel files, and quickly execute code. It is built into the Visual Basic Editor, and has many different uses that can be very helpful when writing macros, debugging code, and displaying the results of your code.
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.
This post explains how to make a funnel chart in Excel. This chart can be created in 5 simple steps using a stacked bar chart.