Full overview
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.
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.
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.
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.
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.
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.
NOTE: While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system. This is due to the potential high download and upload latency of cellular connections. Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.
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.
Included programs
- 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.
System requirements
Minimum technical expectations for the online learning environment. Your IT team can use this as a checklist.
Internet connectivity
Internet Connectivity Requirements: Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience. Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience. Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience.
While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system. This is due to the potential high download and upload latency of cellular connections. Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.
Hardware
Hardware Requirements: CPU: 1 GHz or higher RAM: 4 GB or higher Resolution: 1280 x 720 or higher. 1920x1080 resolution is recommended for the best experience. Speakers / Headphones Microphone for Webinar or Live Online sessions. CPU: 1 GHz or higher RAM: 4 GB or higher Resolution: 1280 x 720 or higher. 1920x1080 resolution is recommended for the best experience. Speakers / Headphones Microphone for Webinar or Live Online sessions. CPU: 1 GHz or higher RAM: 4 GB or higher Resolution: 1280 x 720 or higher. 1920x1080 resolution is recommended for the best experience. Speakers / Headphones Microphone for Webinar or Live Online sessions.
Operating system
Operating System Requirements: Windows 7 or higher. Mac OSX 10 or higher. Latest Chrome OS Latest Linux Distributions Windows 7 or higher. Mac OSX 10 or higher. Latest Chrome OS Latest Linux Distributions Windows 7 or higher. Mac OSX 10 or higher. Latest Chrome OS Latest Linux Distributions
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.
Web browser
Web Browser Requirements: Latest Google Chrome is recommended for the best experience. Latest Mozilla FireFox Latest Microsoft Edge Latest Apple Safari Latest Google Chrome is recommended for the best experience. Latest Mozilla FireFox Latest Microsoft Edge Latest Apple Safari Latest Google Chrome is recommended for the best experience. Latest Mozilla FireFox Latest Microsoft Edge Latest Apple Safari
Recommended software
Basic Software Requirements (These are recommendations of software to use): Office suite software (Microsoft Office, OpenOffice, or LibreOffice) PDF reader program (Adobe Reader, FoxIt) Courses may require other software that is described in the above course outline. Office suite software (Microsoft Office, OpenOffice, or LibreOffice) PDF reader program (Adobe Reader, FoxIt) Courses may require other software that is described in the above course outline. Office suite software (Microsoft Office, OpenOffice, or LibreOffice) PDF reader program (Adobe Reader, FoxIt) Courses may require other software that is described in the above course outline. ** The course outlines displayed on this website are subject to change at any time without prior notice. ** ** The course outlines displayed on this website are subject to change at any time without prior notice. **
Ready for a team proposal?