Course Description
A step-by-step video series that will help you get familiar with
basics to intermediate concepts of Formula Building. Highly
sophisticated Formulas can be built using Excel to get results most
users might not even imagine. This course aims at helping students
develop that logical thinking that would guide them in the right
direction when it comes to Excel Formulas
The course
starts with clarifying basics along with some Do's & Dont's while
using Excel. It also spends some quality time to make students
understands the power of Excel functions by themselves. It then moves
ahead to teach how these functions can be used together to build
Powerful Excel Formulas to derive some pretty complicated results.
I also touch base upon Array formulas, which is a pretty advanced concept.
In this course you will learn -
1) Usage of Excel functions
2) Basics of Building Formulas
3) Using functions to build complex Excel formulas
4) Array Formula Basics
5) Some helpful examples for hands on training along with other important Tips & tricks
The
course contains easy to understand video lessons & other reading
material and should take approximately 2 hours to finish. Easy to follow
along with the help of exercise files that are provided with lessons
wherever required for practice.
Those who have been using Excel
and are looking learn some advanced stuff, this course will provide a
good foundation to build upon.
Curriculum
Absolute, Relative & Mixed References
Boolean Logic & Basic Logical Functions
Conclusion
Count Unique Names
Course Introduction
Date Functions
Error Handling
Find Last Occurrence Of Minimum Value Using Lookup
Find Vs Search
Important Things To Know
Index & Match
Indirect & Vlookup
Information Functions
Lookup Functions
Match & Index with 0 for Col_Num Argument
Math and Stats Functions
Max Sales Figures Based On Criteria
Parts Of an Excel Workbook, Functions Library & Functions Vs Formulas
Search & Iserror
Section 1: Basics Of Excel
Section 10: Conclusion
Section 2: Logical Functions & Error Handling
Section 3: Text Functions
Section 4: Lookup Functions
Section 5: Math and Stats Functions
Section 6: Date & Information Functions
Section 7: Important Things To Know
Section 8: Building Formulas
Section 9: Array (CSE) Formulas
Separate 1st & Last Names
SumIfs with 4 Criteria & Vlookup with Approximate Match
Sumproduct With Multiple Criteria
Text Functions
Types Of Cell References
Value Of Boolean Expressions
Vlookup with Dynamic Column Header
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
