Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 31 Minute(s)
Language
English
Taught by
Dragos Stefanescu, Richard Korbut
Rating
Course Overview
40+ Excel Formulas From Beginner To Advanced - Learn With Short & Step-By-Step Lectures And Over 15 Spreadsheets
- 13,000+ Students have enrolled in my 13 Courses!
- The 4.9 Rating from student reviews shows the value packed in this course!
- Practicality: This course has 15 Downloadable Spreadsheets spread across including Section Scenarios, Class Test Scenarios & Solutions
What if you mastered Excel formulas to the point where you could create Investment Banking quality spreadsheets that are efficient, automated and easy to
maintain?
Here's the blunt truth: I can't give you a magic pill to learn Excel over night. What
I can do is show you the fastest way to master formulas if you are willing to
take action.
Instead of cramming useless Excel theory during 8 boring and confusing hours, why not apply the formulas that you will use on a daily basis whilst also having the
spreadsheets in front of you?
This course will allow you to hack over 40 Excel Formulas including:
- The Formula Bootcamp: Excel beginners will learn the fundamental formulas and IF clauses to have a firm grip over Excel
- Excel Text Manipulator: Know exactly how to manipulate any Excel text string
- Excel Pro Formulas: Master the more complex excel functionalities which will completely transform your efficiency in Excel
As a bonus you will also receive class tests at the end of every section (including
the solutions in both text and spreadsheet format), a PDF with the most widely
used Excel keyboard shortcuts and an entire section comprising complementary formulas.
I guarantee this course will be the easiest way for you to master Excel formulas.
If you have taken action and not seen results, I will personally pay to enroll
you in another Excel course.
The path has been laid out for you to become an Excel Formula Ninja. Take this course now and join me on this exciting journey.
Course Content
- 7 section(s)
- 45 lecture(s)
- Section 1 Introduction To This Course
- Section 2 Introduction To Formulas - Syntax Basics
- Section 3 Beginners' Guide to Excel Formulas
- Section 4 IF Functions & Variations
- Section 5 Excel Text String Manipulator
- Section 6 The Ultimate Guide To LOOKUP Formulas
- Section 7 Advanced Excel Formulas
What You’ll Learn
- Master Every Excel-Formula Related Aspect Even If They're A Complete Beginner At Excel
- Learn By Focusing On The End-Result Of Formulas And Understand That These Lectures Represent The 20% Of Excel They'll Use 80% Of The Time
- Learn By Doing & Following Along - The Spreadsheets That Are Shown In Each Lecture Are Available For Download At The Beginning Of Each Section
- Test Your Excel Knowledge - Specific Class Test Scenarios Are Present At The End Of Each Section Along With The Solutions (Both In Video And XLS Formats)
- Master The Formula Syntax And Understand Basic Formulas
- Learn How To Copy & Paste Formulas, Use Auto-Fill Or How To Apply Absolute & Relative Referencing
- Discover Basic Formatting Principles And Use Simple Formulas Such As SUM, AVERAGE, COUNT, MIN, MAX And Their Variations
- Make Use Of IF Statements, Understand The AND, OR & NOT Operators And Combine Them Into SUMIF, COUNTIF Or AVERAGEIF
- Tidily Write Formulas And Apply This Method When Writing Nested IFs
- Manipulate Excel Text Strings - Ensure Proper Formatting, Stick Them Together, Extract Specific Text Strings Or Ensure Text Accuracy
- Master VLookups & HLookups Whilst Being Aware Of The Most Common Mistakes That You Can Make Whilst Using Them
- Approach Nested Lookups, Multi-Conditional Lookups And The MATCH Function
- Take Advantage Of Excel Advanced Features Such As Narrowing Down Variables By 2 Positions Using Formula Combos
- Check Against 2 Criteria For Unique Values
Reviews
-
AAmanda Rupert
I am in the middle of the course and find I am learning a great deal about constructing complicated formulas to achieve results.
-
PPawan Kumar Sharma
The course was a great learning exposure and tool to enhance skill set on excel, Appreciate the method and manner of the tutor:)
-
SShoyeb Ahmed
Took this course to finish off my improving of rudimentary Excel skills and get an adequate grasp on nested formulas. This course contains a good lecture on how to put AND and OR inside an IF statement to match three different conditions - I'll be visiting that one. Things get complicated and tricky after Section 4 – the nested statements chapter. The more formulas used inside a formula string, the more complicated it becomes, and the more lost you are and the harder to understand it gets. Just try to understand the individual formulas first well as that will be beneficial to you as you move ahead because the formula combinations may not make much sense when you’re trying to figure out the reason or logic of why they are used this way. Personally, for now, I just keep doing it the way it is shown and eventually I’ll remember how it was done and can make sense of it later. I don't know about you, and nothing against the instructors, but I am tired of Udemy lowering the prices just after I have bought them or while I am in the middle of it. Like this recent 92%-off Black Friday sale starting right after the final day they were offering 85%-off courses on, to always keep making you want to buy some. Every course I bought is now 92% cheaper.
-
SSmart Max
Amazing Amazing course with Full expert clear explanation , Really advice you all who is interesting to be excel (special Worker) in work area , to get this course and all coursed related this wonderful Teacher. Thanks a lot :)
