Course Description

Strengthen your excel skills by discovering the ‘magic’ of excel.. Reduce and ensure integrity of data by linking contents between worksheets and workbooks. Prevent workbook input errors by implementing protection. Control your data outputs using Power Query and analyze via Pivot tables and visualizations. 

Learner Outcomes

  • Use logical functions including the IF, COUNTIF, SUMIF, functions, and conditional formatting 
  • Create text- and graphic-based hyperlinks to other files and web sites 
  • Link and group worksheets and workbooks 
  • Employ date and time functions 
  • Design operational databases 
    • Create and maintain a table/database 
    • Find and sort data in a table/database 
    • Filter a table/database 
    • Validate data entry – control data integrity  
    • Produce Pivot tables and visualizations using Charts and slicers 
  • Customize printing options 
  • Decrease workload - build templates 
  • Add security 
  • Use the VLOOKUP function or equivalent (Xlookup) 


MCRO 852V Office 365 Excel Bootcamp 1: Microsoft Office Career Accelerator or equivalent skills plus strong file management skills. Word Level 1 or equivalent skills recommended.

Applies Towards the Following Certificates


Be the first to know when this course is available!

Unfortunately, this course is currently not open for enrollment or is in the process of being rescheduled. Join Our Interest List below to be notified via email when the course is next available for registration.


We are especially grateful to live, work, and play on the traditional territories of the Lekwungen (Songhees, Esquimalt), Malahat, Pacheedaht, Scia'new, T'Sou-ke, and WSÁNEĆ (Pauquachin, Tsartlip, Tsawout, Tseycum) peoples. We acknowledge their welcome and graciousness to the students who seek knowledge here.

Required fields are indicated by .