Links to Excel Video Tutorials & Blogs that I’ve Created For YOU (sometimes while having a cigar)! All links on this page are videos unless designated with b for blogpost.
General Excel Knowledge
- Excel 2013: Tables w/Slicers
Drawing in Excel with the Inking Feature
Introduction to Using Tables - Making a Graph with a Secondary Axis
- Tables & How A Table Can Be Broken
- Using VLOOKUP w/True for Approximate Matches
- Generating Dummy Data for Testing Solutions
- Normal Dropdown & Dependent Dropdown Lists
- Using Dummy Data w/Pivot Tables & VLOOKUPS
- Get Excel to Stop Turning Numbers Into Dates
- Force Graph to Start at a Number Other Than Zero
- Relative & Absolute Cell References
- AGGREGATE: manage guest RSVPs & un-RSVPs
- Using YEARFRAC to Calculate Paid Time Off
Top 5 Excel Functions to Know
- Top 5 Excel Functions Overview b
- #1: IF Statement b
- IF Statement
- #2: VLOOKUP b
- VLOOKUPS: Comparing Lists
- #3: OPERATORS: AND/OR b
- #4: IFERROR b
- IFERROR
- #5: SUMIFS b
- SUMIFS
Tips & Fixes
- Excel Date Formatting
- Controlling Text in a Cell
- Converting a Report Into Sortable Data
- Percents, Decimals & IFERROR
- EOMONTH & Clear a Worksheet of Zeros
- Using Pivot Tables to Check Data Quality
- Discussion of the Importance of Validation & Data Quality
- ‘Save as CSV’ to clear all merged cells from a worksheet
- Data Explorer & Pivot Chart to retrieve data from the internet and create bar chart
- OFFSET for converting a column of data into sortable rows
- The Importance of Keeping Data in One Place
- Logarithmic Chart Axis: Presenting Data That has a Wide Range Between the Highest & Lowest Values
- Excel 2013 Data Model: Treating 3 Data Ranges Like a Single Data Range
- Array Formula: Calculate the closest due date of a list of tasks
App Demonstrations
- Inventory Control System
- User Form w/Commissions Tracker & Birthday Tickler
- Examples of Validation Methods that Help Keep Our Data Clean
- Excel retrieves historical stock data from the internet
- (Excel 2010 Solution) Limit vacation destinations by budget and time available
- (Excel 2013 Solution) Limit vacation destinations by budget and time available
- Naughty-Nice-Ometer for measuring children’s behavior before Christmas
