Online Courses

Excel Formulas and Functions Master Class

369 lectures

17 total hours

Deep Dive into Text Functions in Excel

26 lectures

1 total hour

Deep Dive into Logical and Informational Functions in Excel

29 lectures

1.5 total hours

Understanding Date and Time Functions in Excel

21 lectures

1 total hour

Understanding Lambdas and Math Functions in Excel

32 lectures

1.5 total hours

Basic Business Formulas in Microsoft Excel

15 lectures

1 total hour

Inferential and descriptive statistical formulas in Excel

42 lectures

2 total hours

Deep Dive into lookup functions in Excel

21 lectures

1 total hour

Using Regresion to Forecast in Microsoft Excel

30 lectures

1.5 total hours

Time Value of Money and Finance Functions in Excel

45 lectures

2.5 total hours

Introduction to Tables and Pivot Tables in Excel

30 lectures

1 total hour

Business Modeling and Solving Business Problems in Excel

27 lectures

1 total hour

Excel Formulas and Functions Master Class

369 lectures 17 total hours

Unlock the full potential of Microsoft Excel with our comprehensive course, Master Excel Formulas and Functions, designed to transform you into a confident spreadsheet expert. Based on the authoritative book Formulas and Functions: Microsoft Excel Office 2021 & Microsoft 365, this course dives deep into the essential tools and techniques you need to harness Excel’s powerful formula and function capabilities.

Deep Dive into Text Functions in Excel

26 lectures 17 total hour

Working with Text Functions, equips learners with essential skills to manage and manipulate text data effectively in Excel. This section begins by introducing how Excel handles characters and codes, helping students understand the CODE function and its applications.

Deep Dive into Logical and Informational Functions in Excel

29 lectures 1.5 total hours

Working with Logical and Information Functions, is designed to help learners add intelligence and adaptability to their Excel spreadsheets. This chapter introduces the foundational IF function and progresses to more complex uses such as handling false results, avoiding division by zero, and building nested logical tests.

Understanding Date and Time Functions in Excel

21 lectures 1 total hour

Working with Date and Time Functions, provides learners with a comprehensive understanding of how Excel handles dates and times and how to effectively use built-in functions to manipulate this data. The chapter starts by explaining Excel’s unique system for storing dates and times, laying a foundation for working confidently with these values.

Understanding Lambdas and Math Functions in Excel

32 lectures 1.5 total hours

This course dives deep into Excel’s powerful math functions, equipping students with the knowledge to perform a wide variety of numerical operations and data manipulations. Whether you're rounding numbers for cleaner financial reports or generating randomized values for simulations, this section introduces a comprehensive suite of tools designed to improve precision and efficiency.

Basic Business Formulas in Microsoft Excel

15 lectures 1 total hour

Implementing Basic Business Formulas, offers a comprehensive exploration of key Excel formulas designed specifically for practical business applications. This chapter equips learners with the skills to create dynamic and customizable models that streamline financial analysis and business decision-making.

Inferential and descriptive statistical formulas in Excel

42 lectures 2 total hours

This course focuses on building and applying statistical formulas in Microsoft Excel, with an emphasis on both descriptive and inferential analysis. It is designed for students, professionals, and data users who want to deepen their understanding of statistics and apply it using the tools built into Excel.

Deep Dive into lookup functions in Excel

21 lectures 1 total hour

Working with Lookup Functions, provides learners with the essential tools and techniques to retrieve and reference data efficiently in Excel using various lookup functions. This chapter starts by explaining the structure and purpose of lookup tables, then introduces the CHOOSE function. Students will use CHOOSE to return specific values like fiscal months or days of the week and learn to integrate this function with...

Using Regresion to Forecast in Microsoft Excel

30 lectures 1.5 total hours

This course is designed for learners who want to apply regression analysis in Excel to uncover trends, analyze relationships, and forecast future outcomes with confidence. Using the powerful tools available in Microsoft Excel (Office 2021 and Microsoft 365), students will develop hands-on skills in both linear and nonlinear regression techniques, enabling them to make data-driven decisions across a variety of professional and academic contexts.

Time Value of Money and Finance Functions in Excel

45 lectures 2.5 total hours

This course provides a practical, hands-on approach to building financial models in Microsoft Excel, focusing on loans, investments, and discounting techniques. Designed for students, professionals, and business users, the course covers essential financial concepts and shows how to apply them using Excel’s built-in formulas and functions.

Introduction to Tables and Pivot Tables in Excel

30 lectures 1 total hour

This comprehensive Excel course is designed to empower learners with advanced skills in data analysis, focusing on the powerful capabilities of tables and PivotTables. Participants will develop a strong foundation in organizing and managing large datasets efficiently, enabling them to sort and filter data in a variety of ways to reveal important patterns and insights.

Business Modeling and Solving Business Problems in Excel

27 lectures 1 total hour

This course provides comprehensive training on Excel’s powerful business modeling tools designed to enhance decision-making and problem-solving skills. Students will learn to perform advanced what-if analysis using one- and two-input data tables, allowing them to explore different scenarios and forecast outcomes effectively. The course covers Goal Seek techniques to identify precise input values needed to achieve specific targets...

Excel Formulas and Functions Master Class

Deep Dive into Text Functions in Excel

Deep Dive into Logical and Informational Functions in Excel

Understanding Date and Time Functions in Excel

Understanding Lambdas and Math Functions in Excel

Basic Business Formulas in Microsoft Excel

Inferential and descriptive statistical formulas in Excel

Deep Dive into lookup functions in Excel

Using Regresion to Forecast in Microsoft Excel

Time Value of Money and Finance Functions in Excel

Introduction to Tables and Pivot Tables in Excel

Business Modeling and Solving Business Problems in Excel

Excel Formulas and Functions Master Class

Deep Dive into Text Functions in Excel

Deep Dive into Logical and Informational Functions in Excel

Understanding Date and Time Functions in Excel

Understanding Lambdas and Math Functions in Excel

Basic Business Formulas in Microsoft Excel

Inferential and descriptive statistical formulas in Excel

Deep Dive into lookup functions in Excel

Using Regresion to Forecast in Microsoft Excel

Time Value of Money and Finance Functions in Excel

Introduction to Tables and Pivot Tables in Excel

Business Modeling and Solving Business Problems in Excel

Phone number:

Email:

Address: