• Microsoft Office Excel Beginners Course
  • Microsoft Office Excel Intermediate Course
  • Microsoft Office Excel Advanced Course

Microsoft Office Excel Beginners Course

Prerequisites

This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Excel is necessary.

Course Outline

  • Getting started with Excel
  • Creating and opening workbooks
  • Saving and sharing workbooks
  • Cell basics
  • Modifying columns, rows and and cells
  • Formatting cells
  • Understanding number formats
  • Working with multiple worksheets
  • Using find & replace
  • Checking spelling
  • Page layout and printing
  • Creating formulas
  • Relative and absolute cell references
  • Functions
  • Working with data
  • Feezing panes and view options
  • Sorting data
  • Filtering data
  • Groups and subtotals
  • Tables
  • Charts
  • Conditional formatting

Microsoft Office Excel Intermediate Course

Prerequisites

This level assumes that the user has completed the Microsoft Office Excel 2016 Beginners course, or has equivalent knowledge of the sills covered in it.

Course Outline

  • Comments and co-authoring
  • Inspecting and protecting workbooks
  • Manage workbook versions
  • Create and manage PivotTables
  • Create and manage PivotCharts
  • Basic What-if analysis
  • Save a workbook as a template
  • Hide or display ribbon tabs
  • Reference table data by using structured references
  • Configure formula calculation options
  • Apply custom data formats and validation
  • Perform logical operations by using the IF, AND, OR, and NOT functions
  • Perform statistical operations by using the SUMIFS, AVERAGEIFS, and COUNTIFS functions

Microsoft Office Excel Advanced Course

Prerequisites

This level assumes that the user has completed the Microsoft Office Excel 2016 Intermediate course, or has equivalent knowledge of the sills covered in it.

Course Outline

  • Reference styles
  • Apply advanced conditional formatting and filtering
  • Create and modify custom workbook elements
  • Prepare a workbook for internationalization
  • Insert functions into a formula
  • Perform logical operations by using nested functions
  • Look up data by using functions
  • Apply advanced date and time functions
  • Perform data analysis and business intelligence
  • Troubleshoot formulas
  • Define named ranges and objects
  • Create advanced charts