Excel: Top 50 Microsoft Excel Formulas!
Bash (BizTech Matters), Online Teaching Excel Expert
Regardez ce cours et des milliers d'autres
Regardez ce cours et des milliers d'autres
Leçons de ce cours
-
-
1.
Intro
0:31
-
2.
Getting the most of the course
0:57
-
3.
Text
7:53
-
4.
Text Exercise
0:21
-
5.
Text Exercise (answers)
1:08
-
6.
Mathematical
4:01
-
7.
Math Exercise (answers)
1:00
-
8.
Math Exercise
0:16
-
9.
Date and Time
5:04
-
10.
Date and Time Exercise
0:17
-
11.
Date and Time Exercise (answers)
0:59
-
12.
Logic
12:20
-
13.
Logic Exercise
0:15
-
14.
Logic Exercise (answers)
0:41
-
15.
Financial
5:54
-
16.
Financial Exercise
0:13
-
17.
Financial Exercise (answers)
2:15
-
18.
Informational
3:58
-
19.
Informational Exercise
0:40
-
20.
Informational Exercise (answers)
1:26
-
21.
Thank you
0:51
-
-
- --
- 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.
2
apprenants
--
À propos de ce cours
Last time you opened a spreadsheet and are overwhelmed by the formulas and functions being used. You don't know how to make the most out of them, or change them into what you need.
But it doesn't have to be this way!
You Will Walk Away With...
- MORE TIME!
- Learn the top 50 Excel formulas!
- Understand the essence of these formulas, without memorizing them!
- See how each of these formulas is used with real examples!
After this class you will be able to:
- Actually SMILE when you open a spreadsheet :-)
- Brag to your friends about how you can use Excel formulas and Excel functions confidently!
If you're like me, you use Microsoft Excel on a daily basis for important tasks, text processing, or calculations. Whether it's for business or personal related projects, everyone wants to be able to use these formulas freely and easily.
If you're ready to gain full control of Excel Formulas TODAY, take this course right now and learn the following formulas:
- Text Formulas:
- Concatenate
- Find
- Left
- Len
- Lower
- Mid
- Proper
- Rept
- Substitute
- Trim
- Upper
- Value
- Mathematical Formulas:
- Average
- Int
- Mod
- Rand
- Round
- Sum
- Date and Time Formulas:
- Day
- Hour
- Minute
- Month
- Networkdays
- Now
- Second
- Today
- Weekday
- Year
- Logic Formulas:
- And
- Countblank
- Countif
- If
- Large
- Max
- Min
- Not
- Or
- Small
- Sumif
- Vlookup
- Financial Formulas:
- Fv
- Npv
- Pmt
- Ppmt
- Informational Formulas:
- Column
- Isblank
- Iserror
- Isnumber
- Istext
- Row
Rencontrez votre enseignant·e
Hi! I'm Bash and over here at BizTech Matters, I love sharing what I know through online classes, with my over 10 years of IT and teaching experience. Whether it's creating websites, programs, spreadsheets, editing photos, or anything computer-related, I ensure that I will give you the tools to succeed.
My goal is to show you the essence behind on whatever I'm teaching you. Hop in for a fun ride into learning in the technology world!
Join me in learning the following this growing list of skills:
- Mastering Top Microsoft Excel Formulas
- Mastering SQL Queries
- Create your own Power BI Dashboard!
- Use Excel Power Query to Clean your Dirty Data
- Use the Top 50 Excel Keyboard Short... Voir le profil complet
Projet de cours pratique
Applied Microsoft Excel Formulas and Functions in Real Life
Our project for this course is simple, just share an example on how you applied the excel formulas to your everyday work, or studies.
- It could be something that helped you achieve a solution efficiently,
- it could also be something that became a timesaver for you and your peers.
- It could also be just a fun scenario wherein you just wanted to play around with formulas
If you are unsure on how to present, just focus on one formula that has helped you saved time! Be it CONCATENATE, VLOOKUP, or anything that you have used.
Here is an example:
Starbucks Menu Automatic Vlookup
I've just created a Vlookup application! I've used a starbucks menu and was able to search automatically for drinks that I want, based on the drink/size combination.
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.
