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
Loading...

Enroll Now - Select a section to enroll in

Section Title
Advanced Excel Functions
Type
Online, self paced
Dates
Feb 02, 2026 to Feb 27, 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: February 2-27, 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.
Section Title
Advanced Excel Functions
Type
Online, self paced
Dates
Apr 06, 2026 to May 01, 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: April 6, 2026 to May 1, 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.
Section Title
Advanced Excel Functions
Type
Online, self paced
Dates
Jun 01, 2026 to Jun 26, 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: June 1, 2026 to June 26, 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.