2. Excel Advanced Part 1
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
Course duration:4 hours.