Microsoft Excel 365 Intermediate | Live, ONLINE

Take your Excel skills to the next level with Excel Intermediate and learn more of the advanced features & functions.

Description

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

Course Format

  • Live, Online, Instructor-led training
  • This workshop is hosted by the instructor on the GotoTraining platform. Access information and any course materials will be provided to you by the instructor via email in advance of the training.
  • This course is delivered in partnership with local construction associations across Canada. You will be participating with a cohort of industry peers from multiple regions.

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

Technical Requirements

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

Course Requirements (Technology & Participation)

Note: Access to the Microsoft Excel desktop app is required for this course. It is also highly recommended to have two screens/monitors.

Detailed Course Outline

Part 1: Cleaning and Formatting Data

  • Data Cleanup
  • Text To Columns
  • Flash Fill
  • Removing Duplicates
  • Conditional Formatting
  • Tables

Part 2: Summarizing and Analyzing Data

  • PivotTables
  • Slicers
  • Charts
  • PivotCharts

Part 3: Smart Functions for Work Tracking

  • The IF Function
  • IFS
  • SUMIF and SUMIFS
  • SUMIF
  • SUMIFS
  • IFERROR
  • TODAY

Part 4: Lookups & Automation

  • Dropdown Lists
  • XLOOKUP