Excel Formulas You Need to Know in 30 Minutes! | Excel Classes | Skillshare

# Excel Formulas You Need to Know in 30 Minutes!

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

0:58

2:04

1:24

4:58

2:34

4:14

6:07

3:40

2:38

1:54
• ### 11. CONCAT

3:35
65 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,034

Students

1

Project

Learn essential Excel formulas and functions in 30 minutes!

Excel is an incredibly useful piece of software, but you can only begin to make the most of it once you have a basic understanding of formula writing, functions, and cell referencing. In this class, we'll cover all of those topics.

Who is this class for?

If you're a beginner who is completely new to Excel, or are looking for a refresh of the basics, then this class is for you!

At the end of the class you'll:

Understand how to use many of the most popular and commonly used formulas, helping you to analyze information in Excel quickly and easily.

What does theÂ class cover?

TheÂ class is broken out intoÂ nine short videos covering the following topics:

1. Introduction
2. Arithmetic and basic formulas
3. Cell Referencing
4. SUM, COUNT, COUNTA, AVERAGE, MIN, MAX
5. SUMIF, COUNTIF, AVERAGEIF
6. SUMIFS, COUNTIFS, AVERAGEIFS
7. VLOOKUP
8. HLOOKUP
9. LOWER, UPPER, TRIM, PROPER
10. CONCAT

How do I practiceÂ or follow along?

You can download the Excel file that's used in the videos to practice all the formulas and functions either as you watch the class, or afterwards :)

#### Excel Classes

Excel teacher

Teacher

Hello, I'm Julian.

I'm a digital marketing consultant with 10+ years experience in using and teaching Excel, having worked for a number of agencies and international brands.

I'm passionate about teaching Microsoft Excel in a simple and straightforward way. Check out my classes today to learn more about Excel :)

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