Excel Development: Building the Naughty-Nice-Ometer from scratch
199 views · Published 25 September 2014 · 12:53 · Indexed 5 October 2026
Channel: Excel On Fire (Oz du Soleil) · 2014 · Education
This is a high speed video that goes through the details of making the Naughty-Nice-Ometer in Excel. The demo video is here: http://www.youtube.com/watch?v=fpI3b5ETti8 Blogpost: http://datascopic.net/santa-or-krampus/ 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
More from this channel
-
5:03
Basic Excel Table Demo
-
10:28
Generating Random Data to Set Up a Pivot Table Tutorial
-
4:13
slicers and pivots to determine trip destination
-
8:23
Excel Data Validation: Why It's Important
-
3:41
Excel demo: retrieving current and historical stock data from the web.
-
5:45
Sriracha Taste Test 2: Sky Valley, Saigon Sisters & Lee Kum Kee
-
9:18
converting columnar data to sortable rows
-
5:09
The Power of Excel & Data: Oz at IgniteChicago