Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 10 Minute(s)
Language
English
Taught by
BrainyMoney and Son Han, CFA, CPA
Rating
Course Overview
Get better and more efficient at work!
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...
Course Content
- 5 section(s)
- 17 lecture(s)
- Section 1 Introduction
- Section 2 Overview and Getting Acquainted
- Section 3 The Most Common Formulas
- Section 4 Common Useful Excel Functionality
- Section 5 Conclusion
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
Skills covered in this course
Reviews
-
FFrenchie D
Awesome class!!! I enjoyed that you focused on exactly what we needed and not too long on each subject. The speed kept me engaged and I appreciated having the workbook to actually do the steps. Looking forward to additional training.
-
SSarah Summerscales
Clear instruction but I did have to rewind a few times because it moved on quicker than I could at times
-
SSarah Garrison
He needs to slow just down a bit when hes typing and showing us whats hes doing. I keep needing to pause it to see exactly what hes doing. Otherwise, it was great course. Very valuable.
-
SSelin Bora
I really enjoyed the course. The instructor pointed out important and time saving formulas. From now on I'll do my excel work more easily, many many thanks! + the instructor is not speaking so fast, his accent is very clear :)
