Dal Alert!

Receive alerts from Dalhousie by text message.

X

Microsoft Excel 2016 (365) Level I

Upcoming Dates

January 18-19, 2018

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.

Content

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