Excel 2016 Introduction

Summary: Identify basic worksheet and workbook concepts and terms, enter and edit data, Modify the worksheet, use functions to calculate and return values, format cells to enhance the appearance of your worksheet, use drawing features and other enhancements, change the page set-up to define how the printed worksheet appears. Additionally, students will learn the basics of creating, editing, and saving worksheets in our Essentials level class, work with formulas and functions to calculate and return values, and learn to change the appearance of a page, including adding headers and footers, format data and create charts.

Course Content:

Excel Essentials

• Starting Excel
• What is a Worksheet?
• What is a Workbook?
• Getting Help
• Entering Data
• Entering Text Data into a Cell
• Entering Values
• Quickly Adjusting a Column Width
• Finishing a Workbook
• And more

Formatting Text & Printing A Document

• Opening a Workbook
• Creating a New Workbook
• Creating Simple Formulas
• Using Functions
• Using the AutoSum Button
• Editing a Formula
• Clearing the Contents from a Cell or Range
• Using Undo and Redo
• And more

Managing the Worksheet

• Navigating in a Worksheet
• Using the Scroll Bars and Boxes
• Deleting Cells, Rows, and Columns
• Performing a Simple Sort
• Creating and Using Named Ranges
• Navigating with Named Ranges
• Using Range Names in Formulas
• And more

Formatting the Worksheet

• Moving and Copying Data
• Copying Data
• Creating a Series
• Copying Formulas
• Changing Row Height
• Using Drawing Tools
• Creating Graphic Objects
• Editing a Graphic Object
• And more

Students will receive an email confirming their registration for requested course. Two business days before the scheduled class, students will each receive their electronic course and materials and their Microsoft Teams link used to join their training class. After class ends, students will receive a certificate of completion along with their class evaluation.