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 Essential Skills With The Smart Method

Session 4: Making Your Worksheets Look Professional (Excel 2013)

Session 4 Introduction 6m 48s
Lesson 4-1: Format dates 6m 29s
Lesson 4-2: Understand date serial numbers 10m 47s
Lesson 4-3: Format numbers using built-in number formats 16m 8s
Lesson 4-4: Create custom number formats 10m 20s
Lesson 4-5: Horizontally align the contents of cells 12m 31s
Lesson 4-6: Merge cells, wrap text and expand or collapse the formula bar 6m 5s
Lesson 4-7: Vertically align the contents of cells 7m 25s
Lesson 4-8: Understand themes 8m 36s
Lesson 4-9: Use cell styles and change themes 7m 10s
Lesson 4-10: Add color and gradient effects to cells 5m 48s
Lesson 4-11: Add borders and lines 8m 42s
Lesson 4-12: Create your own custom theme 8m 10s
Lesson 4-13: Create your own custom cell styles 6m 18s
Lesson 4-14: Use a master style book to merge styles 7m 48s
Lesson 4-15: Use simple conditional formatting 10m 49s
Lesson 4-16: Manage multiple conditional formats using the Rules Manager 8m 59s
Lesson 4-17: Bring data alive with visualizations 11m 30s
Lesson 4-18: Create a formula driven conditional format 9m 29s
Lesson 4-19: Insert a Sparkline into a range of cells 8m 25s
Lesson 4-20: Apply a common vertical axis and formatting to a Sparkline group 7m 55s
Lesson 4-21: Apply a date axis to a Sparkline group and format a single Sparkline 5m 44s
Lesson 4-22: Use the Format Painter 6m 47s
Lesson 4-23: Rotate text 8m 44s

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