Microsoft Office 365 - Excel 2021

30 Hours / Access Length: 12 Months / Delivery: Online, Self-Paced

Course Overview:

In this course, we will learn the many facets of Microsoft Excel 2021. We will learn basic functions, such as creating a spreadsheet and working with formulas. We will learn how to create and sort tables, use templates, and the financial functions of Microsoft Excel. We will also explore more advanced features, such as pivot tables and user interfaces.

Students will:

• Format text entered into a Microsoft Excel spreadsheet.
• Apply formulas to cells in a Microsoft Excel spreadsheet. 
• Create tables and charts in Microsoft Excel.
• Use financial functions in Microsoft Excel.
• Demonstrate the ability to work in multiple workbooks.
• Create a Microsoft Excel template.
• Create PivotTable and PivotChart reports.
• Perform complex problem-solving and validation in Microsoft Excel.
• Use Macros to perform operations in Microsoft Excel.
• Collaborate using Microsoft Excel.

This course prepares students to take the Microsoft Office Suite (MOS) Excel 2019 national certification exam.

Course Outline:

Lesson 1: Creating a Worksheet

In this lesson, we will start by opening a Microsoft Excel spreadsheet and learn how to navigate the document. We will enter text, format the cells, and save a project.

Lesson 2: Working with Formulas and Large Worksheets

In this lesson, we will learn how to enter formulas in the spreadsheet and verify the formulas using Range Finder. We will also use the IF function to perform a logical test and freeze and unfreeze rows and columns.

Lesson 3: Financial Functions and Working in Multiple Spreadsheets

In this lesson, we will learn how to use the financial functions of Microsoft Excel, such as Amortization schedules and the mortgage payment calculator. We will also create a consolidated worksheet and learn to work across several spreadsheets.

Lesson 4: Creating Tables and Templates

In this lesson, we will learn how to create, format, and sort tables. We will also work with templates, import data, and work with SmartArt.

Lesson 5: Using PivotTables and Complex Problem Solving

In this lesson, we will learn some more advanced features, such as PivotTables and other Excel charts. We will also learn how to perform complex problem-solving and customize Excel add-ins.

Lesson 6: Data Analysis and User Interfaces

In this lesson, we will learn how to use Macros in Microsoft Excel and perform other data analysis. We will also learn how to collaborate in Microsoft Excel and create a custom theme.

All necessary course materials are included.

Certification(s):

This course prepares students to take the Microsoft Office Suite (MOS) Excel 2019 national certification exam.  At this time, there is not a scheduled release date for Microsoft Office 2021 national certification exams.

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.