Excel Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles and videos.

Create Concatenate Formula for Range of Cells with Concatenate Macro in Excel

Formulas, Keyboard Shortcuts, Macros & VBA, Tips & Shortcuts, Tools

How To CONCATENATE a Range of Cells + VBA Macro

October 24, 2014

Answers, Charts & Dashboards, Pivot Tables, Power Pivot, Power Pivot/Query/BI, Tips, Tips & Shortcuts

Why Take an Excel Online Course When YouTube is Free?

October 16, 2014

Create Copy of Pivot Table and Convert to SUMIFS Formulas

Formulas, Macros & VBA, Pivot Tables, Tables & Data

Convert Pivot Table to SUMIFS Formulas – Free VBA Macro

October 14, 2014

PowerPivot Instead of VLOOKUP Excel Showdown

Formulas, Pivot Tables, Power Pivot, Power Pivot/Query/BI

How To Use Power Pivot Instead of VLOOKUP

October 6, 2014

Sum Each Column of the Total Row in Excel Table

Answers, Formulas, Tables & Data, Tips, Tips & Shortcuts

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

September 30, 2014

VBA Immediate Window Excel Worksheets Count

Add-in, Macros & VBA

5 Ways to Use the VBA Immediate Window in Excel

September 23, 2014

Excel Chart Titles Overlap Axis Labels

Answers, Charts & Dashboards

Resize Plot Area in Excel Chart – Titles and Labels Overlapping

September 16, 2014

Sales Pipeline Funnel Chart Excel How To Guide

Charts & Dashboards

How To Create a Sales Pipeline Funnel Chart in Excel

August 18, 2014

Tab Hound for Mac Window Options Button

Add-in, Macros & VBA

Tab Hound & Tab Control for Mac – Now Available!

August 11, 2014