NewEra Technology Facebook
Microsoft Excel 2016 Level 1 - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel 2016 Level 1
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
Description:
This course is designed to teach the fundamentals of using an Excel spreadsheet, including the basics of entering data into a sheet, to building formulas to formatting.
Prerequisites:
Previous knowledge of this application is not required.

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
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
• 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
Guaranteed to run courses