Advance Your Skills with Excel Formulas and Functions

Unlock the potential of Excel formulas and functions. Start with formula basics, then advance your skills with focused tips and in-depth explorations of lookups (including VLOOKUP and XLOOKUP) and financial functions. By the end of this learning path, you’ll be able to elevate your productivity with advanced Excel formulas and functions.

Practice using Excel formulas and functions.
Discover advanced lookup techniques.
Explore counting, date and time, and mathematical formulas.
Analyze data with financial functions.

Syllabus

Courses under this program:
Course 1: Excel: Introduction to Formulas and Functions
-Get a beginner-level introduction to Excel formulas and functions. Learn how to summarize and analyze data using these powerful data analysis features.

Course 2: Excel Formulas and Functions Quick Tips
-Learn essential Excel skills, from basic formulas and functions to advanced data manipulation techniques in order to efficiently calculate, analyze, and organize data.

Course 3: Excel: Lookup Functions in Depth
-Unlock the full potential of Excel by leveraging lookup functions, including the powerful XLOOKUP and dynamic array functions.

Course 4: Excel: Financial Functions in Depth
-Learn the skills to perform advanced financial analysis in Excel, including calculating loan payments, depreciation, investment returns, and dynamic financial models.

Course 5: Excel: Advanced Formulas and Functions
-Learn the important formulas and functions you need to know about in Microsoft Excel.