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