Most Common Excel Formulas - Excel at Your Job
Get better and more efficient at work!
Created by BrainyMoney and Son Han, CFA, CPA
30-Day Money-Back Guarantee
What you'll 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 this course is for:
- 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
Course content
5 sections • 17 lectures • 1h 10m total length
- Preview01:53
Instructor
Personal Finance Made Easy!
![BrainyMoney and Son Han, CFA, CPA](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 6,215 Reviews
- 61,471 Students
- 9 Courses
Personal Finance is easy. It takes 2 hours to learn. The hard part is staying motivated. We build the best personal finance courses,cause no unnecessary harm, use business to inspire and implement solutions to improve financial lives of our peers. Follow us on Instagram to find daily motivational videos. Instagram: @Brainy.Money