This is my vlog!

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

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…

Oz Reviews Sriracha Lays Potato Chips

Pleasantly surprising. As a lover of sriracha, I had to try these…

Excel 2013: Slicers & Tables

UPDATE: Mac users have Slicers as of Excel 2016 New in Excel…

VLOOKUP w/TRUE to assign dates in custom periods

Here's an example of using True in a VLOOKUP because an approximate…

Sampling Jim's Habanero Ghost Cheese

Oz du Soleil samples Habanero Ghost Pepper Cheese from Jim's…

Generating Random Data to Set Up a Pivot Table Tutorial

Blogpost associated with this video: http://datascopic.net/generate-data/ Often…

Basic Excel Table Demo

Simple use of Excel Tables

Basic Demo of Excel Tables to Warn of Upcoming Deadlines

Quick video to show the use of Excel tables, and how a table…

Excel Inventory Control System DEMO

This video shows an Inventory Control System that was built in…