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

Learn Excel 2016 for Mac 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: Configure your mouse and understand right clicking
Lesson 1-2: Start Excel and open a new blank workbook
Lesson 1-3: Check that your Excel version is up to date
Lesson 1-4: Change the Office Theme
Lesson 1-5: Minimize, re-size, move and close the Excel window
Lesson 1-6: Understand Full Screen view
Lesson 1-7: Download the sample files and open/navigate a workbook
Lesson 1-8: Save a workbook to a local file
Lesson 1-9: Understand common file formats
Lesson 1-10: Pin a workbook and understand file organization
Lesson 1-11: View, move, add, rename, delete and navigate worksheet tabs
Lesson 1-12: Use the ribbon
Lesson 1-13: Understand Ribbon components
Lesson 1-14: Customize the Quick Access Toolbar and preview the printout
Lesson 1-15: Understand views
Lesson 1-16: Hide and Show the Formula Bar and ribbon
Lesson 1-17: Use the help search system
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
Lesson 2-2: Create a new workbook and view two workbooks at the same time
Lesson 2-3: Use AutoSum to quickly calculate totals
Lesson 2-4: Select a range of cells and understand Smart Tags
Lesson 2-5: Enter data into a range and copy data across a range
Lesson 2-6: Select adjacent and non-adjacent rows and columns
Lesson 2-7: Select non-contiguous cell ranges and view summary information
Lesson 2-8: AutoSelect a range of cells
Lesson 2-9: Re-size rows and columns
Lesson 2-10: Use AutoSum to sum a non-contiguous range
Lesson 2-11: Use AutoSum to quickly calculate averages
Lesson 2-12: Create your own formulas
Lesson 2-13: Create functions using Formula AutoComplete
Lesson 2-14: Use AutoFill for text and numeric series
Lesson 2-15: Use AutoFill to adjust formulas
Lesson 2-16: Use AutoFill options
Lesson 2-17: Speed up your AutoFills and create a custom fill series
Lesson 2-18: Understand linear and exponential series
Lesson 2-19: Use the zoom control
Lesson 2-20: Print out a worksheet
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
Lesson 3-2: Use AutoComplete and fill data from adjacent cells
Lesson 3-3: Cut, copy and paste
Lesson 3-4: Cut, copy and paste using drag and drop
Lesson 3-5: Use Paste Values and increase/decrease decimal places displayed
Lesson 3-6: Transpose a range
Lesson 3-7: Use Undo and Redo
Lesson 3-8: Insert cell comments
Lesson 3-9: View cell comments
Lesson 3-10: Print cell comments
Lesson 3-11: Understand absolute and relative cell references
Lesson 3-12: Understand mixed cell references
Lesson 3-13: Understand templates
Lesson 3-14: Create a template
Lesson 3-15: Use a template
Lesson 3-16: Understand Office Add-Ins
Lesson 3-17: Add an Office Add-In to a workbook
Lesson 3-18: Freeze columns and rows
Lesson 3-19: Split the window into multiple panes
Lesson 3-20: Check spelling
Session 3 Exercise
Session 3 Exercise Answers
Session 4: Making Your Worksheets Look Professional
Session 4 Introduction
Lesson 4-1: Format dates
Lesson 4-2: Understand date serial numbers
Lesson 4-3: Format numbers using built-in number formats
Lesson 4-4: Create custom number formats
Lesson 4-5: Horizontally align the contents of cells
Lesson 4-6: Merge cells, wrap text and expand/collapse the formula bar
Lesson 4-7: Unmerge cells and Center Across Selection
Lesson 4-8: Vertically align the contents of cells
Lesson 4-9: Understand themes
Lesson 4-10: Use cell styles and change themes
Lesson 4-11: Add borders and lines
Lesson 4-12: Create your own custom theme
Lesson 4-13: Create your own custom cell styles
Lesson 4-14: Use a master style book to merge styles
Lesson 4-15: Use simple conditional formatting
Lesson 4-16: Manage multiple conditional formats using the Rules Manager
Lesson 4-17: Bring data alive with visualizations
Lesson 4-18: Create a formula driven conditional format
Lesson 4-19: Insert a Sparkline into a range of cells
Lesson 4-20: Apply a common vertical axis and formatting to a Sparkline group
Lesson 4-21: Apply a date axis to a Sparkline group and format a single Sparkline
Lesson 4-22: Use the format painter
Lesson 4-23: Rotate text
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
Lesson 5-3: Move, re-size, copy and delete a chart
Lesson 5-4: Create a chart using the Recommended Charts feature
Lesson 5-5: Add and remove chart elements using Quick Layout
Lesson 5-6: Apply a pre-defined chart style and color set
Lesson 5-7: Manually format a chart element
Lesson 5-8: Format 3-D elements and add drop shadows
Lesson 5-9: Move, re-size, add, position and delete chart elements
Lesson 5-10: Change a chart’s source data
Lesson 5-11: Assign non-contiguous source data to a chart
Lesson 5-12: Understand Data Series and Categories
Lesson 5-13: Change source data using the Select Data Source dialog tools
Lesson 5-14: Chart non-contiguous source data by hiding rows and columns
Lesson 5-15: Create a chart with numerical axes
Lesson 5-16: Deal with empty data points
Lesson 5-17: Add data labels to a chart
Lesson 5-18: Highlight specific data points with color and annotations
Lesson 5-19: Add gridlines and scale axes
Lesson 5-20: Emphasize data by manipulating pie charts
Lesson 5-21: Create a chart with two vertical axes
Lesson 5-22: Create a combination chart containing different chart types
Lesson 5-23: Add a trend line
Lesson 5-24: Add a gradient fill to a chart background
Lesson 5-25: Create your own chart templates
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
Lesson 6-2: Duplicate worksheets within a workbook
Lesson 6-3: Move and copy worksheets from one workbook to another
Lesson 6-4: Hide and unhide a worksheet
Lesson 6-5: Create cross worksheet formulas
Lesson 6-6: Understand worksheet groups
Lesson 6-7: Use find and replace
Session 6 Exercise
Session 6 Exercise Answers
Session 7: Printing Your Work
Session 7 Introduction
Lesson 7-1: Print Preview and change paper orientation
Lesson 7-2: Use Page Layout view to adjust margins
Lesson 7-3: Use Page Setup to set margins more precisely and center the worksheet
Lesson 7-4: Set paper size and scale
Lesson 7-5: Insert, delete and preview page breaks
Lesson 7-6: Adjust page breaks using Page Break Preview
Lesson 7-7: Add auto-headers and auto-footers and set the starting page number
Lesson 7-8: Add custom headers and footers
Lesson 7-9: Specify different headers and footers for the first, odd and even pages
Lesson 7-10: Print only part of a worksheet
Lesson 7-11: Add row and column data labels and grid lines to printed output
Lesson 7-12: Print several selected worksheets and change the page order
Session 7 Exercise
Session 7 Exercise Answers
Session 8: Cloud Computing
Session 8 Introduction
Lesson 8-1: Understand cloud computing
Lesson 8-2: Save a workbook to a OneDrive
Lesson 8-3: Open a workbook from a OneDrive
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
Lesson 8-8: Share a link to a workbook
Lesson 8-9: Edit a workbook simultaneously with other users using Excel Online
Session 8 Exercise
Session 8 Exercise Answers