Excel Formulas & Functions: Master 25 Essential Skills
Quadri Ilebiyi
Regardez ce cours et des milliers d'autres
Regardez ce cours et des milliers d'autres
Leçons de ce cours
-
-
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
-
-
- --
- Niveau débutant
- Niveau intermédiaire
- Niveau avancé
- Tous niveaux
Généré par la communauté
Le niveau est déterminé par l'opinion majoritaire des apprenants qui ont évalué ce cours. La recommandation de l'enseignant est affichée jusqu'à ce qu'au moins 5 réponses d'apprenants soient collectées.
5
apprenants
--
À propos de ce cours
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
Projet de cours pratique
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
Notes attribuées au cours
Pourquoi s'inscrire à Skillshare ?
Suivez des cours Skillshare Original primés
Chaque cours comprend de courtes leçons et des travaux pratiques
Votre abonnement soutient les enseignants Skillshare
Apprenez, où que vous soyez
Suivez des cours où que vous soyez avec l'application Skillshare. Suivez-les en streaming ou téléchargez-les pour les regarder dans l'avion, dans le métro ou tout autre endroit où vous aimez apprendre.
