Excel Level 1

Learning Method: Instructor-led Classroom Learning Duration: 1.00 Day


*Click here to view upcoming Excel Level 1 classes


Overview:

In this course, students create and edit basic Microsoft Office Excel worksheets and workbooks.

Who Should Attend:

This course is for people with knowledge of Microsoft  Windows®  who are interested in learning how to create, edit, format and print basic spreadsheets using Excel software.

At Course Completion:

Upon successful completion of this course, students will be able to: Explore the Microsoft Office Excel environment and create a basic worksheet. Perform calculations. Modify a worksheet. Format a worksheet. Print workbook contents. Manage large workbooks.

Course Outline:

Lesson 1: Getting Started with Microsoft Office Excel 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

Lesson 4: Formatting a Worksheet

 Topic A: Apply Text Formats

 Topic B: Apply Number Formats

 Topic C: Align Cell Contents

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

Lesson 7: Working with Lists

 Topic A: Sort Data

 Topic B: Filter Data

Site Loader