3. Excel Expert Part 1
Using Latest Functions
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
-
Spill Functions
-
Using advanced TrimRange options so that data will automatically apply functions as needed
-
Finding and applying multi-argument functions
-
How to discover the function you need
-
Getting help on new functions
-
Using Finance Functions
-
Converting data into multicolumn reports with formulas
-
Use advanced functions such as
-
Information
-
Lookup and reference
-
Create, modify or remove a hyperlink
-
Introduction to macros and VBA
Course duration:4 hours.