#table

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

Timelines

What are timelines? How do you create one? I'll show you how to present dates in an interactive format.

With great control comes great responsibility - Slicers Part 2/2

In this final part of this two-parter, I'm going to show you how to use one slicer to control more than one pivot table.

Slice & Dice - Slicers Part 1/2

What are slicers? In this two-part series, I'm going to show you how to create slicers and how to use one slicer to control more than on

How to remove table functionality

Created a table and then later decided that you no longer want the “table functionality”? Learn how to remove a table's functionality at

INDEX-MATCH

INDEX-MATCH is more flexible and powerful than VLOOKUP as it doesn't have the limitations of VLOOKUP. It is a combination of two formula

Mastering VLOOKUP

VLOOKUP is probably one of the most commonly used but hated formulas. Having broken down the formula for you, let's learn it right for o