Microsoft® Excel® 2016: Level 1

Duration:

1 Day (6.5 instructional hours)

Excel 2016

Course Number: 091055

Course Objective:

Upon successful completion of this course, you will learn the foundational knowledge and skills to organize, calculate, analyze, revise, update, and present data.

Target Student:

This course is meant for those desiring to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

Course Objective:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 8 or 8.1 environment and be able to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders. To obtain this level of skill and knowledge, you can take any of the following courses: Using Microsoft Windows 8.1; Introduction to Personal Computers.

Course Outline

Lesson 1: Getting Started with Microsoft Office 2016

Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data
Topic E: Use Excel Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic D: Apply Styles and Themes
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties