Microsoft Excel Essentials Level 2 - IntermediateAdvanced/01 Welcome To The Course/001 Welcome And Thank You For Choosing This Course.mp4
14.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/01 Welcome To The Course/Must Read.txt
540 B
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/002 Proof Of Concept.mp4
19.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/003 Planning Ahead.mp4
7.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.mp4
13 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.mp4
14.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.mp4
6.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.mp4
27.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.mp4
19.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/009 Adding With Time.mp4
12.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.mp4
41.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.mp4
15.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.mp4
27.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.mp4
16 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.mp4
25.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.mp4
29.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.mp4
39 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.mp4
75.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.mp4
44 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/02 Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/019 Auto-Populating Check Boxes.mp4
48.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.mp4
9.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.mp4
23.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.mp4
5.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.xlsx
152.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.xlsx
10.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.jpg
122.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.xlsx
20.7 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/023 Simple VLOOKUPs.mp4
11.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.mp4
34 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/025 Using Data Validation To Get The Right Input.mp4
17.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/026 Lets Build Our Database.mp4
28.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/027 Importing Data From A Text File.mp4
12.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/028 Importing Data From A Word File.mp4
19.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/029 Pulling Data From Multiple Sources.mp4
11.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/030 Using OTHER Look-Ups To Look Up.mp4
28.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.mp4
10 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/032 Data Arrays Dont Have To Start At A1.mp4
18.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/033 Some Common Reasons VLook-Ups Fail.mp4
18.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/034 One Inherent Flaw In Vlook-Up.mp4
7.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.mp4
17.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.mp4
19.7 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/037 Backwards Look-Ups In Action.mp4
22.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.mp4
58.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/039 POWER USER - Fuzzy VLOOKUPs.mp4
21.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/040 POWER USER - VLOOKUPs With Multiple Inputs.mp4
53.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.mp4
27.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/042 VLOOKUPs Brother...HLOOKUP.mp4
18.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.mp4
62.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.mp4
19.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.mp4
27.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/046 POWER USER - Vlook-Ups With Moving Columns.mp4
7.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/047 Putting It All Together.mp4
47.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.mp4
24.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/03 Project 2 - Building A Database With Excel/attached_files/023 Simple VLOOKUPs/Simple-VLOOKUPS.xlsx
9.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.xlsx
61.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.xlsx
24.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.txt
7.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.docx
14.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.xlsx
10.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.xlsx
10.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.xlsx
20.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.xlsx
14 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.xlsx
9.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/049 A Simple Static Named Range Using A Single Cell.mp4
12.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/050 Creating A Named Range Using A Range Of Cells.mp4
9.5 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/051 Using Row Labels To Name Multiple Ranges.mp4
10.8 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/052 POWER USER - A Magic Trick Using Row And Column Labels.mp4
17.3 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/053 POWER USER - Dynamic Named Ranges.mp4
26.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.mp4
14.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/055 3035 - POWER USER - Dynamic Charts.mp4
48.6 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/056 3040 - Horizontal Dynamic Named Ranges For Charts.mp4
42.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.xlsx
12.8 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/attached_files/053 POWER USER - Dynamic Named Ranges/Dynamic-Named-Ranges.xlsx
11 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/attached_files/055 3035 - POWER USER - Dynamic Charts/Dynamic-Charts.xlsx
18.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.xlsx
19.4 KB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/04 Section 3 Named Ranges/ReadMe.txt
538 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.mp4
2.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.mp4
11.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/059 Creating Our First Macro.mp4
19.9 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/060 Assigning A Macro To A Button.mp4
14 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.mp4
7.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.mp4
15.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.mp4
10.2 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/064 Building Our Formula...INDIRECT Function.mp4
9 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.mp4
28 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/066 Its A One Or A Zero.mp4
8.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.mp4
14 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/068 POWER USER - The HYPERLINK Function And Problem.mp4
18.7 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/05 Project 4 - What Can I Have For Dinner/069 Exercise 1 - Fill In The Blanks.mp4
3.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.mp4
6.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.mp4
7.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.xlsx
41.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.mp4
33.1 MB
Microsoft Excel Essentials Level 2 - IntermediateAdvanced/ReadMe.txt