Gold Seal: 1 Credit
Want to run this event in-house? Enquire about running this event in-house
No events to show
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
-
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
-
Software/Programs – Excel 2016 (or newer) program downloaded and installed on the computer. The web version will not be suitable.
-
Webcam (Mandatory) – in order to engage and collaborate, participants will be expected to have their webcams on for the duration of the class
-
Microphone (Mandatory)
-
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.
-
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.
-
Comfortable chair
