Sorting Data - Transcript

In this tutorial, we walk you through how to quickly sort all data in an Excel Spreadsheet. Demo Spreadsheet:

https://docs.google.com/spreadsheets/d/1ik7f7eW3SRFgh4GC4EwB9BLRfr4cCslrOjNofQfsIek/edit?usp=sharing

Removing Duplicates - Transcript

In this video, we will go over quickly removing duplicate data in Excel Spreadsheets. Demo Spreadsheet:

https://docs.google.com/spreadsheets/d/1TNrRKt_L0m5EznZTeLEg_2ZIyAaoYmplnhvtaMDtsos/edit?usp=sharing

Applying Filters - Transcript

In this video, we show how to apply filters to column headers. Demo Spreadsheet:

https://docs.google.com/spreadsheets/d/1ik7f7eW3SRFgh4GC4EwB9BLRfr4cCslrOjNofQfsIek/edit?usp=sharing

Create a Table - Transcript

In this tutorial, we quickly go over how to create a table in Excel and some uses of Tables. Demo Spreadsheet:

https://docs.google.com/spreadsheets/d/1ik7f7eW3SRFgh4GC4EwB9BLRfr4cCslrOjNofQfsIek/edit?usp=sharing

Use a Table in a Formula - Transcript

*Note: There is an error in this video. When we “manually” found the average (=SUM(Table1[Age]/ROWS(Table1)), it also included the Header row. This is why there is a discrepancy between the “manual” average age and the average age using the =AVERAGE() formula.

In this tutorial, we use table references to provide more descriptive formulas in Excel. Demo Spreadsheet:

https://docs.google.com/spreadsheets/d/1-5GZE5fwANcwsaudEv19rjQJrHdYqKmn3dMRl2_el2k/edit?usp=sharing