Excel: Top 50 Microsoft Excel Formulas!
Bash (BizTech Matters), Online Teaching Excel Expert
Ve esta clase y miles más
Ve esta clase y miles más
Lecciones en esta clase
-
-
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
-
-
- --
- 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.
2
Estudiantes
--
Proyectos
Acerca de esta clase
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
Conoce a tu profesor(a)
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... Ver perfil completo
Proyecto de clase práctica
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.
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.
Clases relacionadas
