Excel Tutorials (Blog)

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

Paste Data Over Existing Data

Keyboard Shortcuts, Tips, Tips & Shortcuts

How To Jump to the Last Cell in a Selected Range

August 6, 2014

Tab Hound Window Features Diagram

Add-in, Macros & VBA, Tips, Tips & Shortcuts

The Tab Hound and Tab Control Add-ins for Excel

August 5, 2014

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