Loading...

Course Description

Take your Excel skills to the next level with this hands-on course designed for professionals who want to master advanced functions and formulas. Whether you're analyzing data, building complex models, or automating tasks, this course will equip you with the tools to work smarter and more efficiently.

You’ll explore powerful Excel functions such as VLOOKUP, INDEX/MATCH, IF statements, nested formulas, and dynamic arrays, while also learning how to troubleshoot errors and optimize your spreadsheets for performance. Through practical exercises and real-world examples, you’ll gain confidence in applying these functions to solve complex problems and streamline your workflow.COurse H ideal for professionals in finance, operations, marketing, HR, and anyone who works extensively with data in Excel.

Course Outline

  • Unit 1: Advanced Lookup & Reference Functions
  • Unit 2: Logical & Conditional Formulas
  • Unit 3: Dynamic Arrays & Data Analysis
  • Unit 4: Formula Auditing & Real-World Applications                                                                                                        

Notes

Instructor: John Rutledge

Format & Time Commitment: Virtual and self‑paced, with defined start and end dates. Expect to spend approximately 4 hours per week on coursework.

Loading...

Enroll Now - Select a section to enroll in

Section Title
Advanced Excel Functions
Type
Online, self paced
Dates
Sep 08, 2026 to Oct 02, 2026
Delivery Options
Online  
Course Fee(s)
Course Fee $195.00 Click here to get more information
CEUs
1.6 CEUs

Section Notes

  • Instructor: John Rutledge
  • Course Format: Virtual, self-guided.
  • Course Duration: September 8, 2026 to October 2, 2026
  • Access to Course: An invitation into the online classroom will be emailed to you typically the Wednesday prior to the start of the course. If you haven’t received the invite by the following morning, you can forward the confirmation email to info@ugotclass.org for a prompt resend.