This is my vlog!

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

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…

VLOOKUP: compare lists and retrieve information

I was asked for my Top 5 Excel Functions. Number 2 is VLOOKUP. This…

Kurt & Oz Making Ice Cream with Liquid Nitrogen

This afternoon Kurt and I experimented with liquid nitrogen,…

Using Dummy Data in Excel. Also: Pivot Table and VLOOKUP

(It's best to view this "Large" rather than the small default…