Section 1 : Welcome

lecture 1 Important - Excel - Working Files - Download These Pdf
lecture 2 0101 How Advanced Is Advanced 3:24
lecture 3 Using The Working Files 2:0
lecture 4 0103 When Is A Formula A Function

Section 2 : Getting The Basics Right

lecture 5 Initial Setup Of The Sample Databases Provided 2:45
lecture 6 0202 Accessing Unknown Function Syntax Within Exce 7:58
lecture 7 0203 Referencing Entire Rows-Columns
lecture 8 0204 Excel - Function Processing Order 7:48

Section 3 : Extend Your Formula Usage

lecture 10 0301 Naming Cells To Improve Formula Appearance 6:49
lecture 11 0302 Excel - 3D Referencing 8:58
lecture 12 0303 Full Absolute Referencing 4:37
lecture 13 0304 Making Only Part Absolute Formula 6:23

Section 4 : If And If Type Functions

lecture 14 0401 The If Logical Test 8:15
lecture 15 0402 Nested If Statements 3:57
lecture 16 0403 Using The And, Or, And Not Functions Within I 6:58
lecture 17 0404 CountIf, SumIf, And AverageIf 10:11
lecture 18 0405 Multiple Criteria With CountIfs, SumIfs, And

Section 5 : Lookup And Reference Type Functions

lecture 19 0501 Looking Up Information With VLookup 9:10
lecture 20 0502 Excel - HLookup 4:12
lecture 21 0503 Nearest Match With VLookup 6:30
lecture 22 0504 Nested Lookup Functions 4:30
lecture 23 0505 Choose And Match Functions For Locating Data 5:11
lecture 24 0506 Index And Match Functions For Retrieving Data 8:38

Section 6 : Mathematical Functions

lecture 25 0601 Varying Rounding Functions 7:39
lecture 26 0602 MRound, Ceiling, And Floor For Rounding Also 5:19
lecture 27 0603 Int And Mod For Integer And Remainder Values 4:21
lecture 28 0604 Generating Random Numbers And Values In Excel 5:14
lecture 29 0605 Password Generating Workbooks 6:2
lecture 30 0606 Display Different Number Types With Roman And 5:17

Section 7 : Statistics

lecture 31 0701 The Middle Value With Median 5:7
lecture 32 0702 Ranking Data Without Sorting 4:58
lecture 33 0703 Large And Small For Retrieving Biggest And Sm 4:39
lecture 34 0704 A Choice Of Count Functions 5:39

Section 8 : Text Functions

lecture 35 0801 Extracting Data With Left, Right And Mid 5:46
lecture 36 0802 Locating Data With Find, Search, Exact 7:19
lecture 37 0803 Use Trim And Clean To Remove Unwanted Gaps 5:49
lecture 38 0804 Combine Data From Different Cells
lecture 39 0805 Changing The Case Of Text Using Proper, Upper 3:17
lecture 40 0806 Replace And Substitute In Action 4:55
lecture 41 0807 Format Number Content Within Strings With Te 5:53

Section 9 : Date And Time Functions

lecture 42 0901 Using Today And Now Functions 3:34
lecture 43 0902 How Does Excel Deal With Dates And Time 5:53
lecture 44 0903 What Day Of The Week Is It 4:14
lecture 45 0904 Difference Between Network Days And Work Day 6:59
lecture 46 0905 DatedIf For Time Differences 7:12
lecture 47 0906 EDate And EOMonth 4:57
lecture 48 0907 DateValue And TimeValue Functions 7:43

Section 10 : Information And Referencing Functions

lecture 49 1001 Extracting Information With Cell And Info Fun 8:13
lecture 50 1002 Using IsBlank, IsOdd, IsEven, IsText, And IsN
lecture 51 1003 IsErr, IsError, IfError, IsNA, And IfNA For E 8:26
lecture 52 1004 The New IsFormula Function And FormulaText 3:42
lecture 53 1005 Use Offset To Obtain Data From Related Cells 8:42
lecture 54 1006 InDirect And Its Uses 7:13

Section 11 : Array Formulas And Functions

lecture 55 1101 What Is An Array Formula 8:27
lecture 56 1102 Use An Array Formula To Count Unique Entries 5:19
lecture 57 1103 Flipping Rows Or Columns With Transpose 3:57