Excel Formulas & Functions: Master 25 Essential Skills
Quadri Ilebiyi
Assista a este curso e milhares de outros
Assista a este curso e milhares de outros
Aulas neste curso
-
-
1.
Welcome to the course
2:23
-
2.
Difference between formulas & Functions
11:23
-
3.
Download your Resource files
0:43
-
4.
SUM, SUBTRACT, PRODUCT, DIVIDE
14:18
-
5.
MIN, MAX, AVG
1:29
-
6.
Mean, Median, Mode, Standard Deviation
1:43
-
7.
LARGE, SMALL
3:00
-
8.
COUNT, COUNTA, COUNTBLANK
6:21
-
9.
TOTAL, SUBTOTAL, AGGREGATE
11:07
-
10.
IF Function
3:59
-
11.
IF, AND
5:56
-
12.
IF, OR
2:19
-
13.
IFERROR
2:55
-
14.
IFS Function
5:02
-
15.
SUMIF, SUMIFS
9:27
-
16.
COUNTIF, COUNTIFS
2:49
-
17.
AVERAGEIF, ABERAGEIFS
2:44
-
18.
Data Validaton
5:54
-
19.
VLOOKUP
5:56
-
20.
VLOOKUP (1 result)
1:35
-
21.
VLOOKUP (2 results)
6:53
-
22.
INDEX & MATCH
10:25
-
23.
INDEX & MATCH (Nested)
3:21
-
24.
HLOOKUP
1:55
-
25.
XLOOKUP (1 result)
1:56
-
26.
XLOOKUP (2 result)
2:25
-
27.
XLOOKUP (Advanced)
3:55
-
28.
XLOOKUP (Joining tables)
2:36
-
29.
PROPER, UPPER, LOWER
1:10
-
30.
LEN
0:39
-
31.
LEFT, RIGHT, MID
4:24
-
32.
TEXTSPLIT & TEXTJOIN
2:13
-
33.
TEXTBEFORE & TEXTAFTER
4:03
-
34.
TRIM
0:59
-
35.
CONCATENATE
2:34
-
36.
TODAY & NOW
0:41
-
37.
DATEDIF
2:42
-
38.
SORT
3:18
-
39.
FILTER
4:24
-
40.
SEQUENCE
4:34
-
41.
UNIQUE
1:55
-
42.
DISTINCT
4:22
-
-
- --
- Nível iniciante
- Nível intermediário
- Nível avançado
- Todos os níveis
Gerado pela comunidade
O nível é determinado pela opinião da maioria dos estudantes que avaliaram este curso. Mostramos a recomendação do professor até que sejam coletadas as respostas de pelo menos 5 estudantes.
5
Estudantes
--
Sobre este curso
Create stunning Excel dashboards fast with Pivot Tables, charts, slicers, AI and AI tools like Microsoft Copilot AI.
Are you tired of manually crunching numbers in Excel and wasting time with repetitive tasks? This course will change the way you work forever.
Welcome to “Excel Formulas & Functions: Master 25 Essential Skills” the only course you need to go from formula confusion to formula confidence.
In this hands-on and beginner-friendly course, you’ll learn 25 of the most powerful Excel functions that professionals use daily to solve real business problems, speed up analysis, and impress clients or employers. These functions are the foundation of modern Excel productivity and mastering them means you can clean data, automate calculations, extract values, find trends, and build smarter spreadsheets with ease.
You’ll discover how to use functions like VLOOKUP, XLOOKUP, IF, IFS, SUMIF, SUMIFS, COUNTIF, COUNTIFS, SORT, FILTER, SEQUENCE, UNIQUE, DISTINCT, DATE, LEFT, RIGHT, LEN, and many more all explained with real examples, step-by-step demos, and practical scenarios.
Whether you work in finance, sales, admin, HR, education, or data analysis this course will give you Excel superpowers.
By the end, you’ll have a personalized toolkit of essential Excel formulas and know exactly when and how to use them to work faster, cleaner, and smarter.
If you're ready to finally understand Excel formulas and actually enjoy using them watch now and level up your Excel skills.
Download the resource files: https://drive.google.com/drive/folders/1R6hildU5aM0uIbjK0ogcpbXyooveACW6?usp=sharing
Projeto prático de curso
Project Instructions
Download the resource files: https://drive.google.com/drive/folders/1R6hildU5aM0uIbjK0ogcpbXyooveACW6?usp=sharing
For your class project
- After downloading the Resource Files from the link above then, practice along with me in the course as I teach you practically from scratch how to use the different Excel Formulas & Functions with Hands-on Real-World Projects
Submit your final result as an excel file
Nota do curso
Por que fazer parte da Skillshare?
Faça cursos premiados Skillshare Original
Cada curso possui aulas curtas e projetos práticos
Sua assinatura apoia os professores da Skillshare
Aprenda em qualquer lugar
Faça cursos em qualquer lugar com o aplicativo da Skillshare. Assista no avião, no metrô ou em qualquer lugar que funcione melhor para você, por streaming ou download.
Cursos relacionados
