Loading...

Course Description

This course teaches the basic functions and features of Excel 2016 (365). After an introduction to spreadsheet terminology and Excel's window components, students will learn how to navigate worksheets and workbooks. Students will enter and edit text, values, formulas, and images, and save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and page layout and printing. Finally, students will create and modify headers and footers, manage workbook and worksheet views and properties.

Course Outline

Getting Started with Microsoft Office Excel 2016

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Notes

For more Computer Applications courses click here.

Testimonials

"So much information presented by knowledgeable instructor. Lots of practical information and so well presented.”

Kim Marchand

Loading...

Enroll Now - Select a section to enroll in

Section Title
Microsoft Excel 2016 (365) Level I
Type
Lab
Days
Th, F
Time
8:30AM to 2:30PM
Dates
Sep 17, 2020 to Sep 18, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Title
Microsoft Excel 2016 (365) Level I
Type
Lab
Days
Th, F
Time
8:30AM to 2:30PM
Dates
Jan 21, 2021 to Jan 22, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Title
Microsoft Excel 2016 (365) Level I
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Apr 12, 2021 to Apr 13, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Required fields are indicated by .