One Day • Instructor Led
Overview:
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.
Course Objectives
In this course, you will learn to:
- Perform calculations
- Modify a worksheet
- Format a workbook
- Print workbooks
- Manage Workbooks
Target Student:
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets.
Course Outline
Lesson 1: Basic Excel Usage
- Navigating the Excel Interface
- Using Excel Commands
- Creating and Saving a Basic Workbook
- Entering Cell Data
- Using Excel Help
Lesson 2: Performing Calculations
- Creating Worksheet Formulas
- Inserting Functions
- Reusing Formulas and Functions
Lesson 3: Modifying a Worksheet
- Inserting, Deleting and Adjusting Cells, Columns and Rows
- Searching for and Replacing Data
- Using Proofing and Research Tools
Lesson 4: Formatting a Worksheet
- Applying Text Formats
- Applying Number Formats
- Aligning Cell Contents
- Applying Styles and Themes
- Applying Basic Conditional Formatting
- Creating and Using Templates
Lesson 5: Printing Workbooks
- Previewing and Printing a Workbook
- Setting up the Page Layout
- Configuring Headers and Footers
Lesson 6: Managing Workbooks
- Managing Worksheets
- Managing Worksheet and Workbook Views
- Managing Workbook Properties