Excel Formulas & Functions Part 1+2: Formulas 101 | Chris Dutton | Skillshare

# Excel Formulas & Functions Part 1+2: Formulas 101

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
11 Lessons (39m)

1:06

4:37

1:25

3:31

4:57

7:25

6:36

2:08

3:28

3:21
• ### 11. Homework

0:46
18 students are watching this class
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

1,520

Students

1

Project

This course is part 1 & 2 of a 9-part series on Excel Formulas & Functions: from basic to advanced.

In Excel Formulas 101, we'll explore Excel's formula library and auditing tools, practice basic formula syntax, and learn the importance of fixed, relative, and mixed reference types. From there we'll dive into common errors, helpful PC & Mac shortcuts, and more. This will give you the tools you need to cruise through the rest of the series and emerge a certified Excel ninja.

About the Excel Formulas & Functions Series:

In this series, you will develop tools to transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Courses cover 75+ formulas, and feature hands-on, contextual demos and practice exercises designed to help you not only memorize formula syntax, but to think like Excel.

You'll learn how to write complex, powerful functions from scratch, allowing you to:

• Build dynamic tools & dashboards to filter, display and analyze your data
• Join datasets from multiple sources in seconds with LOOKUP, INDEX & MATCH functions
• Pull real-time data from APIs directly into Excel using WEBSERVICE & FILTERXML
• Manipulate dates, times, text, and arrays with ease
• Automate tedious and time-consuming analytics tasks (no VBA required!)
• And much more

If you're looking for the ONE series covering all of the advanced formulas and functions that you need to become an absolute Excel rock star, you've found it!

#### Chris Dutton

Founder, Excel Maven

Teacher

Chris Dutton is a Certified Microsoft Expert and Founder of Excel Maven, with more than a decade of experience specializing in data science and business intelligence. His work has been featured by Microsoft, the Society of American Baseball Research (SABR) and the New York Times.

Excel Maven provides high-quality online analytics training, hands-on workshops, and project-based consulting services to more than 100,000 students across 180+ countries.

See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

# Your creative journey starts here.

• Supportive online creative community
• Learn offline with Skillshare’s app

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects