Excel 2016 for Mac Training

Excel 2016 for Mac Training

Coming Soon
CustomGuide Excel 2016 Demo

Course Description

Turn unorganized data into useful information and quickly make spreadsheets your friends. CustomGuide’s Microsoft Excel 2016 course lets people of any technical level learn exactly what they need to know at their own pace. It starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.

Lessons: 77
Start a Demo Today.

  • Getting Started
  • Understand the Excel Screen
  • Create Workbooks
  • Navigate Worksheets
  • Open and Save Workbooks
  • Multiple Windows
  • Print
  • Help
  • Share a Document
  • Close and Exit
  • Edit a Workbook
  • Select Cells and Ranges
  • Edit Cell Data
  • Cut, Copy, and Paste
  • More Pasting Options
  • AutoFill
  • Insert, Move, and Delete Cells
  • Check Spelling
  • Find and Replace Text
  • Hide Columns and Rows
  • Format Worksheets
  • Format Text
  • Align and Merge Cells
  • Format Numbers and Dates
  • Borders and Background Colors
  • Copy Formatting
  • Row Heights and Column Widths
  • Apply Conditional Formatting
  • Apply and Remove Cell Styles
  • Create and Modify Cell Styles
  • Insert an Image
  • Build Formulas
  • Formula Basics
  • Sums and Averages
  • Reference External Worksheets
  • Absolute and Relative References
  • Cell and Range Name
  • Financial Formulas
  • Logical Formulas
  • Text Formulas
  • VLOOKUP
  • Formula Errors
  • View and Manage Worksheets
  • View Worksheets
  • Move and Copy Worksheets
  • Insert, Rename, and Delete Worksheets
  • Freeze Rows and Columns
  • Hiding Worksheets and Gridlines
  • Charts
  • Create Charts
  • Move and Resize
  • Chart Types
  • Layout and Style
  • Titles and Legends
  • Gridlines, Labels, and Data Tables
  • Chart Elements
  • Modify Chart Data
  • Sparklines
  • Print Worksheets
  • Page Size and Scale
  • Print Area and Page Breaks
  • Print Titles and Headings
  • Headers and Footers
  • Margins and Orientations
  • Data and Tables
  • Sort Data
  • Filter Data
  • Tables
  • Remove Duplicates and Total
  • Data Validation
  • Import and Export Data
  • Collaborate with Excel
  • Cell Comments
  • Share Workbooks
  • Track Changes
  • Protect a Worksheet
  • Password Protection
  • Save as Web Pages
  • PivotTables
  • Create PivotTables
  • Add Multiple PivotTable Fields
  • Change a PivotTables Calculation
  • Filter PivotTables
  • PivotTable Layout
  • Group Values
  • Refresh a PivotTable
  • Format a PivotTable

What’s Included:

CustomGuide Tutorials
Interactive Tutorials
CustomGuide Quizzes
Interactive Quizzes
CustomGuide Courseware
Training Manuals
CustomGuide Quick References
Quick References
SocialU Learning Platform
Learning Platform

Related Courses: