#### 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