Home Sample Files e-Books Books Wholesale Forums & Support Contact
2016 2013 2010 2007 Apple Mac

Learn Excel 2010 Essential Skills With The Smart Method

Before you start:
When you need help:
Read: How to use the course Simple one-page guide. Search Find a lesson teaching a specific Excel feature
Download the entire e-book Download the entire e-Book.
Download the sample files Sample files save a lot of typing. Forums Ask one of our Excel experts.
Session 1: Basic Skills
Session 1 Introduction 1m 22s
Lesson 1-1: Start Excel and check your program version 8m 42s
Lesson 1-2: Maximize, minimize, re-size, move and close the Excel window 3m 17s
Lesson 1-3: Understand the Application and Workbook windows 3m 35s
Lesson 1-4: Open and navigate a workbook 7m 37s
Lesson 1-5: Save a workbook 2m 32s
Lesson 1-6: Understand common file formats 5m 22s
Lesson 1-7: Pin a document, and understand file organization 6m 12s
Lesson 1-8: View, add, remove and navigate worksheet tabs 5m 19s
Lesson 1-9: Use the Versions feature to recover an unsaved Draft file 8m 22s
Lesson 1-10: Use the Versions feature to recover an earlier version of a workbook 4m 12s
Lesson 1-11: Use the Ribbon 11m 5s
Lesson 1-12: Understand Ribbon components 9m 18s
Lesson 1-13: Customize the Quick Access Toolbar and preview the printout 9m 16s
Lesson 1-14: Use the Mini Toolbar, Key Tips and keyboard shortcuts 6m 7s
Lesson 1-15: Understand Views 2m 52s
Lesson 1-16: Use full screen view 2m 12s
Lesson 1-17: Use the help system 8m 20s
Session 1 Exercise
Session 1 Exercise Answers
Session 2: Doing Useful Work with Excel
Session 2 Introduction 1m 6s
Lesson 2-1: Enter text and numbers into a worksheet 9m 5s
Lesson 2-2: Create a new workbook and view two workbooks at the same time 5m 49s
Lesson 2-3: Use AutoSum to quickly calculate totals 4m 9s
Lesson 2-4: Select a range of cells and understand Smart Tags 5m 37s
Lesson 2-5: Enter data into a range and copy data across a range 5m 9s
Lesson 2-6: Select adjacent and non-adjacent rows and columns 2m 45s
Lesson 2-7: Select non-contiguous cell ranges and view summary information 5m 22s
Lesson 2-8: AutoSelect a range of cells 5m 5s
Lesson 2-9: Re-size rows and columns 5m 51s
Lesson 2-10: Use AutoSum to sum a non-contiguous range 3m 14s
Lesson 2-11: Use AutoSum to quickly calculate averages 5m 36s
Lesson 2-12: Create your own formulas 6m 41s
Lesson 2-13: Create functions using Formula AutoComplete 6m 17s
Lesson 2-14: Use AutoFill for text and numeric series 5m 16s
Lesson 2-15: Use AutoFill to adjust formulas 5m 42s
Lesson 2-16: Use AutoFill Options 5m 48s
Lesson 2-17: Speed up your Auto Fills and create a custom fill series 4m 43s
Lesson 2-18: Use the zoom control 2m 58s
Lesson 2-19: Print out a worksheet 8m 16s
Session 2 Exercise
Session 2 Exercise Answers
Session 3: Taking Your Skills To The Next Level
Session 3 Introduction 0m 45s
Lesson 3-1: Insert and delete rows and columns 5m 42s
Lesson 3-2: Use AutoComplete and fill data from adjacent cells 4m 38s
Lesson 3-3: Cut, copy and paste 4m 31s
Lesson 3-4: Cut, copy and paste using drag and drop 7m 16s
Lesson 3-5: Use Paste Values and increase decrease decimal places displayed 7m 13s
Lesson 3-6: Transpose a range 3m 13s
Lesson 3-7: Use the Multiple Item Clipboard 5m 11s
Lesson 3-8: Use Undo and Redo 5m 16s
Lesson 3-9: Insert cell comments 6m 4s
Lesson 3-10: View cell comments 2m 50s
Lesson 3-11: Print cell comments 4m 23s
Lesson 3-12: Understand absolute and relative cell references 8m 31s
Lesson 3-13: Understand mixed cell references 9m 51s
Lesson 3-14: Create a template 4m 17s
Lesson 3-15: Use a template 5m 54s
Lesson 3-16: Freeze columns and rows 4m 38s
Lesson 3-17: Split the window into multiple panes 5m 20s
Lesson 3-18: Check spelling 7m 31s
Session 3 Exercise
Session 3 Exercise Answers
Session 4: Making Your Worksheets Look Professional
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
Session 5: Charts and Graphics
Session 5 Introduction 0m 52s
Lesson 5-1: Create a simple chart with two clicks 5m 28s
Lesson 5-2: Move, re-size, copy and delete a chart 8m 7s
Lesson 5-3: Change the chart layout and add a data table 4m 29s
Lesson 5-4: Format chart element fills and borders 5m 53s
Lesson 5-5: Format 3-D elements and align text 6m 58s
Lesson 5-6: Move, re-size and delete chart elements 4m 15s
Lesson 5-7: Change a chart's source data 3m 51s
Lesson 5-8: Assign non-contiguous source data by click and drag 3m 8s
Lesson 5-9: Change source data using the Select Data Source dialog tools 3m 8s
Lesson 5-10: Chart non-contiguous source data by hiding rows and columns 5m 11s
Lesson 5-11: Create a chart with numerical axis 3m 44s
Lesson 5-12: Deal with empty data points 2m 15s
Lesson 5-13: Add data labels to a chart 5m 58s
Lesson 5-14: Highlight specific data points with color and annotations 5m 33s
Lesson 5-15: Add gridlines and scale axes 5m 47s
Lesson 5-16: Emphasize data by manipulating pie charts 4m 4s
Lesson 5-17: Create a chart with two vertical axis 5m 18s
Lesson 5-18: Create a combination chart containing different chart types 4m 15s
Lesson 5-19: Add a trend line 3m 51s
Lesson 5-20: Switch chart rows columns and add a gradient fill 4m 11s
Lesson 5-21: Create your own chart templates 4m 56s
Session 5 Exercise
Session 5 Exercise Answers
Session 6: Multiple Worksheets and Workbooks
Session 6 Introduction 0m 50s
Lesson 6-1: View the same workbook in different windows 4m 12s
Lesson 6-2: View two windows side by side and perform synchronous scrolling 5m 14s
Lesson 6-3: Duplicate worksheets within a workbook 5m 50s
Lesson 6-4: Move and copy worksheets from one workbook to another 4m 7s
Lesson 6-5: Hide and unhide a worksheet 4m 17s
Lesson 6-6: Create cross worksheet formulas 6m 36s
Lesson 6-7: Understand worksheet groups 8m 1s
Lesson 6-8: Use find and replace 8m 49s
Session 6 Exercise
Session 6 Exercise Answers
Session 7: Printing Your Work
Session 7 Introduction 0m 54s
Lesson 7-1: Print Preview and change paper orientation 4m 58s
Lesson 7-2: Use page layout view to adjust margins 6m 2s
Lesson 7-3: Use Page Setup to set margins more precisely and center the worksheet 4m 27s
Lesson 7-4: Set paper size and scale 4m 43s
Lesson 7-5: Insert, delete and preview page breaks 5m 10s
Lesson 7-6: Adjust page breaks using Page Break Preview 5m 0s
Lesson 7-7: Add auto-headers and auto-footers and set the starting page number 5m 1s
Lesson 7-8: Add custom headers and footers 7m 34s
Lesson 7-9: Specify different headers and footers for the first, odd and even pages 5m 39s
Lesson 7-10: Print only part of a worksheet 5m 39s
Lesson 7-11: Add row and column data labels and grid lines to printed output 4m 40s
Lesson 7-12: Print several selected worksheets and change the page order 4m 49s
Lesson 7-13: Suppress error messages in printouts 2m 54s
Session 7 Exercise
Session 7 Exercise Answers