BEGIN:VCALENDAR VERSION:2.0 PRODID:-//ChamberMaster//Event Calendar 2.0//EN METHOD:PUBLISH X-PUBLISHED-TTL:P1H REFRESH-INTERVAL:P1H CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:America/St_Johns BEGIN:DAYLIGHT RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU DTSTART:20120101T000000 TZOFFSETFROM:-0330 TZOFFSETTO:-0230 TZNAME:Newfoundland Daylight Time END:DAYLIGHT BEGIN:STANDARD RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU DTSTART:20120101T000000 TZOFFSETFROM:-0230 TZOFFSETTO:-0330 TZNAME:Newfoundland Standard Time END:STANDARD END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=America/St_Johns:20260609T120000 DTEND;TZID=America/St_Johns:20260609T160000 X-MICROSOFT-CDO-ALLDAYEVENT:FALSE SUMMARY:Microsoft Excel Intermediate 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 Details: \nTuesday\, June 9\n12:00 PM - 4:00 PM NDT\nCost: $249.00 +hst NLCA Members / $349.00 +hst Non-Members 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. 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\n\n\nInstructor: Izzy Perry\, Microsoft Office Specialist Expert and Microsoft Certified Trainer. \n\nMethod of Delivery: This course is delivered as an interactive Virtual Instructor Led Training (VILT) course using the PESL GoToTraining platform. Duration: 1/2 Day (4 hours) Canadian Construction Association Gold Seal Certification Program: This course is a CCA Gold Seal Certified Course (1 Credit).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 highly recommended to have two screens/monitors. Course Length: day (4 hours) X-ALT-DESC;FMTTYPE=text/html:

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 Details: \;
Tuesday\, June 9
12:00 PM - 4:00 PM NDT
Cost: $249.00 +hst NLCA Members / $349.00 +hst Non-Members \;

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. \;

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

Instructor: Izzy Perry\, Microsoft Office Specialist Expert and Microsoft Certified Trainer. \;

Method of Delivery: This course is delivered as an interactive Virtual Instructor Led Training (VILT) course using the PESL GoToTraining platform. \;

Duration: 1/2 Day (4 hours) Canadian Construction Association Gold Seal Certification Program: This course is a CCA Gold Seal Certified Course (1 Credit).

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 highly recommended to have two screens/monitors. \;

Course Length: ½\; day (4 hours)

LOCATION: UID:e.2373.1426631 SEQUENCE:3 DTSTAMP:20260405T171042Z URL:https://members.nlca.ca/corytest/Details/microsoft-excel-intermediate-1687295?sourceTypeId=Hub END:VEVENT END:VCALENDAR