Microsoft Office 365 - Excel 2019
Hours: 30 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 30
Retail Price: $494.00
Course Overview:
** Students need a copy of Microsoft Office 365 in order to complete course work in this course **
In this course, we will learn the many facets of Microsoft Excel 2019. 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 a student to take the Microsoft 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 (except Office 365 software subscription) are included.
Certification(s):
This course prepares a student to take the Microsoft Excel 2019 national certification exam.
System Requirements:
Internet Connectivity
- Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
- Minimum Speed: 10 Mbps download / 5 Mbps upload
Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.
Hardware
- Processor: Dual-core 2.0 GHz or higher
- Memory (RAM): 8 GB or higher (4 GB minimum)
- Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
- Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)
Operating Systems
- Windows: Windows 10 or Windows 11
- Mac: macOS 13 (Ventura) or newer
- ChromeOS / Linux: Latest supported release
Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.
Web Browsers
- Google Chrome (Latest version — Recommended)
- Mozilla Firefox (Latest version)
- Microsoft Edge (Latest version)
- Apple Safari (Latest version)
Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.
Recommended Software
The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):
- Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
- PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer
** The course outlines displayed on this website are subject to change at any time without prior notice. **