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

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

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

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