Home Sample Files Register Books and e-books Forums Support Contact Search
Basic Skills
Essential Skills Expert Skills
Excel 2016 Excel 2013 Excel 2010 Excel 2007
Learn Excel 2013 Expert Skills With The Smart Method

Session 1: Tables and Ranges (Excel 2013)

Lesson 1-1: Check that your Excel version is up to date 3m 33s
Lesson 1-2: Change the Office Theme 2m 51s
Lesson 1-3: Apply a simple filter to a range 7m 40s
Lesson 1-4: Apply a top 10 and custom filter to a range 5m 48s
Lesson 1-5: Apply an advanced filter with multiple OR criteria 8m 2s
Lesson 1-6: Apply an advanced filter with complex criteria 4m 44s
Lesson 1-7: Apply an advanced filter with function-driven criteria 14m 24s
Lesson 1-8: Extract unique records using an advanced filter 4m 41s
Lesson 1-9: Add totals using Quick Analysis 3m 42s
Lesson 1-10: Add percentage and running totals using Quick Analysis 5m 10s
Lesson 1-11: Convert a range into a table and add a total row 5m 47s
Lesson 1-12: Format a table using table styles and convert a table into a range 12m 9s
Lesson 1-13: Create a custom table style 4m 49s
Lesson 1-14: Sort a range or table by rows 5m 5s
Lesson 1-15: Sort a range by columns 5m 18s
Lesson 1-16: Sort a range or table by custom list 2m 56s
Lesson 1-17: Name a table and create an automatic structured table reference 8m 52s
Lesson 1-18: Create a manual structured table reference 4m 53s
Lesson 1-19: Use special items in structured table references 4m 35s
Lesson 1-20: Understand unqualified structured table references 8m 0s

Session 1 Exercise
Session 1 Exercise Answers
Register to view ALL of the lessons in this session