Learning Method: Take Excel Level 1 Online or In-Person. Duration: 1.00 Day
*Click here to view upcoming Excel 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
- Topic D: Print Selection
- Topic E: Print Titles
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
