This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Tables
Welcome to ten reasons to use Tables in Excel with Chris Menard
Getting Started - please read
Changing a Range to a Table
Converting a range to a table and sorting & filtering (3:23)
Quiz 1
Creating Dynamic Charts
Creating Dynamic Charts (1:26)
Quiz 2
Calculated Columns - Automatic Autofill - Dynamic Ranges for PivotTables
Auto Fill automatically - calculated columns - header rows repeat (2:56)
Convert to Range and Resize Table
Fix header row - Convert to Range - Resize Table (1:53)
Auto Fill automatically - calculated columns - header rows repeat
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock