Home Sample Files e-Books Books Wholesale Forums & Support Contact
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