Excel Formulas: Intermediate Level I

Intermediate Level Excel – Formulas

In this Intermediate Level Excel – Formula Course, you’ll learn how to use a variety of helpful Excel spreadsheet tools and techniques for working with Excel workbook data. These skills include handling dates and times, making your data look better with colors and rules, searching for information, figuring out money-related stuff, counting things in different ways, and more. Once you get the hang of these tools, you’ll be able to easily find specific data, work with dates and times easily, search for complex information, and make smart decisions based on data. These skills will make you really good at managing data in Excel and help you work more efficiently and confidently. So, for the best Excel Tutorials Intermediate course, look no further!

Intermediate Level Excel – Formulas – AGGREGATE & SEQUENCE:

You will learn how to use the AGGREGATE function along with the SEQUENCE function to determine relative rows and columns in Excel.

DATE & TIME:

You will learn how to manipulate and work with date and time values in Excel, including tasks like showing the first and last day of the month, calculating future years, calculating durations, formatting week numbers, and more.

FILTER:

You will learn how to use the FILTER function to extract specific data based on various conditions, such as filtering golfer information by month or date, finding non-blank data, and filtering based on multiple criteria.

Intermediate Level Excel INDEX & INDEX-MATCH:

You will learn how to use the INDEX function to retrieve values from a range, and how to use INDEX-MATCH to perform more advanced lookups, including scenarios like finding missing values, looking up based on multiple criteria, and more.

XMATCH:

You will learn how to use the XMATCH function to perform advanced lookup and matching operations, such as finding players with the lowest golf score and ranking them.

SORT:

You will learn how to use the SORT function to sort data based on specific criteria, like sorting by sponsor list, sorting by random letters, and sorting based on various conditions.

SUMPRODUCT:

You will learn how to use the SUMPRODUCT function to perform array-based calculations, such as counting, summing, and averaging data based on various conditions.

SUMS:

You will learn how to use the SUM function to perform basic summation tasks, including summing data from multiple worksheets and ignoring errors.

TEXTJOIN:

You will learn how to use the TEXTJOIN function to concatenate text values with specified delimiters, for tasks like generating random output, searching for matching words, and more.