Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Learn Excel 2016 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
Lesson 1-1: Start Excel and open a new blank workbook
Lesson 1-2: Check that your Excel version is up to date 0m 56s
Lesson 1-3: Change the Office Theme 1m 11s
Lesson 1-4: Maximize, minimize, re-size, move and close the Excel window 1m 39s
Lesson 1-5: Download the sample files and open or navigate a workbook 2m 11s
Lesson 1-6: Save a workbook to a local file 0m 59s
Lesson 1-7: Understand common file formats 0m 38s
Lesson 1-8: Pin a workbook and understand file organization 1m 25s
Lesson 1-9: View, move, add, rename, delete and navigate worksheet tabs 2m 39s
Lesson 1-10: Use the Versions feature to recover an unsaved Draft file 2m 9s
Lesson 1-11: Use the Versions feature to recover an earlier version of a workbook 1m 42s
Lesson 1-12: Use the Ribbon 2m 9s
Lesson 1-13: Understand Ribbon components
Lesson 1-14: Customize the Quick Access Toolbar and preview the printout 2m 7s
Lesson 1-15: Use the Mini Toolbar, Key Tips and keyboard shortcuts 1m 57s
Lesson 1-16: Understand views 0m 40s
Lesson 1-17: Hide and Show the Formula Bar and Ribbon 1m 5s
Lesson 1-18: Use the Tell Me help system 1m 3s
Lesson 1-19: Use other help features 0m 44s
Session 1 Exercise
Session 1 Exercise Answers
Session 2: Doing Useful Work with Excel
Session 2 Introduction
Lesson 2-1: Enter text and numbers into a worksheet 2m 25s
Lesson 2-2: Create a new workbook and view two workbooks at the same time 1m 24s
Lesson 2-3: Use AutoSum to quickly calculate totals 1m 18s
Lesson 2-4: Select a range of cells and understand Smart Tags 1m 54s
Lesson 2-5: Enter data into a range and copy data across a range 1m 43s
Lesson 2-6: Select adjacent and non-adjacent rows and columns 1m 32s
Lesson 2-7: Select non-contiguous cell ranges and view summary information 1m 23s
Lesson 2-8: AutoSelect a range of cells 1m 8s
Lesson 2-9: Re-size rows and columns 2m 3s
Lesson 2-10: Use AutoSum to sum a non-contiguous range 1m 28s
Lesson 2-11: Use AutoSum to calculate average and maximum values 2m 4s
Lesson 2-12: Create your own formulas 2m 20s
Lesson 2-13: Create functions using Formula AutoComplete 2m 17s
Lesson 2-14: Use AutoFill for text and numeric series 3m 3s
Lesson 2-15: Use AutoFill to adjust formulas 1m 36s
Lesson 2-16: Use AutoFill options 2m 4s
Lesson 2-17: Speed up your AutoFills and create a custom fill series 2m 26s
Lesson 2-18: Understand linear and exponential series 4m 21s
Lesson 2-19: Use automatic Flash Fill to split delimited text 1m 51s
Lesson 2-20: Use manual Flash Fill to split text 1m 52s
Lesson 2-21: Use multiple example Flash Fill to concatenate text 2m 20s
Lesson 2-22: Use Flash Fill to solve common problems
Lesson 2-23: Use the zoom control 1m 34s
Lesson 2-24: Print out a worksheet 0m 45s
Session 2 Exercise
Session 2 Exercise Answers
Session 3: Taking Your Skills To The Next Level
Session 3 Introduction
Lesson 3-1: Insert and delete rows and columns 2m 23s
Lesson 3-2: Use AutoComplete and fill data from adjacent cells 1m 34s
Lesson 3-3: Cut, copy and paste 2m 37s
Lesson 3-4: Cut, copy and paste using drag and drop 3m 34s
Lesson 3-5: Use Paste Values and increase or decrease decimal places displayed 3m 16s
Lesson 3-6: Transpose a range 1m 50s
Lesson 3-7: Use the Multiple Item Clipboard 2m 42s
Lesson 3-8: Use Undo and Redo 3m 9s
Lesson 3-9: Insert cell comments 3m 58s
Lesson 3-10: View cell comments 2m 1s
Lesson 3-11: Print cell comments 2m 47s
Lesson 3-12: Understand absolute and relative cell references 2m 34s
Lesson 3-13: Understand mixed cell references 2m 9s
Lesson 3-14: Understand templates and set the default custom template folder 1m 38s
Lesson 3-15: Create a template 2m 3s
Lesson 3-16: Use a template 1m 34s
Lesson 3-17: Understand Office Add-Ins
Lesson 3-18: Add an Office Add-In to a workbook 1m 9s
Lesson 3-19: Freeze columns and rows 2m 26s
Lesson 3-20: Split the window into multiple panes 2m 13s
Lesson 3-21: Check spelling 2m 25s
Session 3 Exercise
Session 3 Exercise Answers
Session 4: Making Your Worksheets Look Professional
Session 4 Introduction
Lesson 4-1: Format dates 2m 20s
Lesson 4-2: Understand date serial numbers 2m 59s
Lesson 4-3: Format numbers using built-in number formats 1m 26s
Lesson 4-4: Create custom number formats 1m 20s
Lesson 4-5: Horizontally align the contents of cells 1m 2s
Lesson 4-6: Merge cells, wrap text and expand or collapse the formula bar 2m 28s
Lesson 4-7: Unmerge cells and Center Across Selection 1m 20s
Lesson 4-8: Vertically align the contents of cells 1m 52s
Lesson 4-9: Understand themes
Lesson 4-10: Use cell styles and change themes 3m 8s
Lesson 4-11: Add color and gradient effects to cells 2m 2s
Lesson 4-12: Add borders and lines 4m 57s
Lesson 4-13: Create your own custom theme 3m 12s
Lesson 4-14: Create your own custom cell styles 3m 4s
Lesson 4-15: Use a master style book to merge styles 3m 37s
Lesson 4-16: Use simple conditional formatting 4m 30s
Lesson 4-17: Manage multiple conditional formats using the Rules Manager 3m 23s
Lesson 4-18: Bring data alive with visualizations 3m 22s
Lesson 4-19: Create a formula driven conditional format 3m 38s
Lesson 4-20: Insert a Sparkline into a range of cells 2m 42s
Lesson 4-21: Apply a common vertical axis and formatting to a Sparkline group 2m 20s
Lesson 4-22: Apply a date axis to a Sparkline group and format a single Sparkline 2m 36s
Lesson 4-23: Use the Format Painter 3m 7s
Lesson 4-24: Rotate text 5m 25s
Session 4 Exercise
Session 4 Exercise Answers
Session 5: Charts and Graphics
Session 5 Introduction
Lesson 5-1: Understand chart types, layouts and styles
Lesson 5-2: Create a simple chart with two clicks 1m 39s
Lesson 5-3: Move, re-size, copy and delete a chart 2m 19s
Lesson 5-4: Create a chart using the Recommended Charts feature 1m 15s
Lesson 5-5: Add and remove chart elements using Quick Layout 1m 39s
Lesson 5-6: Apply a pre-defined chart style and color set 1m 19s
Lesson 5-7: Manually format a chart element 1m 50s
Lesson 5-8: Format 3-D elements and add drop shadows 2m 6s
Lesson 5-9: Move, re-size, add, position and delete chart elements 2m 21s
Lesson 5-10: Apply a chart filter 1m 5s
Lesson 5-11: Change chart source data 1m 16s
Lesson 5-12: Assign non-contiguous source data to a chart 2m 22s
Lesson 5-13: Understand Data Series and Categories 0m 44s
Lesson 5-14: Change source data using the Select Data Source dialog tools 1m 21s
Lesson 5-15: Chart non-contiguous source data by hiding rows and columns 1m 43s
Lesson 5-16: Create a chart with numerical axes 1m 43s
Lesson 5-17: Deal with empty data points 1m 30s
Lesson 5-18: Add data labels to a chart 2m 12s
Lesson 5-19: Add data labels from a range 2m 10s
Lesson 5-20: Highlight specific data points with color and annotations 3m 0s
Lesson 5-21: Add gridlines and scale axes 1m 58s
Lesson 5-22: Emphasize data by manipulating pie charts 1m 53s
Lesson 5-23: Create a chart with two vertical axes 1m 59s
Lesson 5-24: Create a combination chart containing different chart types 2m 2s
Lesson 5-25: Add a trend line 2m 31s
Lesson 5-26: Add a forecast sheet 1m 32s
Lesson 5-27: Add a gradient fill to a chart background 1m 54s
Lesson 5-28: Create your own chart templates 2m 12s
Lesson 5-29: Create a Filled Map Chart 2m 58s
Lesson 5-30: Add Data Labels to a Filled Map Chart 2m 12s
Session 5 Exercise
Session 5 Exercise Answers
Session 6: Working With Multiple Worksheets and Workbooks
Session 6 Introduction
Lesson 6-1: View the same workbook in different windows 1m 24s
Lesson 6-2: View two windows side by side and perform synchronous scrolling 3m 2s
Lesson 6-3: Duplicate worksheets within a workbook 3m 40s
Lesson 6-4: Move and copy worksheets from one workbook to another 2m 17s
Lesson 6-5: Hide and unhide a worksheet 1m 2s
Lesson 6-6: Create cross worksheet formulas 5m 15s
Lesson 6-7: Understand worksheet groups 3m 44s
Lesson 6-8: Use find and replace 3m 48s
Session 6 Exercise
Session 6 Exercise Answers
Session 7: Printing Your Work
Session 7 Introduction
Lesson 7-1: Print Preview and change paper orientation 1m 22s
Lesson 7-2: Use Page Layout view to adjust margins 1m 6s
Lesson 7-3: Use Page Setup to set margins more precisely and center the worksheet 1m 46s
Lesson 7-4: Set paper size and scale 1m 38s
Lesson 7-5: Insert, delete and preview page breaks 2m 41s
Lesson 7-6: Adjust page breaks using Page Break Preview 1m 49s
Lesson 7-7: Add auto-headers and auto-footers and set the starting page number 2m 4s
Lesson 7-8: Add custom headers and footers 2m 57s
Lesson 7-9: Specify different headers and footers for the first, odd and even pages 4m 40s
Lesson 7-10: Print only part of a worksheet 2m 52s
Lesson 7-11: Add row and column data labels and grid lines to printed output 2m 21s
Lesson 7-12: Print several selected worksheets and change the page order 2m 22s
Lesson 7-13: Suppress error messages in printouts 1m 29s
Session 7 Exercise
Session 7 Exercise Answers
Session 8: Cloud Computing
Session 8 Introduction
Lesson 8-1: Understand cloud computing 2m 0s
Lesson 8-2: Save a workbook to a OneDrive 1m 38s
Lesson 8-3: Open a workbook from a OneDrive 0m 48s
Lesson 8-4: Understand operating systems and devices
Lesson 8-5: Understand Office versions
Lesson 8-6: Understand Excel Online
Lesson 8-7: Open a workbook using Excel Online 1m 16s
Lesson 8-8: Share a link to a workbook 2m 26s
Lesson 8-9: Edit a workbook simultaneously with other users using Excel Online 2m 41s
Session 8 Exercise
Session 8 Exercise Answers