Excel Formulas – Intermediate Level II

Excel Formulas – Intermediate Level Course

Our Excel Formulas – Intermediate Level Course teaches you a variety of useful Excel techniques without any tricky stuff. The lessons cover a wide range of topics at the intermediate level, helping you work with Excel more effectively.

You’ll learn about functions like HYPERLINK, which lets you create links; IF, for making decisions based on conditions; INDEX, which helps you fetch data; and INDEX & MATCH, a more advanced way to search for information. These are just a few examples of what you’ll learn.

Math Functions

You’ll also discover how to use math functions for calculations, like finding the highest (MAX) and lowest (MIN) values. For manipulating text, you’ll explore SUBSTITUTE. When you need to add things up, SUM, SUMIF, and SUMPRODUCT will be your tools.

The course also covers working with time, changing the way data is arranged (transposing), and pulling out specific pieces of text. Each section of the course gives you practical tips and insights to enhance your Excel skills and handle various tasks involving data.

What Will I Learn

HYPERLINK – You’ll learn how to create hyperlinks in Excel to link to other worksheets, web pages, and email addresses.

IF – You’ll learn how to use the IF function to perform conditional checks and make decisions based on certain conditions.

INDEX – You’ll learn how to use the INDEX function to retrieve data from specific rows and columns in a table or range.

INDEX & MATCH – You’ll learn how to combine the INDEX and MATCH functions to perform more advanced lookup operations, including searching for specific values in a table.

INDIRECT – You’ll learn how to use the INDIRECT function to create dynamic references to other cells or ranges in your workbook.

LOOKUP – You’ll learn how to use the LOOKUP function to find values within a range and return corresponding values from another range.

MATCH – You’ll learn how to use the MATCH function to find the position of a value within a range.

MATH – You’ll learn how to use various mathematical functions in Excel for calculations and analysis.

MAX – You’ll learn how to use the MAX function to find the highest value in a range.

MIN – You’ll learn how to use the MIN function to find the lowest value in a range.

MOD – You’ll learn how to use the MOD function to perform modular arithmetic, often used for repeating patterns.

OFFSET – You’ll learn how to use the OFFSET function to reference a range of cells relative to a starting point.

OTHER – This section covers various tasks such as text manipulation, conditional formatting, and more.

RAND – You’ll learn how to use the RAND function to generate random numbers.

ROUND – You’ll learn how to use the ROUND function to round numbers to a specified number of decimal places.

ROW & COLUMN – You’ll learn how to use the ROW and COLUMN functions to retrieve information about rows and columns.

SMALL & LARGE – You’ll learn how to use the SMALL and LARGE functions to retrieve the smallest or largest values from a range.

SUBSTITUTE – You’ll learn how to use the SUBSTITUTE function to replace specific text within a string.

SUM – You’ll learn how to use the SUM function to calculate the sum of a range of numbers.

SUMIF – You’ll learn how to use the SUMIF function to sum values based on specific criteria.

SUMPRODUCT – You’ll learn how to use the SUMPRODUCT function to perform calculations on arrays of values.

TEXT – You’ll learn how to use various text functions to manipulate and format text in Excel.

TEXT-EXTRACT – This section covers techniques to extract specific information from text strings.

TIME – You’ll learn how to work with time-related functions and calculations.

TRANSPOSE – You’ll learn how to use the TRANSPOSE function to switch rows and columns in a range.

WORKDAY – You’ll learn how to use the WORKDAY function to calculate workdays between dates, excluding weekends and holidays.