Excel Formula Blueprint
40+ Excel Formulas From Beginner To Advanced - Learn With Short & Step-By-Step Lectures And Over 15 Spreadsheets
4.72 (45 reviews)
1,591
students
2.5 hours
content
May 2016
last update
$19.99
regular price
What you will 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
Screenshots
Related Topics
786174
udemy ID
3/8/2016
course created date
2/8/2020
course indexed date
Bot
course submited by