This is my vlog!

Here you will find stuff that matters, Excel tutorials, and interesting things that I like. Enjoy it!

Drawing or inking in Excel

Ever wanted to draw in Excel? Highlight certain things? The…

Graphing 2 Pieces of Data on 1 Chart (Excel Secondary Axis)

(This grew out of a blogpost on monitoring the fundraising of…

VLOOKUP: Correcting a Myth (Binary Searches)

Many of us have given out bad information about VLOOKUPS. We've…

(Excel 2013: Slicers w/Tables) Slicers to determine trip based on time and budget

A travel agent presented this challenge because she was always…

Excel demo: retrieving current and historical stock data from the web.

http://datascopic.net Excel VBA code programmed to estimate…

Tying a Bow Tie

Oz shows how to tie a bowtie and reminds gentlemen that clip-on…

slicers and pivots to determine trip destination

(This solution requires Excel 2010 (since we use slicers, this…

Pivot Tables as a Diagnostic Tool

This is a companion to a blogpost for EmeryEvaluation.com the…

CSV to clear merged cells in Excel

Someone recently had a huge challenge. He wanted to do analysis…

Keeping Crap Data Out Of Our Dataset: Demo of Excel Data Validation

This is a demonstration of what's possible with Excel's data…