Excel: Top 50 Microsoft Excel Formulas!
Bash (BizTech Matters), Online Teaching Excel Expert
Assista a este curso e milhares de outros
Assista a este curso e milhares de outros
Aulas neste curso
-
-
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
-
-
- --
- 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.
2
Estudantes
--
Sobre este curso
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
Conheça seu professor
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... Visualizar o perfil completo
Projeto prático de curso
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.
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
