MS Excel Expert - Part 1
Description
Using Latest Functions
(Prerequisite - MS Excel Advanced - Part 1 or equivalent)
Stay ahead of the curve with Excel’s newest and most advanced functions. This expert-level course
focuses on dynamic arrays, spill functions, and other modern tools that make formulas more flexible
and powerful. You’ll also explore financial, lookup, and information
functions, learning when and how to apply them to real-world engineering and construction data.
Participants will discover how to automate data expansion, convert information into
multicolumn reports, and even get a first look at macros and VBA for process automation. This
course is ideal for professionals who want to push Excel’s capabilities to their fullest potential.
• Building functions that will automatically expand with new data
o Spill Functions
o Using advanced Trim Range options so that data will automatically apply functions as needed
• Finding and applying multi-argument functions
o How to discover the function you need
o Getting help with new functions
o Using Finance Functions
o Converting data into multicolumn reports with formulas
• Use advanced functions such as
o Information
o Lookup and reference
• Create, modify, or remove a hyperlink
• Introduction to macros and VBA
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.