Microsoft Excel 365 Basics

Display filters

Hide filters

Description

This course is intended for anyone who wants to gain a foundational understanding of Microsoft Excel. Participants will learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.

Course Length: ½ day (4 hours)

Course Outline:

Part 1: Getting Comfortable in Excel

• User Interface Basics
• The Ribbon
• Quick Access Toolbar
• Navigating with the Name Box
• The Status Bar
• Getting Help: the Search Bar
• The Formula Bar
• Understanding Worksheets

Part 2: Entering and Formatting Data

• Entering Data
• Formatting Text
• AutoFill
• Number Formatting
• Clear Formatting

 Part 3: Organizing Information

• The Anatomy of a Tidy Dataset
• Sorting and Filtering data
• Sorting data
• Filtering data
• Workbook Views
• Freeze Panes

Part 4: Basic Formulas and Functions

• Creating Formulas
• Mathematical Operators and the Order of Operations
• Understanding Cell References
• Using AutoFill for formulas
• Function Basics
• AutoSum Functions

Note: Access to the Microsoft Excel desktop app is required for this course. It is also beneficial to have two monitors/screens, so students can follow along and test out their new skills as we go. 

Delivery Method: Virtual Session – Zoom Platform

Course Fee Includes: Access to the course, course materials, and a digital certificate upon completion. 

This course is delivered in partnership with local and provincial construction associations across Canada. You will be participating with a group of industry peers from multiple regions. 

Sharing a single registration between two or more individuals is not permitted. Please register each person that will be in attendance.

Prerequisites

A basic knowledge of and experience with Windows, including being able to start programs, switch between programs, locate saved files, and close programs.

Technical Requirements

1. Computer or laptop   

• This course will involve on-screen interaction with your instructor and classmates, reading/viewing on-screen content (slides or videos), and interacting via typing with questions or responses. For this reason, cell phones will not be adequate.   

• Windows 10 or Mac iOS   

• Two Monitors/Screens would be most beneficial 

2. Software/Programs – Excel 2016 (or newer) program downloaded and installed on the computer. The web version will not be suitable.

3. Webcam (Mandatory) – in order to engage and collaborate, participants will be expected to have their webcams on for the duration of the class   

4. Microphone (Mandatory)   

5. Internet connection - For best results, you will want to ensure you have an internet connection with an upload/download speed of 3-5 Mbps. You can test your internet speed here. The minimum recommended speed is 1.5 Mbps, but anything below 3 Mbps may result in loss of quality or buffering. Ideally hardwired connection versus wireless for stability – connect your computer directly to your router using an ethernet cable, rather than using your home wi-fi.   

6. A quiet space with minimal distractions - The microphone will be engaged for interactive sessions. Please plan to be fully engaged in the class and clear your work schedule just as you would for the in-class program.     

7. Comfortable chair