Excel 2016 Training

Excel 2016 Training

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: 82

  • Course Outline
  • Getting Started
  • Understand the Excel Screen
  • Create Workbooks
  • Navigate Worksheets
  • Open and Save Workbooks
  • Print
  • Help
  • 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
  • Find and Replace Formatting
  • Insert an Image
  • Build Formulas
  • Formula Basics
  • Sums and Averages
  • Reference External Worksheets
  • Absolute and Relative References
  • Cell and Range Names
  • 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
  • Filter Charts
  • Sparklines
  • Print Worksheets
  • Page Size and Scale
  • Print Area and Page Breaks
  • Print Titles and Headings
  • Headers and Footers
  • Margins and Orientation
  • Data and Tables
  • Sort Data
  • Filter Data
  • Quick Analysis
  • Tables
  • Remove Duplicates and Total
  • Data Validation
  • Slicers
  • Flash Fill
  • 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
  • Timelines
  • PivotTable Layout
  • Group Values
  • Refresh a PivotTable
  • Format a PivotTable
  • PivotCharts

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: