29

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

Do you spend time doing any of the following tasks in Excel?

• Finding and navigating to worksheets.
• Flipping back and forth between two sheets.
• Hiding and unhiding multiple sheets.
240

## How To Copy & Paste Visible Cells Only

Have you ever tried to copy and paste a range with hidden rows or columns and didn’t get the results you expected?

19

## How To Compare Multiple Lists of Names with a Pivot Table

In this post I will explain how to compare two or more lists of names using a Pivot Table.

15

The INDEX function is commonly used in combination with the MATCH function to provide powerful and dynamic lookup formulas.

This post will just focus on explaining the how the INDEX function works.  It is best to understand the basics of INDEX before creating more advanced formulas using INDEX & MATCH.

56

## VLOOKUP & MATCH – A Dynamic Duo

This post provides an explanation of how to use the VLOOKUP and MATCH functions to give you better control over how the column index number changes.  This is often referred to as a dynamic formula.  You will learn how this dynamic duo can help prevent errors and improve your VLOOKUP formulas.

## Here's a Video Playlist Post Example

Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra.

## A Video Embed Post

Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo. Quisque sit amet est et sapien ullamcorper pharetra.

129

## VLOOKUP Example Explained at Starbucks

Bottom Line: Learn how the VLOOKUP function works with this simple explanation and example using a Starbucks menu.  You can download an example file below to follow along.

Skill Level: Beginner to Expert

221

## 7 Keyboard Shortcuts for the Filter Drop Down Menus

This post will explain 7 keyboard shortcuts for the filter drop-down menus.  This includes my new favorite shortcut, and it’s one that I think you will really like!

86

## 5 Excel Keyboard Shortcuts for Font or Fill Colors

This article explains all the possible ways to apply font or fill (background or shading) colors using keyboard shortcuts, including a way to customize your own.