02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/017 Building Complex Text Strings With A Formula.mp4 76MB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/074 Multiple Logical Tests At Once Using AND.mp4 63MB
03 Project 2 - Building A Database With Excel/043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp.mp4 62MB
03 Project 2 - Building A Database With Excel/038 POWER USER - Dealing With Inconsistencies In User Entry.mp4 58MB
03 Project 2 - Building A Database With Excel/040 POWER USER - VLOOKUPs With Multiple Inputs.mp4 54MB
04 Section 3 Named Ranges/055 3035 - POWER USER - Dynamic Charts.mp4 49MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/019 Auto-Populating Check Boxes.mp4 48MB
03 Project 2 - Building A Database With Excel/047 Putting It All Together.mp4 48MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/018 A Tick Box Exercise Of Sorts.mp4 44MB
04 Section 3 Named Ranges/056 3040 - Horizontal Dynamic Named Ranges For Charts.mp4 43MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/010 Creating A Template From An Image.mp4 41MB
08 Student Questions Answered/081 What Is The CHOOSE Function Really Used For.mp4 41MB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/075 Conditional Formatting...Where The Magic Happens.mp4 39MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/016 Simple Logical Testing And Nested Logical Testing.mp4 39MB
08 Student Questions Answered/083 Dynamic Charting From A Drop Down.mp4 37MB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/076 Gantt Charts Using The Built In Charting Tools.mp4 36MB
08 Student Questions Answered/079 Calls Text Data 2 - This Time Using Text.mp4 34MB
03 Project 2 - Building A Database With Excel/024 Step1 Get Some Data In And Split It.mp4 34MB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/072 Creating A Gantt Chart Using A Worksheet.mp4 33MB
07 Bonus Section - Just For Fun/077 How I Created Randomly Generated License Plate Numbers.mp4 31MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/015 Calculating Time Out Of House Using Travel Time.mp4 29MB
03 Project 2 - Building A Database With Excel/030 Using OTHER Look-Ups To Look Up.mp4 28MB
03 Project 2 - Building A Database With Excel/026 Lets Build Our Database.mp4 28MB
05 Project 4 - What Can I Have For Dinner/065 Building Strings For Indirect Sheet And Cell References.mp4 28MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/007 More Useful Calculations With Time.mp4 28MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/012 Converting Time To A Decimal.mp4 28MB
03 Project 2 - Building A Database With Excel/045 The Fastest Way To Modify Your Column Numbers.mp4 27MB
03 Project 2 - Building A Database With Excel/041 POWER USER - Looking Up From Multiple Inputs Using An Array Formula.mp4 27MB
04 Section 3 Named Ranges/053 POWER USER - Dynamic Named Ranges.mp4 27MB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/073 Building The First Part Of Our Logical Test.mp4 26MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/014 Simple Conditional Formatting For A Cleaner View.mp4 25MB
03 Project 2 - Building A Database With Excel/048 The Finishing Touch How Many Records Did I Find.mp4 24MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/021 Defining A Working Area And Protecting Your Work.mp4 24MB
03 Project 2 - Building A Database With Excel/037 Backwards Look-Ups In Action.mp4 23MB
03 Project 2 - Building A Database With Excel/039 POWER USER - Fuzzy VLOOKUPs.mp4 22MB
08 Student Questions Answered/086 Vlookups With Pictures.mp4 20MB
05 Project 4 - What Can I Have For Dinner/059 Creating Our First Macro.mp4 20MB
03 Project 2 - Building A Database With Excel/036 POWER USER - The Other Way Of Looking Up Backwards.mp4 20MB
03 Project 2 - Building A Database With Excel/028 Importing Data From A Word File.mp4 20MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/002 Proof Of Concept.mp4 19MB
03 Project 2 - Building A Database With Excel/044 What To Look For When THAT Formula Didnt Work.mp4 19MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/008 Its About Time And Dates.mp4 19MB
03 Project 2 - Building A Database With Excel/032 Data Arrays Dont Have To Start At A1.mp4 19MB
05 Project 4 - What Can I Have For Dinner/068 POWER USER - The HYPERLINK Function And Problem.mp4 19MB
03 Project 2 - Building A Database With Excel/042 VLOOKUPs Brother...HLOOKUP.mp4 19MB
03 Project 2 - Building A Database With Excel/033 Some Common Reasons VLook-Ups Fail.mp4 18MB
03 Project 2 - Building A Database With Excel/025 Using Data Validation To Get The Right Input.mp4 18MB
03 Project 2 - Building A Database With Excel/035 POWER USER - A Breakdown Of Looking Up Backwards.mp4 17MB
04 Section 3 Named Ranges/052 POWER USER - A Magic Trick Using Row And Column Labels.mp4 17MB
08 Student Questions Answered/085 SUMIF With Dynamic Sum Range.mp4 17MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/013 A Little Bit Of Simple Data Entry.mp4 16MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/011 Importing A Template From An Existing Excel File.mp4 16MB
05 Project 4 - What Can I Have For Dinner/062 Using A Conditional Format To Know When A Value Is Missing.mp4 15MB
08 Student Questions Answered/078 Calls Text Data - Or How To Return a Column Title If Value is 1.mp4 15MB
01 Welcome To The Course/001 Welcome And Thank You For Choosing This Course.mp4 15MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/005 Custom Formatting Dates And Times.mp4 14MB
08 Student Questions Answered/082 Casing And Text Functions.mp4 14MB
04 Section 3 Named Ranges/054 POWER USER - What To Do With Dynamic Names Ranges With Titles.mp4 14MB
05 Project 4 - What Can I Have For Dinner/067 Working The Percentages And Adding Traffic Lights.mp4 14MB
05 Project 4 - What Can I Have For Dinner/060 Assigning A Macro To A Button.mp4 14MB
08 Student Questions Answered/084 Extracting a Unique List And Summing The Money.mp4 13MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/004 Creating Our Data Entry Screen.mp4 13MB
03 Project 2 - Building A Database With Excel/027 Importing Data From A Text File.mp4 13MB
04 Section 3 Named Ranges/049 A Simple Static Named Range Using A Single Cell.mp4 12MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/009 Adding With Time.mp4 12MB
05 Project 4 - What Can I Have For Dinner/058 Hyperlinking To A Different Sheet In The Same Workbook.mp4 12MB
03 Project 2 - Building A Database With Excel/023 Simple VLOOKUPs.mp4 12MB
03 Project 2 - Building A Database With Excel/029 Pulling Data From Multiple Sources.mp4 11MB
04 Section 3 Named Ranges/051 Using Row Labels To Name Multiple Ranges.mp4 11MB
05 Project 4 - What Can I Have For Dinner/063 Copying Conditional Formats And Creating Our Drop Downs.mp4 10MB
03 Project 2 - Building A Database With Excel/031 LOOKUP From A LOOKUP With No Intermediary Step.mp4 10MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/020 PRACTICE EXERCISE 1 - Time To Add A New Entry.mp4 10MB
04 Section 3 Named Ranges/050 Creating A Named Range Using A Range Of Cells.mp4 10MB
05 Project 4 - What Can I Have For Dinner/064 Building Our Formula...INDIRECT Function.mp4 9MB
05 Project 4 - What Can I Have For Dinner/066 Its A One Or A Zero.mp4 9MB
08 Student Questions Answered/080 Extracting Phone Numbers From A Cell.mp4 8MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/003 Planning Ahead.mp4 8MB
03 Project 2 - Building A Database With Excel/034 One Inherent Flaw In Vlook-Up.mp4 8MB
03 Project 2 - Building A Database With Excel/046 POWER USER - Vlook-Ups With Moving Columns.mp4 8MB
05 Project 4 - What Can I Have For Dinner/061 Creating A List For Our Dropdown Using A Dynamic Named Range.mp4 7MB
05 Project 4 - What Can I Have For Dinner/071 Exercise 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp4 7MB
05 Project 4 - What Can I Have For Dinner/070 Exercise 2 - Pretty It Up With A Macro.mp4 6MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/006 Simple Calculations With Time.mp4 6MB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/022 PRACTICE EXERCISE 2 - Set Up A Working Area And Limit User Entry.mp4 5MB
05 Project 4 - What Can I Have For Dinner/069 Exercise 1 - Fill In The Blanks.mp4 3MB
05 Project 4 - What Can I Have For Dinner/057 Welcome to What Can I Have For Dinner or...What Would I Use THAT for.mp4 3MB
08 Student Questions Answered/attached_files/086 Vlookups With Pictures/VLookUps-With-Pictures-After.xlsx 410KB
09 Thank You - Your Special Bonus/087 Get Your Next Course Now.pdf 302KB
09 Thank You - Your Special Bonus/attached_files/087 Get Your Next Course Now/Level-2-Get-Your-Next-Course.pdf 302KB
08 Student Questions Answered/attached_files/086 Vlookups With Pictures/VLookUps-With-Pictures-Before.xlsx 206KB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/002 Proof Of Concept/Time-Sheet-Expenses-Master.xlsx 153KB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/010 Creating A Template From An Image/Time-Sheet-Blank.jpg 123KB
03 Project 2 - Building A Database With Excel/attached_files/024 Step1 Get Some Data In And Split It/HR-Database-Master.xlsx 61KB
unnamed.jpg 54KB
05 Project 4 - What Can I Have For Dinner/attached_files/058 Hyperlinking To A Different Sheet In The Same Workbook/What-To-Have-For-Dinner.xlsx 42KB
06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/attached_files/072 Creating A Gantt Chart Using A Worksheet/Gantt-Charts.xlsx 31KB
03 Project 2 - Building A Database With Excel/attached_files/024 Step1 Get Some Data In And Split It/HR-File.xlsx 24KB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/011 Importing A Template From An Existing Excel File/Expenses-Form.xlsx 21KB
03 Project 2 - Building A Database With Excel/attached_files/040 POWER USER - VLOOKUPs With Multiple Inputs/Lookup-Up-From-Multiple-Inputs.xlsx 21KB
04 Section 3 Named Ranges/attached_files/056 3040 - Horizontal Dynamic Named Ranges For Charts/Horizontal-Dynamic-Named-Ranges.xlsx 19KB
04 Section 3 Named Ranges/attached_files/055 3035 - POWER USER - Dynamic Charts/Dynamic-Charts.xlsx 18KB
08 Student Questions Answered/attached_files/081 What Is The CHOOSE Function Really Used For/CHOOSE-Function.xlsx 17KB
08 Student Questions Answered/attached_files/083 Dynamic Charting From A Drop Down/5-Dynamic-Tables.xlsx 17KB
03 Project 2 - Building A Database With Excel/attached_files/028 Importing Data From A Word File/Addresses.docx 14KB
03 Project 2 - Building A Database With Excel/attached_files/043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp/Returning-Multiple-Results.xlsx 14KB
04 Section 3 Named Ranges/attached_files/049 A Simple Static Named Range Using A Single Cell/Static-Named-Ranges.xlsx 13KB
08 Student Questions Answered/attached_files/085 SUMIF With Dynamic Sum Range/SUMIF-With-Dynamic-Sum-Range-Column-Completed.xlsx 12KB
08 Student Questions Answered/attached_files/085 SUMIF With Dynamic Sum Range/SUMIF-With-Dynamic-Sum-Range-Column-Data-Set.xlsx 12KB
08 Student Questions Answered/attached_files/078 Calls Text Data - Or How To Return a Column Title If Value is 1/1.0-Calls-Text-Data.xlsx 11KB
04 Section 3 Named Ranges/attached_files/053 POWER USER - Dynamic Named Ranges/Dynamic-Named-Ranges.xlsx 11KB
03 Project 2 - Building A Database With Excel/attached_files/039 POWER USER - Fuzzy VLOOKUPs/Fuzzy-VLook-Ups.xlsx 11KB
03 Project 2 - Building A Database With Excel/attached_files/037 Backwards Look-Ups In Action/Looking-Up-Backwards.xlsx 10KB
02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/008 Its About Time And Dates/It-s-About-Time.xlsx 10KB
08 Student Questions Answered/attached_files/082 Casing And Text Functions/Casing.xlsx 10KB
03 Project 2 - Building A Database With Excel/attached_files/046 POWER USER - Vlook-Ups With Moving Columns/VLOOKUPS-With-Moving-Columns.xlsx 9KB
03 Project 2 - Building A Database With Excel/attached_files/023 Simple VLOOKUPs/Simple-VLOOKUPS.xlsx 9KB
08 Student Questions Answered/attached_files/080 Extracting Phone Numbers From A Cell/3.0-Extracting-Phone-Numbers-From-A-Cell.xlsx 9KB
03 Project 2 - Building A Database With Excel/attached_files/027 Importing Data From A Text File/Department-Structure.txt 8KB