Microsoft Office Skills Training in Vancouver & Surrey
This beginner-level course introduces you to Excel’s core features. You’ll learn to navigate the interface, create and format spreadsheets, use basic formulas and functions, sort and filter data, and create simple charts.
An intermediate course that dives into often used formulas and functions; VlookUp, data validation, and IF statements. Plus you’ll learn data summarizing techniques with powerful filtering, subtotal grouping techniques and conditional formatting.
Advanced and functions like SUMIFS, COUNTIFS, and array formulas. Master pivot tables, calculated fields and pivot charts, and slicers. Apply advanced conditional formatting, and database functions such as DSUM, DCOUNT and Scenario tools. Discover Xlookup, Hstack, Filter and ChooseCols.
Learn how to create professionally formatted documents modify page layouts, apply styles, and insert tables and images. Quick access toolbar, essential bullet lists, setting tabs and document layout techniques.
Learn multipage headers & footers, section breaks, and adding hyperlinks. Also learn how to add captions to your images and diagrams, manipulate Smart-Art objects and format shapes for custom illustrations.
An advanced course focusing on custom formatting styles, table of contents, tracking changes, inserting Excel charts, cross-referencing, footnotes and endnotes. You’ll also discover a table of authorities, bibliography and handling subdocuments tools.
An intermediate one-day course elevates your Outlook skills. You’ll master managing Contacts, Tasks, and the To-Do list, customize inbox views, use advanced search, implement quick steps, and organize emails with rules and categories. Learn calendar and email search tools.
Discover how to effectively use channels to organize team and channel discussions, including seamlessly sharing files. This course will also cover chat features, such as formatting messages, using @mentions to get attention, and managing your chat history. You'll also discover how to integrate MS Teams with other Microsoft 365 apps to streamline your workflow.
This one-day fast-track course enhances your PowerPoint skills. You’ll learn to create and design professional presentations, use advanced features like animations and transitions, and customize slide layouts to include sectional slide organization.
This course is comprehensive and covers a wide range of topics such as setting up project schedules, task phasing, assigning resources, tracking progress, critical paths and multiple project reports, chart views and more.