Carolina Reaper & Ghost Pepper Sriracha Reiviews
Review of 3 products from California Blazing Chile Farms:
Carolina Reaper Sriracha
Ghost Pepper Sriracha
Carolina Reaper Caramels
Excel ASMR RolePlay Stop the Anti-VLOOKUP PEOPLE
/in Videos /by Oz du SoleilYou have been summoned to a meeting to understand your role in a plan to counter the anti-VLOOKUP people. Take it very seriously.
Excel Development: Building the Naughty-Nice-Ometer from scratch
/in Videos /by Oz du SoleilThis is a high speed video that goes through the details of making the Naughty-Nice-Ometer in Excel.
The demo video is here:
Blogpost:
Download the Naughty-Nice-Ometer here:
http://datascopic.net/wp-content/uploads/2014/09/NNOmeter-from-scratch.xlsx
It’s a fun little application but there’s a lot going on in what’s basically a tracker. With modifications this can be used to track and summarize just about anything. You’ll see Excel
– Spreadsheet layout
– Tables
– Formula triggers
– Images that change based on cell values
– Data bars
– SUMIFS
– COUNTIFS
– VLOOKUP
– IF
– Hidden columns
– Adding text to shapes
The original video was 48 minutes. I decided not to bore you with all of that, but it shows that this can be created in less than 1 hour.
Hopefully you’ll get something out of this. Let me know. And please ask questions if you have any.
Image credits:
Santa:
http://artbybones.deviantart.com/art/Santa-Under-the-Northern-Light-24012409
Krampus:
http://www.deviantart.com/art/Krampus-147337943
Use Excel to automatically select the right picture for Christmas
/in Videos /by Oz du SoleilWe’re bringing Excel and technology to Christmas!
In this video I show how Excel can choose the right image based on the contents of a cell.
Thanks to Mynda Treacy for her blogpost that shows how Excel validation can be used to limit the number of entries in a list, and she used a Christmas example.
Let’s have more fun and use Excel to anticipate if a child is going to be visited by Santa or by Krampus. The file can be downloaded here:
http://datascopic.net/wp-content/uploads/2014/09/Naughty-Nice-Ometer.xlsx
Icebucket challenge
/in Videos /by Oz du SoleilI was challenged by Mr Excel and Charlie Vlahogiannis.
I challenge Mike “ExcelIsFun” Girvin, Melanie Williams and Matt Conlin.
Oz at de Maat Theater 27JUN14
/in Videos /by Oz du SoleilPerforming Stand-up at the de Maat Theater at Second City in Chicago. My apologies for the phone-cam quality. :(
Oz Samples the White Castle Sriracha Chicken Slider
/in Videos /by Oz du SoleilIt’s probably unfair for me to review the Sriracha Slider. I had to fix it with Scorpion Pepper Sriracha from California Blazing Chili Farms.
1A – Cooking Calculator Intro
/in Videos /by Oz du SoleilThis 9-video playlist will take you through building this cooking calculator. Originally assembled for a class called Excel Uncensored, the ultimate goal is to take students through many of Excel’s features
The Cooking Calculator itself is only a vehicle to show you
– VLOOKUP
– Tables
– Formula triggers
– Dropdown lists
– Formulas
– Control of cell inputs
– IF statements
… and how to weave them together for a practical purpose.
The Power of Excel & Data: Oz at IgniteChicago
/in Videos /by Oz du SoleilOn 2APR14 I had the honor of being a speaker at IgniteChicago. My topic: The Power of Data
My presentation addresses the question: how did you get started using Excel?
I describe a frustration that I had with a job and how this thing called “Excel” helped turn things around. It was the very first serious thing I did with Excel and data, and it got people to listen.
The format of IgniteChicago is 5 minutes to talk about something you’re passionate about. You get 20 slides and they change automatically every 15 seconds.
Things got a bit raucous–in a fun way. By the time I went up in the 10 spot, we were having a funky good time. So much so that a friend helped create this clean version of my presentation.
To see the original:
To see all 11 presentations:
To learn more and submit a request to speak:
http://www.ignitechi.org/