Microsoft Excel 365 Intermediate

Gold Seal: 1 Credit

Description

This course is intended for anyone with a foundational understanding of Microsoft Excel and wants to dive deeper into some of its more advanced features and functions.

In this course, students will learn to:

  • Customize the Ribbon and Quick Access Toolbar
  • Define and use Names and Named Ranges
  • Create links to other sheets and external workbooks
  • Use Conditional Formatting
  • Create and manage Tables and Charts
  • Create and work with Pivot Tables to quickly analyze and visualize information
  • Create and work with logical functions including IF(S), SUMIF(S), AVERAGEIF(S) and COUNTIF(S)
  • Create and work with Lookup functions such as VLOOKUP and XLOOKUP

 

This hands-on course is taught by a certified Microsoft Master Instructor. 

You will need to have MS Excel 2016 (or newer) program downloaded and installed on the computer. 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.  

IMPORTANT NOTE:  This is a new session from a new provider. If you are looking for the full-day (8 Hour) Microsoft Excel Basics for Business training we offered previously, please reach out to training@icba.ca  

 

Delivery Method: Virtual Session – GoToTraining  

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 Excel and Windows, including being able to start programs, switch between programs, locate saved files, and close programs. Basic Excel skills are also required.

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

Who Should Attend

This course is intended for anyone who wants to gain a intermediate level understanding of Microsoft Excel.

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, cellphones may not be adequate

    • Windows 10 or Mac iOS. 

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

  2. Microphone (Mandatory)

  3. 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.

  4. 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.

  5. Comfortable chair

 

Similar courses

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit * BC Housing: 7.5 CPD Points

More Information

Gold Seal: 1 Credit - Previously named "Time Management Workshop"

More Information

Gold Seal: 4 Credits * BC Housing: 14 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 6.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 6.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7.5 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 4 Credits * BC Housing: 11 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 6 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 7.5 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Points

More Information

Gold Seal: 1 Credits * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 9 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 4 CPD Points

More Information

Gold Seal: 4 Credits * BC Housing: 12 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 5 Credits * BC Housing: 16 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit * BC Housing: 3.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Credits

More Information

Gold Seal: 5 Credits * BC Housing: 8 CPD Credits

More Information

Gold Seal: 5 Credits * BC Housing: 8 CPD Credits

More Information

Gold Seal: 3 Credits * BC Housing: 3 CPD Points

More Information

Gold Seal: 5 Credits * BC Housing: 10 CPD Credits

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 4 Credits * BC Housing: 14 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 6 CPD Credits

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Credits

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credit * BC Housing: 7.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 4 Credits

More Information

Gold Seal: 4 Credits * BC Housing: 14 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7.5 CPD Points

More Information

BC Housing: 7.5 CPD Points

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 4 Credits

More Information

Gold Seal: 5 Credits * BC Housing: 8 CPD Credits

More Information

Gold Seal: 4 Credits * BC Housing: 12 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

BC Housing: 12 CPD Points

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 10 Credits

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 4 Credits * BC Housing: 12 CPD Points

More Information

Gold Seal: 10 Credits * BC Housing: 30 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 5.5 CPD Points

More Information

Gold Seal: 10 Credits

More Information

Gold Seal: 2 Credits * BC Housing: 8 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Customized Managing and Reporting on Multiple Projects

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 10 Credits * BC Housing: 28 CPD Points

More Information

Gold Seal: 4 Credits * BC Housing: 12 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 9 CPD Points

More Information

Gold Seal: 4 Credits * BC Housing: 12 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 4 CPD Points

More Information

Gold Seal: 1 Credit * BC Housing: 3 CPD Points

More Information

Gold Seal: 4 Credits * BC Housing: 12 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 4 Credits

More Information

Gold Seal: 2 Credits * BC Housing: 3.5 CPD Points

More Information

Gold Seal: 3 Credits * BC Housing: 10.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 10 Credits

More Information