Microsoft Excel 365 (Level 1)

New to Excel or need a refresher? This course is designed to help you master the fundamentals of Excel. Learn time-saving tips that will allow you to get things done more quickly and efficiently.

Upon completion of the course, you’ll know to:

Overview of Excel ribbons and commands.
Create new Excel workbook and worksheets.
Organize columns and rows and edit cell content.
Create formulas using relative and absolute refernces.
Manage worksheets and work with multiple worksheets.
Change the page setup, and preview/print workbooks.

Unit 1: Getting Started with Excel

Understanding Spreadsheet Concepts
Getting Started
Creating and Saving Workbooks
Opening and Closing Workbooks

Unit 2: Modifying Worksheets

Working with Columns and Rows
Working with Cell Contents

Unit 3: Using Formulas and Functions

Creating and Using Formulas
Creating and Using Functions
Using Absolute Cell References
Inserting Functions

Unit 4: Formatting and Viewing Worksheets

Unit 5: Printing Workbooks

Using Workbook Views
Changing the Page Setup
Previewing and Printing Workbooks

Unit 6: Developing A Realistic Action Plan

Developing a Personal Action Plan

UPCOMING SESSIONS

TOP