
Genre: eLearning | Language: English + .VTT | Duration: 1 hours | Size: 795 MB
What Will I Learn?
Students will know all intermediate level Excel formulas and functions
Students will be significantly faster at their jobs when using Excel
Requirements
Basic Excel Knowledge - you know how to write a basic Excel formula such as Sum or multiplying two cells
Description
We will cover the following most common Excel formulas for intermediate users:
Vlookup
If Statements
SumIF
AverageIF
CountIF
TRIM
Concatenate
Left, Right, Mid
Data Validation
Removing Duplicates
Conditional Formatting
Data Filters
We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells). This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc...
Who is the target audience?
Anyone who is slow at their job and if they knew how to use Excel could become exponentially more efficient
Anyone who wants to learn the most common formulas that provide an incredibly strong foundation
Top Rated News
- Sean Archer
- AwTeaches
- Learn Squared
- PhotoWhoa
- Houdini-Course
- Photigy
- August Dering Photography
- StudioGuti
- Creatoom
- Creature Art Teacher
- Creator Foundry
- Patreon Collections
- Udemy - Turkce
- BigFilms
- Jerry Ghionis
- ACIDBITE
- BigMediumSmall
- Boom Library
- Globe Plants
- Unleashed Education
- The School of Photography
- Visual Education
- LeartesStudios - Cosmos
- All Veer Fancy Collection!
- All OJO Images
- All ZZVe Vectors