Hackers and Slackers (Page 1)

Excel spreadsheet containing data

Excel Data Manipulation: a Guide For Everyone

Introduction to Excel Data Manipulation using TEXTJOIN and Macros.

How I Stopped Worrying and Learned to Love the Formula

How I Stopped Worrying and Learned to Love the Formula

Learn to define and utilize Excel formulas.

Excel Showdown: Index Match vs. The Lookups

Excel Showdown: Index Match vs. The Lookups

Learn to hate V-Lookups and H-Lookups in favor of Index Match.

The One Excel Formula to Rule Them All

The One Excel Formula to Rule Them All

Unlock the secrets of Excel's Index Match.

Depiction of Pivot Tables within Excel

The Art of Excel Pivot Tables

Pivot complex Excel spreadsheets to summarize your data.

Adventures in Excel: Power to the Pivot

Adventures in Excel: Power to the Pivot

Power up your Excel Pivot Tables with these pro moves.

Doing the Excel Data Dance

Doing the Excel Data Dance

Taking a step back to reflect on the problems Excel intends to solve.

Dealing with Dirty Data in Excel

Dealing with Dirty Data in Excel

Cleaning data Excel in the absence of tools designed to do so.

Taking Out the Trash: Dirty Data in Excel

Taking Out the Trash: Dirty Data in Excel

Dealing With Dirty Data in Excel (continued).

Getting Iffy With it: Conditional Statements in Excel

Getting Iffy With it: Conditional Statements in Excel

Effectively utilize conditionals such as IF statements in your Excel workflow.