Excel Formulas & Functions: Master 25 Essential Skills
Quadri Ilebiyi
Ve esta clase y miles más
Ve esta clase y miles más
Lecciones en esta clase
-
-
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
-
-
- --
- Nivel principiante
- Nivel intermedio
- Nivel avanzado
- Todos los niveles
Generado por la comunidad
El nivel se determina según la opinión de la mayoría de los estudiantes que han dejado reseñas en esta clase. La recomendación del profesor o de la profesora se muestra hasta que se recopilen al menos 5 reseñas de estudiantes.
5
Estudiantes
--
Proyectos
Acerca de esta clase
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
Proyecto de clase práctica
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
Valoración de la clase
¿Por qué unirse a Skillshare?
Mira las galardonadas Skillshare Originals
Cada clase tiene lecciones cortas y proyectos prácticos
Tu membresía apoya a los profesores de Skillshare
Aprende desde cualquier lugar
Ve clases sobre la marcha con la aplicación de Skillshare. Progresa en línea o descarga las clases para verlas en el avión, el metro o donde sea que aprendas mejor.
