1: Cells, Ranges, and Functions
2: Named Ranges
3: Sorting Data
5: Advanced Filtering
6: Combo Charts
7: If, Ifs, AND, OR, & NOT
8: VLookup & HLookup
More Excel Tips and Tricks: Link to Playlist
Here are some other Excel tutorials I have made, mostly in response to questions people have asked me.
Excel: Stats Tables and Graphs Part 2 Frequency Distribution, Graphing Quantitative data, Excel pivot table, Histogram.
Make Pie Graphs and Frequency Distributions in Excel: Categorical Data COUNTIF and Pivot Tables, and Pie Graphs File Download
Excel Mega Selector: CheckBox to Highlight Scatterplot Points I created an Excel Spreadsheet with over 1,000 checkboxes, to allow you to highlight points in a scatterplot... or do whatever else you'd like to do with them. File Download
Excel Match Function: How can we find numbers that repeat across columns? In response to a reddit statistics question: How can you find numbers that repeat in different columns? Here is my solution. File:MatchFunction.xlsx
Watch the playlist here! ☺