Excel Vids

1: Cells, Ranges, and Functions

2: Named Ranges

3: Sorting Data

4: Filtering

5: Advanced Filtering

6: Combo Charts

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 1 Frequency Distribution, Graphing Categorical data, Bar Graph, Excel pivot table File Download

Excel: Stats Tables and Graphs Part 2 Frequency Distribution, Graphing Quantitative data, Excel pivot table, Histogram.

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

How to use vlookup in Excel A quick introduction to exact and range vlookups in Microsoft Excel. *FILE*


Watch the playlist here! ☺