Don't like banners? Log in and we will make sure you see no banners. For free.
Don't like banners? Log in and we will make sure you see no banners. For free.
File list
Microsoft Excel Essentials Level 2 - Intermediate Advanced
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/01 Welcome To The Course/001 Welcome And Thank You For Choosing This Course.mp414.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/01 Welcome To The Course/Must Read.txt540 B
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/002 Proof Of Concept.mp419.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/003 Planning Ahead.mp47.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/004 Creating Our Data Entry Screen.mp413 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/005 Custom Formatting Dates And Times.mp414.4 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/006 Simple Calculations With Time.mp46.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/007 More Useful Calculations With Time.mp427.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/008 Its About Time And Dates.mp419.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/009 Adding With Time.mp412.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/010 Creating A Template From An Image.mp441.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/011 Importing A Template From An Existing Excel File.mp415.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/012 Converting Time To A Decimal.mp427.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/013 A Little Bit Of Simple Data Entry.mp416 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/014 Simple Conditional Formatting For A Cleaner View.mp425.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/015 Calculating Time Out Of House Using Travel Time.mp429.4 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/016 Simple Logical Testing And Nested Logical Testing.mp439 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/017 Building Complex Text Strings With A Formula.mp475.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/018 A Tick Box Exercise Of Sorts.mp444 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/019 Auto-Populating Check Boxes.mp448.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/020 PRACTICE EXERCISE 1 - Time To Add A New Entry.mp49.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/021 Defining A Working Area And Protecting Your Work.mp423.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/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.mp45.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/002 Proof Of Concept/Time-Sheet-Expenses-Master.xlsx152.8 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/008 Its About Time And Dates/It-s-About-Time.xlsx10.3 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/attached_files/010 Creating A Template From An Image/Time-Sheet-Blank.jpg122.7 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/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.xlsx20.7 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/023 Simple VLOOKUPs.mp411.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/024 Step1 Get Some Data In And Split It.mp434 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/025 Using Data Validation To Get The Right Input.mp417.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/026 Lets Build Our Database.mp428.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/027 Importing Data From A Text File.mp412.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/028 Importing Data From A Word File.mp419.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/029 Pulling Data From Multiple Sources.mp411.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/030 Using OTHER Look-Ups To Look Up.mp428.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/031 LOOKUP From A LOOKUP With No Intermediary Step.mp410 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/032 Data Arrays Dont Have To Start At A1.mp418.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/033 Some Common Reasons VLook-Ups Fail.mp418.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/034 One Inherent Flaw In Vlook-Up.mp47.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/035 POWER USER - A Breakdown Of Looking Up Backwards.mp417.4 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/036 POWER USER - The Other Way Of Looking Up Backwards.mp419.7 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/037 Backwards Look-Ups In Action.mp422.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/038 POWER USER - Dealing With Inconsistencies In User Entry.mp458.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/039 POWER USER - Fuzzy VLOOKUPs.mp421.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/040 POWER USER - VLOOKUPs With Multiple Inputs.mp453.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/041 POWER USER - Looking Up From Multiple Inputs Using An Array Formula.mp427.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/042 VLOOKUPs Brother...HLOOKUP.mp418.7 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/043 POWER USER - The Holy Grail - How To Return Multiple Values From A Single LookUp.mp462.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/044 What To Look For When THAT Formula Didnt Work.mp419.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/045 The Fastest Way To Modify Your Column Numbers.mp427.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/046 POWER USER - Vlook-Ups With Moving Columns.mp47.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/047 Putting It All Together.mp447.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/048 The Finishing Touch How Many Records Did I Find.mp424.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/023 Simple VLOOKUPs/Simple-VLOOKUPS.xlsx9.3 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/024 Step1 Get Some Data In And Split It/HR-Database-Master.xlsx61.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/024 Step1 Get Some Data In And Split It/HR-File.xlsx24.3 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/027 Importing Data From A Text File/Department-Structure.txt7.8 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/028 Importing Data From A Word File/Addresses.docx14.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/037 Backwards Look-Ups In Action/Looking-Up-Backwards.xlsx10.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/039 POWER USER - Fuzzy VLOOKUPs/Fuzzy-VLook-Ups.xlsx10.5 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/040 POWER USER - VLOOKUPs With Multiple Inputs/Lookup-Up-From-Multiple-Inputs.xlsx20.6 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/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.xlsx14 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/046 POWER USER - Vlook-Ups With Moving Columns/VLOOKUPS-With-Moving-Columns.xlsx9.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/049 A Simple Static Named Range Using A Single Cell.mp412.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/050 Creating A Named Range Using A Range Of Cells.mp49.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/051 Using Row Labels To Name Multiple Ranges.mp410.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/052 POWER USER - A Magic Trick Using Row And Column Labels.mp417.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/053 POWER USER - Dynamic Named Ranges.mp426.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/054 POWER USER - What To Do With Dynamic Names Ranges With Titles.mp414.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/055 3035 - POWER USER - Dynamic Charts.mp448.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/056 3040 - Horizontal Dynamic Named Ranges For Charts.mp442.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/attached_files/049 A Simple Static Named Range Using A Single Cell/Static-Named-Ranges.xlsx12.8 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/attached_files/053 POWER USER - Dynamic Named Ranges/Dynamic-Named-Ranges.xlsx11 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/attached_files/055 3035 - POWER USER - Dynamic Charts/Dynamic-Charts.xlsx18.2 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/attached_files/056 3040 - Horizontal Dynamic Named Ranges For Charts/Horizontal-Dynamic-Named-Ranges.xlsx19.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/ReadMe.txt538 B
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/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.mp42.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/058 Hyperlinking To A Different Sheet In The Same Workbook.mp411.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/059 Creating Our First Macro.mp419.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/060 Assigning A Macro To A Button.mp414 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/061 Creating A List For Our Dropdown Using A Dynamic Named Range.mp47.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/062 Using A Conditional Format To Know When A Value Is Missing.mp415.4 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/063 Copying Conditional Formats And Creating Our Drop Downs.mp410.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/064 Building Our Formula...INDIRECT Function.mp49 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/065 Building Strings For Indirect Sheet And Cell References.mp428 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/066 Its A One Or A Zero.mp48.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/067 Working The Percentages And Adding Traffic Lights.mp414 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/068 POWER USER - The HYPERLINK Function And Problem.mp418.7 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/069 Exercise 1 - Fill In The Blanks.mp43.4 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/070 Exercise 2 - Pretty It Up With A Macro.mp46.4 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/071 Exercise 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp47.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/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.xlsx41.6 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/06 Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans/072 Creating A Gantt Chart Using A Worksheet.mp433.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/ReadMe.txt538 B