MS Excel Advanced - Part 1
Description
Implementing Multi-Argument Functions
This course takes a deep dive into Excel’s most powerful formulas and functions to help you manage, analyze, and summarize large volumes of project data. Participants will learn to combine Named Ranges and Tables for efficient referencing, apply logical and conditional functions, and perform complex time and data calculations. You’ll also explore ways to automate formatting, protect your worksheets, and use formula-driven conditional formatting for precise visual control. This session empowers construction and engineering professionals to handle advanced analytical tasks with confidence and precision.
• Tables
- Using Tables and Named Ranges together in formulas
- Advanced Filtering
• Charts
- Customizing Charts
• Functions
- Apply cell ranges and references in formulas and functions
- Apply conditional logic in functions
- Summarize data with functions
- Working with Time Calculations
- Consolidate data
• Advanced Formatting
- Add protection to workbooks and worksheets
- Format and modify text with functions
- Apply Conditional formatting using formulas
Delivery Method: Virtual Session – Zoom Meetings
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.