Excel Mastery: Formulas and Functions

Excel Mastery: Formulas and Functions, available at Free, has an average rating of 4.54, with 13 lectures, based on 37 reviews, and has 889 subscribers.

You will learn about Taught by a 2 time Excel MVP Learn the basics of entering formulas Learn how to use the Insert Function tool to understand every function in Excel Understand what absolute and relative referencing are Utilize named ranges to make your spreadsheets more efficient Learn lookup functions like: Xlookup, Vlookup, and Index-Match Use IF statements to add dynamic flexibility to your spreadsheet models Get a primer on the most frequently used text functions This course is ideal for individuals who are This course is for people that are new to Excel, or not quite sure how formulas work or If you don't know the difference between absolute and relative referencing or If you don't know how to do lookups (especially Xlookup) It is particularly useful for This course is for people that are new to Excel, or not quite sure how formulas work or If you don't know the difference between absolute and relative referencing or If you don't know how to do lookups (especially Xlookup).

Enroll now: Excel Mastery: Formulas and Functions

Summary

Title: Excel Mastery: Formulas and Functions

Price: Free

Average Rating: 4.54

Number of Lectures: 13

Number of Published Lectures: 13

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Taught by a 2 time Excel MVP
Learn the basics of entering formulas
Learn how to use the Insert Function tool to understand every function in Excel
Understand what absolute and relative referencing are
Utilize named ranges to make your spreadsheets more efficient
Learn lookup functions like: Xlookup, Vlookup, and Index-Match
Use IF statements to add dynamic flexibility to your spreadsheet models
Get a primer on the most frequently used text functions

Who Should Attend

This course is for people that are new to Excel, or not quite sure how formulas work
If you don't know the difference between absolute and relative referencing
If you don't know how to do lookups (especially Xlookup)

Target Audiences

This course is for people that are new to Excel, or not quite sure how formulas work
If you don't know the difference between absolute and relative referencing
If you don't know how to do lookups (especially Xlookup)

In this course, you’ll gain comprehensive knowledge to become proficient in writing formulas and using functions in Excel.

Formulas Section 1:

Basics: We’ll start with the basics, focusing on writing simple formulas. This foundation is crucial for understanding more complex functions later on.
Relative and Absolute Referencing: You’ll learn these key concepts, which are essential for creating larger and more intricate spreadsheets. Knowing when to use relative versus absolute references can make your formulas more dynamic and accurate.
Named Ranges: Discover how named ranges can save time and make your spreadsheets easier to maintain. Named ranges not only enhance readability but also simplify formula creation and management.
Aggregate Functions: We’ll cover essential aggregate functions, including IF and IFS functions (SUMIF, COUNTIFS, etc.). These functions are the workhorses for analyzing groups of data in various ways, allowing you to perform conditional calculations efficiently.

Formulas Section 2:

Most Utilized Functions: Begin with an introduction to 11 of the most utilized functions in Excel, plus one additional function for fun. These functions are fundamental for data analysis and manipulation.
Text Splitting and Duplicate Removal: Learn how to split text from one column into many, a useful skill for cleaning and organizing data. Additionally, we’ll demonstrate how to remove duplicates, ensuring your datasets are accurate and streamlined.
IF Statement: Understand the versatile IF statement, which allows you to perform different actions based on specified criteria. This function is indispensable for creating logical tests and conditional outcomes in your spreadsheets.
Lookup Functions: Delve into crucial lookup functions such as XLOOKUP, VLOOKUP, and INDEXMATCH. These functions are essential for finding and retrieving data from large datasets. While XLOOKUP is the recommended go-to for its versatility and ease of use, VLOOKUP and INDEXMATCH remain important for ensuring compatibility with older spreadsheets.

By the end of this course, you’ll have the confidence and skills to master formulas and functions in Excel. Whether you’re managing personal finances, handling business data, or conducting complex analyses, you’ll be equipped to tackle any challenge Excel throws your way.

Course Curriculum

Chapter 1: Intro to formulas

Lecture 1: Workbook

Lecture 2: Formula Basics

Lecture 3: Function Builder

Lecture 4: Absolute References

Lecture 5: Named Ranges

Lecture 6: Aggregation: IF and IFS functions

Chapter 2: Formulas Part 2

Lecture 1: workbook

Lecture 2: Text functions

Lecture 3: Text to columns

Lecture 4: Remove Duplicates

Lecture 5: IF statement

Lecture 6: Lookups

Lecture 7: Index Match

Instructors

Tom Hinkle
Master of Excel, SQL, Tableau (and other tools…)

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 14 votes
5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu