2015
Udemy
Mr. Deep Dave
2:00
English

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.

Section 1: Basics Of Excel
1 Course Introduction
2 Parts Of an Excel Workbook, Functions Library & Functions Vs Formulas
3 Absolute, Relative & Mixed References
Section 2: Logical Functions & Error Handling
4 Boolean Logic & Basic Logical Functions
5 Error Handling
Section 3: Text Functions
6 Types Of Cell References
7 Text Functions
Section 4: Lookup Functions
8 Lookup Functions
Section 5: Math and Stats Functions
9 Math and Stats Functions
Section 6: Date & Information Functions
10 Date Functions
11 Information Functions
Section 7: Important Things To Know
12 Important Things To Know
13 Find Vs Search
Section 8: Building Formulas
14 Separate 1st & Last Names
15 Vlookup with Dynamic Column Header
16 Index & Match
17 Indirect & Vlookup
18 SumIfs with 4 Criteria & Vlookup with Approximate Match
19 Search & Iserror
20 Find Last Occurrence Of Minimum Value Using Lookup
21 Match & Index with 0 for Col_Num Argument
22 Count Unique Names
23 Sumproduct With Multiple Criteria
24 Value Of Boolean Expressions
Section 9: Array (CSE) Formulas
25 Max Sales Figures Based On Criteria
Section 10: Conclusion
26 Conclusion

http://www.udemy.com/

Download File Size:281.95 MB

---