Gold Seal: 1 Credit
This interactive, live instructor-led online training course will cover the same content as the in-person course. All live online courses will be recorded, and participants will have access to the recorded session for 3 months.
Learn to use Excel to create budgets, track costs and generate quotes. Learn tools and ideas that will save time and create professional-looking proposals and plans. Participants with only a very basic knowledge of Excel will quickly progress to create basic databases, budgets, graphs, reports, and the fundamentals of building equations.
The following list summarizes skills that participants will be comfortable with after this course:
Customize excel options and views.
Create and manipulate tables.
Filter and sort data.
Use the correct syntax to insert functions.
Create and format cells and ranges.
Order and group cells and ranges.
Apply cell ranges and references in formulas and functions.
Summarize data with functions.
Apply conditional logic in functions.
Format and modify text with functions.
Create and format charts and objects
This hands-on course is taught by a certified Microsoft Master Instructor.
You will need to have Excel 2016 (or newer) program downloaded and installed on the computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. The web version will not be suitable.
In order to participate in this course, you will require either two monitors or a second device (tablet) or computer so that you are able to watch the instructor while at the same time practicing and applying the new skills.
Delivery Method: Virtual Session – MS Teams
Course Fee Includes: Access to the course, course materials, and upon completion a digital certificate if requested.
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.
While there are no prerequisites for this session, this course assumes that students have completed the Microsoft Office Basics course or have equivalent basic knowledge of how to use a computer.
Who Should Attend
This course is ideal for any individuals who have basic knowledge in Excel and are looking to broaden their skills.
What Previous Participants Have Said
“The instruction was excellent, and the teacher was able to clearly demonstrate the material to the students.”
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
Software/Programs - Excel 2016 (or newer) program downloaded and installed on the computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. 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
Download Program Here: https://www.microsoft.com/en-ca/microsoft-365/buy/compare-all-microsoft-365-products
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.