4

## Tab Hound Features Update – Version 1.5

This post will explain some of the new features that have been added to the Tab Hound Add-in recently.

85

## How To CONCATENATE a Range of Cells + VBA Macro

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

4

## Why Take an Excel Online Course When YouTube is Free?

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.

24

## Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

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. 🙂

18

## How To Use Power Pivot Instead of VLOOKUP

In this post I will explain how you can use Power Pivot instead of VLOOKUP to save time and analyze your data in new ways.

6

## How To Sum All Columns in the Total Row of an Excel Table

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.

73

## 5 Ways to Use the VBA Immediate Window in Excel

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.

10

## Resize Plot Area in Excel Chart – Titles and Labels Overlapping

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.

20

## How To Create a Sales Pipeline Funnel Chart in Excel

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.

## Tab Hound & Tab Control for Mac – Now Available!

That’s right Mac users!  The wait is finally over…

The Mac versions of the Tab Hound and Tab Control add-ins are now available.