Excel Tutorials (Blog)

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

Tab Control Step 3 Run Update Excel Automation

Tips, Tips & Shortcuts

How To Automate Common Processes in Excel with Tab Control

July 30, 2014

Organize Excel Thumbnail

Tips, Tips & Shortcuts

How To Organize & Manage Your Worksheets – Tab Hound & Tab Control

July 23, 2014

Table of Contents Add Descriptions

Tips, Tips & Shortcuts

How To Save Time with Everyday Excel Tasks – the New Tab Hound Add-in

July 22, 2014

Copy Paste Select Visible Cells in Excel

Keyboard Shortcuts, Tips, Tips & Shortcuts

How To Copy & Paste Visible Cells Only

July 16, 2014

How To Compare Lists of Names with Pivot Table

Pivot Tables

How To Compare Multiple Lists of Names with a Pivot Table

July 7, 2014

INDEX Function Explained Step Result

Formulas

The INDEX Function – A Road Map For Your Spreadsheet

June 12, 2014

Match Explained Step 3 - Match Type

Formulas

VLOOKUP & MATCH – A Dynamic Duo

May 29, 2014

Excel VLOOKUP Explained at Starbucks 1-2-3

Formulas

VLOOKUP Example Explained at Starbucks

May 13, 2014

Excel Filter Drop Down Menus Excel 2013

Excel Ribbon, Keyboard Shortcuts, Tips & Shortcuts

7 Keyboard Shortcuts for the Filter Drop Down Menus

April 29, 2014