FreeCourseLab com Udemy Excel Essentials The Complete Excel Series Level

FreeCourseLab com Udemy Excel Essentials The Complete Excel Series Level

Name	[FreeCourseLab.com] Udemy - Excel Essentials The Complete Excel Series - Level 1, 2 & 3	DOWNLOAD Copy Link
Total Size	5.6 GB
Total Files	782
Last Seen	2025-02-19 23:27
Hash	AFAA67C9276C8154EA874708FCEF20DC45FF9755

/1. Excel Essentials Level 1 Basics - Master Excel Step-By-Step/
1. Intro To Level 1.mp4	12.9 MB
1. Intro To Level 1.vtt	3.4 KB
2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.mp4	10.0 MB
2. Before We Start...Viewing The Lectures, And Following Along On A Single Screen.vtt	4.5 KB
/10. Bonus Section Student Questions Answered!/
1. Reverse Engineering A Sample Spreadsheet.mp4	56.5 MB
1. Reverse Engineering A Sample Spreadsheet.vtt	23.5 KB
2. Casing And Text Functions.mp4	45.6 MB
2. Casing And Text Functions.vtt	8.1 KB
2.1 Casing.xlsx.xlsx	9.8 KB
/11. Excel Essentials Level 2 - IntermediateAdvanced/
1. Intro To Level 2.mp4	9.4 MB
1. Intro To Level 2.vtt	2.5 KB
/12. Project 1 - Creating A Data Entry Screen To Populate Multiple Templates/
1. Proof Of Concept.mp4	17.1 MB
1. Proof Of Concept.vtt	6.2 KB
1.1 Time Sheet & Expenses Master.xlsx.xlsx	156.4 KB
10. Importing A Template From An Existing Excel File.mp4	13.8 MB
10. Importing A Template From An Existing Excel File.vtt	2.9 KB
10.1 Expenses Form.xlsx.xlsx	21.2 KB
11. Converting Time To A Decimal.mp4	16.9 MB
11. Converting Time To A Decimal.vtt	7.0 KB
12. A Little Bit Of Simple Data Entry.mp4	9.6 MB
12. A Little Bit Of Simple Data Entry.vtt	3.8 KB
13. Simple Conditional Formatting For A Cleaner View.mp4	16.5 MB
13. Simple Conditional Formatting For A Cleaner View.vtt	5.7 KB
14. Calculating Time Out Of House Using Travel Time.mp4	17.5 MB
14. Calculating Time Out Of House Using Travel Time.vtt	5.4 KB
15. Simple Logical Testing And Nested Logical Testing.mp4	23.7 MB
15. Simple Logical Testing And Nested Logical Testing.vtt	10.2 KB
16. Building Text Strings With A Formula.mp4	45.6 MB
16. Building Text Strings With A Formula.vtt	14.4 KB
17. Before We Move On...Accessing The Developer Ribbon.mp4	5.0 MB
17. Before We Move On...Accessing The Developer Ribbon.vtt	1.1 KB
18. A Tick Box Exercise (Of Sorts).mp4	29.6 MB
18. A Tick Box Exercise (Of Sorts).vtt	9.7 KB
19. Auto-populating Check Boxes.mp4	35.8 MB
19. Auto-populating Check Boxes.vtt	14.6 KB
2. Planning Ahead.mp4	5.0 MB
2. Planning Ahead.vtt	3.0 KB
20. PRACTICE EXERCISE 1 - Time To Add A New Entry.mp4	6.6 MB
20. PRACTICE EXERCISE 1 - Time To Add A New Entry.vtt	2.0 KB
21. Defining A Working Area, And Protecting Your Work.mp4	16.9 MB
21. Defining A Working Area, And Protecting Your Work.vtt	6.2 KB
22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.mp4	4.0 MB
22. PRACTICE EXERCISE 2 - Set Up A Working Area, And Limit User Entry.vtt	1.5 KB
3. Creating Our Data Entry Screen.mp4	9.9 MB
3. Creating Our Data Entry Screen.vtt	4.8 KB
4. (Custom) Formatting Dates And Time.mp4	13.7 MB
4. (Custom) Formatting Dates And Time.vtt	7.2 KB
5. Simple Calculations With Time.mp4	5.3 MB
5. Simple Calculations With Time.vtt	3.4 KB
6. More (Useful) Calculations With Time.mp4	20.4 MB
6. More (Useful) Calculations With Time.vtt	10.2 KB
7. It's About Time (And Dates!).mp4	17.2 MB
7. It's About Time (And Dates!).vtt	9.2 KB
7.1 It's About Time.xlsx.xlsx	10.6 KB
8. Adding Time.mp4	9.3 MB
8. Adding Time.vtt	4.1 KB
9. Creating A Template From An Image.mp4	36.4 MB
9. Creating A Template From An Image.vtt	14.7 KB
9.1 Time Sheet Blank.jpg.jpg	125.6 KB
/13. Project 2 - Building A Database With Excel/
1. Simple VLOOKUPs.mp4	9.0 MB
1. Simple VLOOKUPs.vtt	5.6 KB
1.1 Simple VLOOKUPS.xlsx.xlsx	9.5 KB
10. Data Arrays Don't Have To Start At A!.mp4	10.1 MB
10. Data Arrays Don't Have To Start At A!.vtt	3.3 KB
11. Some Common Reasons VLook-Ups Fail.mp4	14.7 MB
11. Some Common Reasons VLook-Ups Fail.vtt	7.6 KB
12. One Inherent Flaw In Vlook Up.mp4	3.7 MB
12. One Inherent Flaw In Vlook Up.vtt	1.4 KB
13. POWER USER - A Breakdown Of Looking Up Backwards.mp4	13.9 MB
13. POWER USER - A Breakdown Of Looking Up Backwards.vtt	8.3 KB
14. The Other Way Of Looking Up Backwards.mp4	14.9 MB
14. The Other Way Of Looking Up Backwards.vtt	7.9 KB
15. Backwards Look-Ups In Action.mp4	12.0 MB
15. Backwards Look-Ups In Action.vtt	4.8 KB
15.1 Looking Up Backwards.xlsx.xlsx	10.7 KB
16. POWER USER - Dealing With Inconsistencies In User Entry.mp4	29.5 MB
16. POWER USER - Dealing With Inconsistencies In User Entry.vtt	9.8 KB
17. POWER USER - Fuzzy Vlook-Ups.mp4	10.9 MB
17. POWER USER - Fuzzy Vlook-Ups.vtt	4.2 KB
17.1 Fuzzy VLook-Ups.xlsx.xlsx	10.8 KB
18. POWER USER - Vlook-Ups With Multiple Inputs.mp4	27.0 MB
18. POWER USER - Vlook-Ups With Multiple Inputs.vtt	11.1 KB
18.1 Lookup Up From Multiple Inputs.xlsx.xlsx	21.1 KB
19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.mp4	15.4 MB
19. POWER USER - Looking Up Multiple Inputs Using An Array Formula.vtt	5.7 KB
2. Step 1 - Get Some Data In, And Split It.mp4	18.3 MB
2. Step 1 - Get Some Data In, And Split It.vtt	5.0 KB
2.1 HR File.xlsx.xlsx	24.9 KB
2.2 HR Database Master.xlsx.xlsx	62.8 KB
20. VLOOKUPs Brother...HLOOKUP.mp4	12.9 MB
20. VLOOKUPs Brother...HLOOKUP.vtt	5.4 KB
21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.mp4	34.0 MB
21. POWER USER - The Holy Grail - How To Return Multiple Values From A Single Look U.vtt	15.9 KB
21.1 Returning Multiple Results.xlsx.xlsx	14.4 KB
22. What To Look For When THAT Formula Didn't Work.mp4	10.7 MB
22. What To Look For When THAT Formula Didn't Work.vtt	4.6 KB
23. The Fastest Way To Modify Your Column Numbers.mp4	16.9 MB
23. The Fastest Way To Modify Your Column Numbers.vtt	9.0 KB
24. POWER USER - Vlook-Ups With Moving Columns.mp4	7.9 MB
24. POWER USER - Vlook-Ups With Moving Columns.vtt	3.6 KB
24.1 VLOOKUPS With Moving Columns.xlsx.xlsx	9.6 KB
25. Putting It All Together.mp4	29.4 MB
25. Putting It All Together.vtt	12.3 KB
26. The Finishing Touch - How Many Records Did I Find.mp4	13.2 MB
26. The Finishing Touch - How Many Records Did I Find.vtt	5.1 KB
3. Using Data Validation To Get The Right Input.mp4	12.1 MB
3. Using Data Validation To Get The Right Input.vtt	4.6 KB
4. Let's Build Our Database!.mp4	19.9 MB
4. Let's Build Our Database!.vtt	7.3 KB
5. Importing Data From A Text File.mp4	9.2 MB
5. Importing Data From A Text File.vtt	2.4 KB
5.1 Department Structure.txt.txt	8.0 KB
6. Importing Data From A Word File.mp4	11.5 MB
6. Importing Data From A Word File.vtt	3.1 KB
6.1 Addresses.docx.docx	14.8 KB
7. Pulling Data From Multiple Sources.mp4	10.6 MB
7. Pulling Data From Multiple Sources.vtt	4.3 KB
8. Using OTHER Look-Ups To Look Up!.mp4	17.4 MB
8. Using OTHER Look-Ups To Look Up!.vtt	6.2 KB
9. LOOKUP From A LOOKUP With No Intermediary Step.mp4	6.2 MB
9. LOOKUP From A LOOKUP With No Intermediary Step.vtt	2.5 KB
/14. Project 3 - Named Ranges/
1. A Simple Static Named Range Using A Single Cell.mp4	9.2 MB
1. A Simple Static Named Range Using A Single Cell.vtt	4.6 KB
1.1 Static Named Ranges.xlsx.xlsx	13.1 KB
2. Creating A Named Range Using A Range Of Cells.mp4	6.6 MB
2. Creating A Named Range Using A Range Of Cells.vtt	3.1 KB
3. Using Row Labels To Name Multiple Ranges.mp4	7.6 MB
3. Using Row Labels To Name Multiple Ranges.vtt	3.0 KB
4. POWER USER - A Magic Trick Using Row And Column Labels.mp4	10.8 MB
4. POWER USER - A Magic Trick Using Row And Column Labels.vtt	5.7 KB
5. POWER USER - Dynamic Named Ranges.mp4	19.3 MB
5. POWER USER - Dynamic Named Ranges.vtt	9.5 KB
5.1 Dynamic Named Ranges.xlsx.xlsx	11.3 KB
6. POWER USER - What To Do With Dynamic Names Ranges With Titles.mp4	17.4 MB
6. POWER USER - What To Do With Dynamic Names Ranges With Titles.vtt	6.4 KB
7. 3035 - POWER USER - Dynamic Charts.mp4	51.0 MB
7. 3035 - POWER USER - Dynamic Charts.vtt	12.5 KB
7.1 Dynamic Charts.xlsx.xlsx	18.6 KB
8. 3040 - Horizontal Dynamic Named Ranges For Charts.mp4	44.7 MB
8. 3040 - Horizontal Dynamic Named Ranges For Charts.vtt	12.6 KB
8.1 Horizontal Dynamic Named Ranges.xlsx.xlsx	19.8 KB
/15. Project 4 - What Can I Have For Dinner/
1. Welcome to What Can I Have For Dinner or...What Would I Use THAT for.mp4	2.6 MB
1. Welcome to What Can I Have For Dinner or...What Would I Use THAT for.vtt	1.9 KB
10. It's A One Or A Zero.mp4	5.4 MB
10. It's A One Or A Zero.vtt	2.9 KB
11. Working The Percentages And Adding Traffic Lights.mp4	9.0 MB
11. Working The Percentages And Adding Traffic Lights.vtt	4.8 KB
12. POWER USER - The HYPERLINK Function (And Problem).mp4	12.7 MB
12. POWER USER - The HYPERLINK Function (And Problem).vtt	3.8 KB
13. PRACTICE EXERCISE 1 - Fill In The Blanks.mp4	2.1 MB
13. PRACTICE EXERCISE 1 - Fill In The Blanks.vtt	1.1 KB
14. PRACTICE EXERCISE 2 - Pretty It Up (With A Macro).mp4	4.5 MB
14. PRACTICE EXERCISE 2 - Pretty It Up (With A Macro).vtt	1.9 KB
15. PRACTICE EXERCISE 3 - Create A VLOOKUP Using A Built String With INDIRECT.mp4	4.9 MB
15. PRACTICE EXERCISE 3 - Create A VLOOKUP Using A Built String With INDIRECT.vtt	2.3 KB
2. Hyperlinking To A Different Sheet In The Same Workbook.mp4	8.8 MB
2. Hyperlinking To A Different Sheet In The Same Workbook.vtt	4.7 KB
2.1 What To Have For Dinner.xlsx.xlsx	42.6 KB
3. Creating Our First Macro.mp4	13.3 MB
3. Creating Our First Macro.vtt	6.8 KB
4. Assigning A Macro To A Button.mp4	10.4 MB
4. Assigning A Macro To A Button.vtt	5.4 KB
5. Creating A List For Our Dropdown Using A Dynamic Named Range.mp4	5.9 MB
5. Creating A List For Our Dropdown Using A Dynamic Named Range.vtt	1.9 KB
6. Using A Conditional Format To Know When A Value Is Missing.mp4	10.6 MB
6. Using A Conditional Format To Know When A Value Is Missing.vtt	5.4 KB
7. Copying Conditional Formats And Creating Our Drop-Downs.mp4	7.2 MB
7. Copying Conditional Formats And Creating Our Drop-Downs.vtt	3.3 KB
8. Building Our Formula...INDIRECT Function.mp4	5.9 MB
8. Building Our Formula...INDIRECT Function.vtt	3.3 KB
9. Building Strings For Indirect Sheet And Cell References.mp4	19.1 MB
9. Building Strings For Indirect Sheet And Cell References.vtt	8.4 KB
/16. Project 5 - Using Excel For Gantt Charts...Timelines And Project Plans!/
1. Creating A Gantt Chart Using A Worksheet.mp4	21.8 MB
1. Creating A Gantt Chart Using A Worksheet.vtt	9.1 KB
1.1 Gantt Charts.xlsx.xlsx	32.1 KB
2. Building The First Part Of Our Logical Test.mp4	13.6 MB
2. Building The First Part Of Our Logical Test.vtt	5.1 KB
3. Multiple Logical Tests At Once Using AND.mp4	30.9 MB
3. Multiple Logical Tests At Once Using AND.vtt	9.7 KB
4. Conditional Formatting...Where The Magic Happens.mp4	19.7 MB
4. Conditional Formatting...Where The Magic Happens.vtt	6.7 KB
5. Gantt Charts Using The Built In Charting Tools.mp4	31.0 MB
5. Gantt Charts Using The Built In Charting Tools.vtt	5.9 KB
6. SQA - Gantt Charts With Different Colours For Different Categories.mp4	21.0 MB
6. SQA - Gantt Charts With Different Colours For Different Categories.vtt	8.9 KB
6.1 Gantt Charts With Different Colours For Different Reasons.xlsx.xlsx	28.5 KB
/17. Bonus Section - Just For Fun/
1. How I Created Randomly Generated License Plate Numbers!.mp4	29.1 MB
1. How I Created Randomly Generated License Plate Numbers!.vtt	8.4 KB
/18. Student Questions Answered!/
1. Calls Text Data - Or How To Return a Column Title If Value is 1.mp4	18.0 MB
1. Calls Text Data - Or How To Return a Column Title If Value is 1.vtt	6.9 KB
1.1 1.0 - Calls Text Data.xlsx.xlsx	11.6 KB
10. Data Validation With Dependent Drop-downs.mp4	39.2 MB
10. Data Validation With Dependent Drop-downs.vtt	3.9 KB
10.1 Data Validation - Dependent Dropdowns.xlsx.xlsx	9.8 KB
11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).mp4	81.4 MB
11. Data Validation With Dependent Drop downs (Dynamic Named Range Workaround).vtt	9.4 KB
11.1 Data Validation - Dependent Dropdowns (Dynamic Named Range Work Around).xlsx.xlsx	10.8 KB
12. Using 2 Labels As A Lookup From Drop-downs.mp4	58.3 MB
12. Using 2 Labels As A Lookup From Drop-downs.vtt	7.5 KB
12.1 L2 SQA12 - Using 2 Labels As A Lookup From Drop-downs.xlsx.xlsx	11.3 KB
2. Calls Text Data 2 - This Time Using Text!.mp4	40.5 MB
2. Calls Text Data 2 - This Time Using Text!.vtt	10.0 KB
3. Extracting Phone Numbers From A Cell.mp4	7.2 MB
3. Extracting Phone Numbers From A Cell.vtt	3.0 KB
3.1 3.0 - Extracting Phone Numbers From A Cell.xlsx.xlsx	9.1 KB
4. What Is The CHOOSE Function Really Used For.mp4	42.5 MB
4. What Is The CHOOSE Function Really Used For.vtt	17.3 KB
4.1 CHOOSE Function.xlsx.xlsx	17.0 KB
5. Casing And Text Functions.mp4	15.1 MB
5. Casing And Text Functions.vtt	8.1 KB
5.1 Casing.xlsx.xlsx	9.8 KB
6. Dynamic Charting From A Drop Down.mp4	39.2 MB
6. Dynamic Charting From A Drop Down.vtt	12.2 KB
6.1 5 - Dynamic Tables.xlsx.xlsx	17.0 KB
7. Extracting a Unique List, And Summing The Money!.mp4	14.1 MB
7. Extracting a Unique List, And Summing The Money!.vtt	3.0 KB
8. SUMIF With Dynamic Sum Range.mp4	17.4 MB
8. SUMIF With Dynamic Sum Range.vtt	6.9 KB
8.1 SUMIF With Dynamic Sum Range Column - Completed.xlsx.xlsx	12.4 KB
8.2 SUMIF With Dynamic Sum Range Column - Data Set.xlsx.xlsx	11.9 KB
9. Vlookups With Pictures!.mp4	21.3 MB
9. Vlookups With Pictures!.vtt	5.8 KB
9.1 VLookUps With Pictures! (Before).xlsx.xlsx	210.7 KB
9.2 VLookUps With Pictures! (After).xlsx.xlsx	420.3 KB
/19. Excel Essentials Level 3 - VBA Programming/
1. Why Should I Learn How To Code.mp4	41.6 MB
1. Why Should I Learn How To Code.vtt	12.2 KB
/2. An Introduction To Level 1/
1. Where Are My Practice Files.mp4	3.6 MB
1. Where Are My Practice Files.vtt	1.1 KB
/20. What's It All About, Alan/
1. The 15 Golden Rules Of Coding.mp4	11.9 MB
1. The 15 Golden Rules Of Coding.vtt	8.3 KB
1.1 0010 - The 15 Golden Rules Of Coding.pdf.pdf	124.9 KB
/21. Introducing Your Personal Built In Translator...the Macro Recorder/
1. Introducing The Visual Basic Editor, & Recording Our First Macro.mp4	37.1 MB
1. Introducing The Visual Basic Editor, & Recording Our First Macro.vtt	12.7 KB
1.1 1005 - Excel 3 - Sales Data.xlsx.xlsx	24.3 KB
10. Why You Can't Get By With Just Recording Macros.mp4	37.6 MB
10. Why You Can't Get By With Just Recording Macros.vtt	12.2 KB
11. Section 2 Quiz.html	0.2 KB
2. Saving Macro-Enabled Workbooks, And Security Settings.mp4	19.0 MB
2. Saving Macro-Enabled Workbooks, And Security Settings.vtt	3.7 KB
3. Moving Code Around.mp4	14.0 MB
3. Moving Code Around.vtt	5.5 KB
4. Stepping Out. Well, In Actually! - Debugging Made Easy ).mp4	27.1 MB
4. Stepping Out. Well, In Actually! - Debugging Made Easy ).vtt	6.1 KB
5. With And End With.mp4	38.9 MB
5. With And End With.vtt	13.9 KB
6. Streamlining You Code, Or, Get Rid Of What You Don't Need.mp4	28.3 MB
6. Streamlining You Code, Or, Get Rid Of What You Don't Need.vtt	8.7 KB
7. Combining Your Code.mp4	23.4 MB
7. Combining Your Code.vtt	6.8 KB
8. A Little Privacy Please.mp4	13.1 MB
8. A Little Privacy Please.vtt	13.2 MB
9. Keyboard Shortcuts, And Why I Don't Use Them.mp4	4.3 MB
9. Keyboard Shortcuts, And Why I Don't Use Them.vtt	2.3 KB
9.1 A link to the Official Microsoft Keyboard Shortcuts.html	0.2 KB
9.2 1045 - Excel Keyboard Shortcuts.pdf.pdf	205.9 KB
/22. The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!/
1. Introduction To The Coding Section.mp4	10.5 MB
1. Introduction To The Coding Section.vtt	6.7 KB
10. The Offset Property.mp4	9.3 MB
10. The Offset Property.vtt	2.8 KB
11. The End Property.mp4	13.6 MB
11. The End Property.vtt	3.5 KB
12. Dynamic Range Selection.mp4	15.2 MB
12. Dynamic Range Selection.vtt	3.2 KB
13. The CurrentRegion Property.mp4	8.4 MB
13. The CurrentRegion Property.vtt	2.5 KB
14. ACTIVATE vs. SELECT.mp4	4.5 MB
14. ACTIVATE vs. SELECT.vtt	1.8 KB
15. Between The Sheets.mp4	6.6 MB
15. Between The Sheets.vtt	3.2 KB
16. Calling A Sheet By Its VB Name.mp4	12.0 MB
16. Calling A Sheet By Its VB Name.vtt	12.0 MB
17. Sheets Vs. Worksheets.mp4	9.7 MB
17. Sheets Vs. Worksheets.vtt	2.2 KB
18. Getting Around The Workbooks.mp4	9.2 MB
18. Getting Around The Workbooks.vtt	3.6 KB
19. The Value Property - Writing Data.mp4	19.0 MB
19. The Value Property - Writing Data.vtt	6.8 KB
2. Getting All The Code For This Section.mp4	21.1 MB
2. Getting All The Code For This Section.vtt	8.0 KB
2.1 My Macro Book.xlsx.xlsx	15.4 KB
2.2 ModText.txt.txt	0.3 KB
2.3 ModLooping.txt.txt	0.8 KB
2.4 ModLogicalTesting.txt.txt	9.6 KB
2.5 Mod01_TheBasics.txt.txt	13.2 KB
2.6 Level 3 - HR File.xls.xls	257.0 KB
2.7 ModCopyAndPaste.txt.txt	2.0 KB
20. The Value Property - Reading And Writing Data.mp4	9.8 MB
20. The Value Property - Reading And Writing Data.vtt	2.9 KB
21. Copy And Paste.mp4	11.1 MB
21. Copy And Paste.vtt	3.5 KB
22. Commonly Used Properties.mp4	6.4 MB
22. Commonly Used Properties.vtt	3.6 KB
23. CODING EXERCISE The Rainbow.mp4	6.1 MB
23. CODING EXERCISE The Rainbow.vtt	2.8 KB
23.1 The Rainbow.xlsx.xlsx	10.9 KB
24. The Address Property.mp4	9.3 MB
24. The Address Property.vtt	5.0 KB
25. The Row and Column Properties.mp4	3.6 MB
25. The Row and Column Properties.vtt	1.9 KB
26. Capturing The Column Letter.mp4	4.6 MB
26. Capturing The Column Letter.vtt	2.5 KB
27. More Useful Properties.mp4	9.3 MB
27. More Useful Properties.vtt	4.1 KB
28. Even More Useful Properties.mp4	7.1 MB
28. Even More Useful Properties.vtt	3.5 KB
29. Opening Another Workbook Programmatically.mp4	17.3 MB
29. Opening Another Workbook Programmatically.vtt	8.0 KB
3. Changing Your VBE Settings.mp4	11.8 MB
3. Changing Your VBE Settings.vtt	3.5 KB
30. Closing Workbooks Programmatically.mp4	10.0 MB
30. Closing Workbooks Programmatically.vtt	4.6 KB
31. CODING EXERCISE OpenWriteClose.mp4	9.4 MB
31. CODING EXERCISE OpenWriteClose.vtt	4.0 KB
31.1 Open Write Close.xlsx.xlsx	10.5 KB
32. Let's See How You're Doing....html	0.2 KB
4. Protecting Your Code.mp4	5.0 MB
4. Protecting Your Code.vtt	2.8 KB
5. Objects, Methods And Properties.mp4	17.6 MB
5. Objects, Methods And Properties.vtt	7.7 KB
6. Understanding The Hierarchy.mp4	8.9 MB
6. Understanding The Hierarchy.vtt	4.3 KB
7. The Range Object.mp4	7.4 MB
7. The Range Object.vtt	3.5 KB
8. The Cells Object.mp4	6.5 MB
8. The Cells Object.vtt	3.2 KB
9. The ActiveCell Property.mp4	5.1 MB
9. The ActiveCell Property.vtt	2.9 KB
/23. The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)/
1. Introduction To The Programmers Toolbox.mp4	3.1 MB
1. Introduction To The Programmers Toolbox.vtt	1.0 KB
10. Looping With Do...Loop.mp4	14.0 MB
10. Looping With Do...Loop.vtt	5.9 KB
11. Looping With For...Next.mp4	8.0 MB
11. Looping With For...Next.vtt	2.8 KB
12. Looping With A Stepped For...Next.mp4	7.1 MB
12. Looping With A Stepped For...Next.vtt	2.5 KB
13. Looping With While...Wend.mp4	27.1 MB
13. Looping With While...Wend.vtt	8.2 KB
14. An Introduction To Logical Testing.mp4	5.0 MB
14. An Introduction To Logical Testing.vtt	2.1 KB
14.1 Logical Testing.xlsx.xlsx	17.6 KB
15. Logical Testing - A Simple If Test.mp4	24.0 MB
15. Logical Testing - A Simple If Test.vtt	7.8 KB
16. Logical Testing - A Simple If Test Using Cells.mp4	14.7 MB
16. Logical Testing - A Simple If Test Using Cells.vtt	5.6 KB
17. Logical Testing - If Then Else.mp4	13.7 MB
17. Logical Testing - If Then Else.vtt	3.9 KB
18. Logical Testing - If Then Else Using Cells.mp4	17.3 MB
18. Logical Testing - If Then Else Using Cells.vtt	4.2 KB
19. Logical Testing - Testing Multiple Criteria.mp4	15.3 MB
19. Logical Testing - Testing Multiple Criteria.vtt	4.0 KB
2. Variables - Local Variables.mp4	18.8 MB
2. Variables - Local Variables.vtt	8.0 KB
2.1 Variables.xlsx.xlsx	17.4 KB
2.2 Variables.pdf.pdf	257.0 KB
20. Logical Testing - Testing If One Is True, And One Is False.mp4	8.8 MB
20. Logical Testing - Testing If One Is True, And One Is False.vtt	2.8 KB
21. Logical Testing - Testing If Either Value Is True.mp4	15.1 MB
21. Logical Testing - Testing If Either Value Is True.vtt	4.0 KB
22. Logical Testing - Select Case.mp4	21.6 MB
22. Logical Testing - Select Case.vtt	7.3 KB
23. Maths - Doing Simple Maths In Code.mp4	11.6 MB
23. Maths - Doing Simple Maths In Code.vtt	3.0 KB
23.1 Doing The Math.xlsx.xlsx	905.6 KB
24. Maths - Writing Formulas To Single Cells.mp4	20.9 MB
24. Maths - Writing Formulas To Single Cells.vtt	7.8 KB
25. Maths - Writing Formulas To Ranges Of Cells.mp4	21.0 MB
25. Maths - Writing Formulas To Ranges Of Cells.vtt	6.3 KB
26. Maths - Using Excel's Built-in Functions.mp4	10.4 MB
26. Maths - Using Excel's Built-in Functions.vtt	5.0 KB
27. Maths - Built-in Functions With Defined Ranges.mp4	11.0 MB
27. Maths - Built-in Functions With Defined Ranges.vtt	4.1 KB
28. InputBox - Getting User Input Using The InputBox Function.mp4	16.8 MB
28. InputBox - Getting User Input Using The InputBox Function.vtt	6.4 KB
28.1 Input Boxes.xlsx.xlsx	9.6 KB
29. Manipulating The User Input With Casing.mp4	19.6 MB
29. Manipulating The User Input With Casing.vtt	5.0 KB
3. Variables - Local Variables With A Twist.mp4	12.4 MB
3. Variables - Local Variables With A Twist.vtt	4.1 KB
30. InputBox - Getting User Input Using The InputBox Method.mp4	20.9 MB
30. InputBox - Getting User Input Using The InputBox Method.vtt	6.9 KB
30.1 A really useful article from Microsoft on the different Types you can use with this Method.html	0.1 KB
31. Message Boxes - Simple Message Boxes.mp4	11.1 MB
31. Message Boxes - Simple Message Boxes.vtt	5.3 KB
31.1 Message Boxes.xlsx.xlsx	9.8 KB
32. Message Boxes - Testing Which Button Was Pressed.mp4	13.4 MB
32. Message Boxes - Testing Which Button Was Pressed.vtt	5.7 KB
33. Arrays - An Introduction.mp4	9.1 MB
33. Arrays - An Introduction.vtt	3.3 KB
33.1 Arrays.xlsx.xlsx	82.1 KB
34. Arrays - A Simple One Dimensional Static Array.mp4	22.4 MB
34. Arrays - A Simple One Dimensional Static Array.vtt	7.4 KB
35. Arrays - A Simple One Dimensional Dynamic Array.mp4	19.0 MB
35. Arrays - A Simple One Dimensional Dynamic Array.vtt	6.0 KB
36. Arrays - A Simple Two Dimensional Static Array.mp4	17.5 MB
36. Arrays - A Simple Two Dimensional Static Array.vtt	6.8 KB
37. Arrays - The Most Efficient Way To Capture An Array.mp4	21.7 MB
37. Arrays - The Most Efficient Way To Capture An Array.vtt	5.5 KB
38. Arrays - Extracting Useful Data Based On User Input.mp4	27.3 MB
38. Arrays - Extracting Useful Data Based On User Input.vtt	9.7 KB
39. Arrays - Using An Array As A Data Source For A VLookup.mp4	45.7 MB
39. Arrays - Using An Array As A Data Source For A VLookup.vtt	3.6 KB
4. Variables - Module Level Variables.mp4	12.7 MB
4. Variables - Module Level Variables.vtt	4.4 KB
40. Time For A Quick Quiz....html	0.2 KB
5. Variables - Project Level Variables.mp4	9.1 MB
5. Variables - Project Level Variables.vtt	3.6 KB
6. Bonus - Calling A Sub Stored In A DIFFERENT Workbook!.mp4	10.6 MB
6. Bonus - Calling A Sub Stored In A DIFFERENT Workbook!.vtt	4.8 KB
7. A Neat Trick To Force Variable Declaration.mp4	6.8 MB
7. A Neat Trick To Force Variable Declaration.vtt	1.2 KB
8. Variables - All The Techie Bits.mp4	19.3 MB
8. Variables - All The Techie Bits.vtt	11.2 KB
9. An Introduction To Looping.mp4	2.9 MB
9. An Introduction To Looping.vtt	1.3 KB
/24. Automating All Your Reports!/
1. Introduction To Report Automation Section.mp4	9.9 MB
1. Introduction To Report Automation Section.vtt	3.0 KB
1.1 201601 - West.xlsx.xlsx	26.6 KB
1.2 201601 - North.xlsx.xlsx	27.4 KB
1.3 Monthly Reporting.xlsx.xlsx	16.4 KB
1.4 201601 - East.xlsx.xlsx	24.2 KB
1.5 201601 - South.xlsx.xlsx	30.7 KB
10. Changing The Chart Title (And Why We Do It Separately).mp4	9.6 MB
10. Changing The Chart Title (And Why We Do It Separately).vtt	3.4 KB
11. Deconstructing The Pivot Tables (It's Slightly Different).mp4	23.8 MB
11. Deconstructing The Pivot Tables (It's Slightly Different).vtt	8.9 KB
12. Titles, Money And Sorting.mp4	16.6 MB
12. Titles, Money And Sorting.vtt	5.9 KB
13. Butchering One Table, To Create Another.mp4	20.5 MB
13. Butchering One Table, To Create Another.vtt	6.0 KB
14. Adding The Commentary - Building Strings Dynamically At Runtime.mp4	29.4 MB
14. Adding The Commentary - Building Strings Dynamically At Runtime.vtt	9.3 KB
15. Adding The Comentary Using Data From The Sheet We're On.mp4	21.7 MB
15. Adding The Comentary Using Data From The Sheet We're On.vtt	5.1 KB
16. POWER USER - How DO You Make Specific Words Bold.mp4	23.1 MB
16. POWER USER - How DO You Make Specific Words Bold.vtt	5.6 KB
17. POWER USER - INSTR...A Very Useful Function.mp4	15.0 MB
17. POWER USER - INSTR...A Very Useful Function.vtt	5.9 KB
18. INSTR And Paying Attention To Detail.mp4	12.4 MB
18. INSTR And Paying Attention To Detail.vtt	3.8 KB
19. Tidy Up The Title.mp4	17.6 MB
19. Tidy Up The Title.vtt	3.9 KB
2. A Special Note For Office 2010 Users.mp4	5.1 MB
2. A Special Note For Office 2010 Users.vtt	1.5 KB
20. Easy As Pie (Chart).mp4	25.6 MB
20. Easy As Pie (Chart).vtt	7.4 KB
21. Prettying Up Our Pie Chart.mp4	11.7 MB
21. Prettying Up Our Pie Chart.vtt	3.6 KB
22. Putting It All Together.mp4	21.8 MB
22. Putting It All Together.vtt	5.6 KB
3. Recording The Bones Of The Code.mp4	13.2 MB
3. Recording The Bones Of The Code.vtt	5.2 KB
4. Streamlining The Add New Sheet Code.mp4	23.0 MB
4. Streamlining The Add New Sheet Code.vtt	7.1 KB
5. Deconstructing The Profit By Day Code.mp4	4.8 MB
5. Deconstructing The Profit By Day Code.vtt	2.7 KB
6. Building Source Data Strings Dynamically At Runtime.mp4	22.4 MB
6. Building Source Data Strings Dynamically At Runtime.vtt	8.6 KB
7. Creating The Run Order and Data Capture Subs.mp4	14.4 MB
7. Creating The Run Order and Data Capture Subs.vtt	4.4 KB
8. Solving That Naming Problem.mp4	14.7 MB
8. Solving That Naming Problem.vtt	3.4 KB
9. POWER USER - Sizing Your Charts Precisely.mp4	9.5 MB
9. POWER USER - Sizing Your Charts Precisely.vtt	3.6 KB
/25. The Data Is Out There...On The Internet, That Is/
1. Introduction To Web Query Section.mp4	10.3 MB
1. Introduction To Web Query Section.vtt	2.3 KB
1.1 SuperWebQuery.xlsx.xlsx	33.0 KB
2. Pulling Data From The Internet - Capturing The Data For Rome.mp4	18.0 MB
2. Pulling Data From The Internet - Capturing The Data For Rome.vtt	5.4 KB
3. Getting To Cancun And London From Rome.mp4	23.7 MB
3. Getting To Cancun And London From Rome.vtt	7.1 KB
4. Data Clean Up.mp4	14.7 MB
4. Data Clean Up.vtt	5.0 KB
5. A Simple Find And Replace.mp4	9.1 MB
5. A Simple Find And Replace.vtt	2.8 KB
6. Getting Our Formulas Right.mp4	21.2 MB
6. Getting Our Formulas Right.vtt	4.4 KB
7. Streamlining The Formulas Code.mp4	22.9 MB
7. Streamlining The Formulas Code.vtt	5.6 KB
8. POWER USER - Displaying Messages In The Status Bar (Cool).mp4	11.5 MB
8. POWER USER - Displaying Messages In The Status Bar (Cool).vtt	3.7 KB
9. Putting It All Together.mp4	11.5 MB
9. Putting It All Together.vtt	2.5 KB
/26. Workbook Events You Don't Have To Run Code To Have Code Run!/
1. Intro To The Events Section.mp4	4.9 MB
1. Intro To The Events Section.vtt	2.7 KB
1.1 Workbook Events.xlsx.xlsx	26.5 KB
10. WorkSheet Activate - You Might Pick This!.mp4	9.1 MB
10. WorkSheet Activate - You Might Pick This!.vtt	3.3 KB
11. WorkSheet Change.mp4	6.8 MB
11. WorkSheet Change.vtt	2.8 KB
12. WorkSheet Change - A More Useful Use.mp4	19.2 MB
12. WorkSheet Change - A More Useful Use.vtt	5.9 KB
13. WorkSheet Activate - Top Secret Classified Information!.mp4	11.9 MB
13. WorkSheet Activate - Top Secret Classified Information!.vtt	4.4 KB
14. WorkSheet Events - BONUS - 4 New Things To Try.mp4	81.1 MB
14. WorkSheet Events - BONUS - 4 New Things To Try.vtt	10.0 KB
14.1 Worksheet Events - BONUS.xlsx.xlsx	19.1 KB
2. WorkBook SheetActivate.mp4	15.8 MB
2. WorkBook SheetActivate.vtt	5.3 KB
3. WorkBook BeforePrint.mp4	8.7 MB
3. WorkBook BeforePrint.vtt	3.1 KB
4. WorkBook SheetChange.mp4	3.2 MB
4. WorkBook SheetChange.vtt	1.6 KB
5. WorkBook Open - Creating An Auto-Back Up.mp4	21.4 MB
5. WorkBook Open - Creating An Auto-Back Up.vtt	6.6 KB
6. WorkBook Open - Creating A Splash Screen.mp4	15.4 MB
6. WorkBook Open - Creating A Splash Screen.vtt	5.0 KB
7. WorkBook Open - Calling Other Code.mp4	24.2 MB
7. WorkBook Open - Calling Other Code.vtt	6.7 KB
8. WorkBook BeforeClose.mp4	8.3 MB
8. WorkBook BeforeClose.vtt	3.5 KB
9. WorkSheet Activate - You Can't Pick This!.mp4	5.8 MB
9. WorkSheet Activate - You Can't Pick This!.vtt	2.2 KB
/27. User Defined Functions...What To Do If The Function You Need Isn't In Excel!/
1. User Defined Functions...What They Are, And How You Make Them.mp4	12.6 MB
1. User Defined Functions...What They Are, And How You Make Them.vtt	6.8 KB
1.1 User Defined Functions.xlsx.xlsx	11.6 KB
2. Using A UDF To Return Information.mp4	3.8 MB
2. Using A UDF To Return Information.vtt	2.1 KB
3. Creating A Countdown Timer With A UDF.mp4	17.1 MB
3. Creating A Countdown Timer With A UDF.vtt	10.1 KB
4. A Custom UDF For Calculating Volume Discount.mp4	8.5 MB
4. A Custom UDF For Calculating Volume Discount.vtt	4.9 KB
5. A UDF For Getting All Your Sheet Names.mp4	21.7 MB
5. A UDF For Getting All Your Sheet Names.vtt	3.6 KB
6. Calling A UDF From A Different Workbook.mp4	4.0 MB
6. Calling A UDF From A Different Workbook.vtt	2.1 KB
/28. Bonus Section Controlling Windows - Folder Creation Gizmo/
1. Intro To Folder Creation Gizmo.mp4	6.3 MB
1. Intro To Folder Creation Gizmo.vtt	3.1 KB
1.1 Folder Creation Gizmo.xlsx.xlsx	13.8 KB
2. Creating A New Folder With A Single Line Of Code.mp4	2.1 MB
2. Creating A New Folder With A Single Line Of Code.vtt	1.1 KB
3. A Single Level Folder Structure.mp4	17.2 MB
3. A Single Level Folder Structure.vtt	6.3 KB
4. Folders Within Folders.mp4	15.5 MB
4. Folders Within Folders.vtt	6.8 KB
/29. Bonus Section eMail Automation...Why WRITE emails!/
1. Intro To The Emailing Section.mp4	9.4 MB
1. Intro To The Emailing Section.vtt	4.1 KB
1.1 eMail Automation.xlsx.xlsx	21.6 KB
2. Understanding The eMail Routine.mp4	16.3 MB
2. Understanding The eMail Routine.vtt	6.2 KB
3. Deconstructing How We Capture All The Data.mp4	31.0 MB
3. Deconstructing How We Capture All The Data.vtt	12.6 KB
4. The eMail Loop.mp4	16.4 MB
4. The eMail Loop.vtt	6.6 KB
/3. Start Here - All The Basics/
1. Opening Excel, and Creating a Shortcut.mp4	18.7 MB
1. Opening Excel, and Creating a Shortcut.vtt	5.3 KB
1.1 Cells, Columns and Rows.pdf.pdf	190.6 KB
1.2 My Fruit And Veg Shop.xlsx.xlsx	19.0 KB
1.3 Excel Level 1 Practice File.xlsx.xlsx	23.6 KB
10. A Quick Word On Formatting.mp4	3.7 MB
10. A Quick Word On Formatting.vtt	1.7 KB
11. Formatting Text - Alignment.mp4	7.2 MB
11. Formatting Text - Alignment.vtt	4.4 KB
12. Saving Time With AutoFilling Sequences.mp4	11.5 MB
12. Saving Time With AutoFilling Sequences.vtt	6.4 KB
13. POWER USER - Adding Your Own Lists To Autofill.mp4	18.9 MB
13. POWER USER - Adding Your Own Lists To Autofill.vtt	6.8 KB
14. Saving Time With Format Painter.mp4	6.9 MB
14. Saving Time With Format Painter.vtt	4.0 KB
15. Changing The Column Width.mp4	7.7 MB
15. Changing The Column Width.vtt	4.7 KB
16. Quiz Number 2.html	0.2 KB
17. Tidy Large Titles With Merge And Centre.mp4	6.5 MB
17. Tidy Large Titles With Merge And Centre.vtt	3.8 KB
18. Entering Data - A Couple Of Shortcuts.mp4	8.7 MB
18. Entering Data - A Couple Of Shortcuts.vtt	5.2 KB
2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.mp4	52.0 MB
2. The Anatomy Of A Workbook Where Everything Is, And What It Does!.vtt	20.3 KB
3. A Quick Review Of What's Where.mp4	17.9 MB
3. A Quick Review Of What's Where.vtt	8.3 KB
3.1 The Anatomy Of A Workbook.pdf.pdf	379.3 KB
4. Always Do This First! - Save Your New Workbook!.mp4	4.9 MB
4. Always Do This First! - Save Your New Workbook!.vtt	2.5 KB
5. Let's Enter Some Data.mp4	3.4 MB
5. Let's Enter Some Data.vtt	2.1 KB
6. Quiz 1.html	0.2 KB
7. Editing Data.mp4	3.1 MB
7. Editing Data.vtt	2.2 KB
8. Ooops. I Made A Mistake - Undo and Redo.mp4	2.5 MB
8. Ooops. I Made A Mistake - Undo and Redo.vtt	1.5 KB
9. Changing Appearance Of Text With Formatting - Fonts.mp4	22.9 MB
9. Changing Appearance Of Text With Formatting - Fonts.vtt	12.4 KB
/30. Bonus Section Word Automation - Controlling Word From Excel/
1. Intro To The Word Section.mp4	2.3 MB
1. Intro To The Word Section.vtt	1.0 KB
1.1 9000 - Word Automation.xlsx.xlsx	38.9 KB
2. Understanding The Word Routine.mp4	4.9 MB
2. Understanding The Word Routine.vtt	2.9 KB
3. Deconstructing How We Capture All The Data.mp4	11.7 MB
3. Deconstructing How We Capture All The Data.vtt	3.6 KB
4. Formula Modifications With Unique Values.mp4	16.5 MB
4. Formula Modifications With Unique Values.vtt	3.9 KB
5. Efficient Sorting.mp4	11.6 MB
5. Efficient Sorting.vtt	3.8 KB
6. Building The Text And Wrap Up.mp4	16.0 MB
6. Building The Text And Wrap Up.vtt	6.4 KB
/31. Bonus Section PowerPoint Automation - Create Your Presentation In Seconds!/
1. Intro To PowerPoint Section.mp4	3.3 MB
1. Intro To PowerPoint Section.vtt	1.6 KB
10. Final Slide, And Wrap Up.mp4	8.8 MB
10. Final Slide, And Wrap Up.vtt	2.6 KB
2. A Run Through The PowerPoint Base Code.mp4	26.8 MB
2. A Run Through The PowerPoint Base Code.vtt	11.6 KB
2.1 Northern Sales Report PowerPoint.xlsx.xlsx	77.9 KB
3. Setting Up The Shell Of The Code.mp4	8.9 MB
3. Setting Up The Shell Of The Code.vtt	3.9 KB
4. Who's Presenting This....mp4	10.0 MB
4. Who's Presenting This....vtt	2.7 KB
5. Adding A Slide With A Logo And Text.mp4	31.7 MB
5. Adding A Slide With A Logo And Text.vtt	9.4 KB
6. Prettying Up The Formatting (More Lego Coding!).mp4	7.8 MB
6. Prettying Up The Formatting (More Lego Coding!).vtt	2.6 KB
7. Using Slide 1 To Create Slide 2.mp4	17.2 MB
7. Using Slide 1 To Create Slide 2.vtt	5.0 KB
8. Adding A Chart As A Picture.mp4	32.8 MB
8. Adding A Chart As A Picture.vtt	8.0 KB
9. Adding Pivot Tables (And Another Chart).mp4	40.6 MB
9. Adding Pivot Tables (And Another Chart).vtt	10.9 KB
/32. Importing Specific Data From Multiple Files/
1. Intro To Importing Data From A Folder Full Of Files.mp4	10.5 MB
1. Intro To Importing Data From A Folder Full Of Files.vtt	4.3 KB
2. Looping Through All Excel Files In A Folder.mp4	15.1 MB
2. Looping Through All Excel Files In A Folder.vtt	4.9 KB
2.1 201611 - Western Region.xlsx.xlsx	10.4 KB
2.2 201611 - Eastern Region.xlsx.xlsx	9.3 KB
2.3 201612 - Western Region.xlsx.xlsx	11.6 KB
2.4 201612 - Southern Region.xlsx.xlsx	10.3 KB
2.5 201611 - Northern Region.xlsx.xlsx	11.3 KB
2.6 201612 - Northern Region.xlsx.xlsx	11.3 KB
2.7 201611 - Southern Region.xlsx.xlsx	10.3 KB
2.8 201612 - Eastern Region.xlsx.xlsx	9.3 KB
2.9 Mass Data Getterer.xlsx.xlsx	19.4 KB
3. The Folder Picker.mp4	11.4 MB
3. The Folder Picker.vtt	4.2 KB
4. A More Useful Loop Through Files.mp4	8.3 MB
4. A More Useful Loop Through Files.vtt	4.0 KB
5. The Data Grabber(er).mp4	48.2 MB
5. The Data Grabber(er).vtt	16.4 KB
/33. Student Questions Answered/
1. Get rid of rows in a array.mp4	17.5 MB
1. Get rid of rows in a array.vtt	7.6 KB
1.1 Question 1.xlsx.xlsx	580.1 KB
10. Protecting Specific Cells and Data Validation.mp4	34.1 MB
10. Protecting Specific Cells and Data Validation.vtt	14.7 KB
10.1 Protecting Specific Cells and Data Validation.xlsx.xlsx	16.1 KB
11. Dynamically Populating A Reusable Array While Looping Through A Table.mp4	16.0 MB
11. Dynamically Populating A Reusable Array While Looping Through A Table.vtt	6.8 KB
11.1 Katrina.xlsx.xlsx	10.0 KB
12. Sequential PDF Creation With Pictures.mp4	51.4 MB
12. Sequential PDF Creation With Pictures.vtt	19.9 KB
12.1 AS1.jpg.jpg	33.2 KB
12.2 EF1.jpg.jpg	32.8 KB
12.3 Sequential PDF Creation With Pictures.xlsx.xlsx	12.8 KB
12.4 CW1.jpg.jpg	23.1 KB
12.5 CS1.jpg.jpg	34.0 KB
12.6 DJ1.jpg.jpg	26.6 KB
13. File Picker, And Report Generator With Intelligent Filing.mp4	61.3 MB
13. File Picker, And Report Generator With Intelligent Filing.vtt	16.9 KB
13.1 All Months.xlsx.xlsx	13.0 KB
13.2 Latest Month.xlsx.xlsx	13.0 KB
13.3 Lisa's Report Builder.xlsx.xlsx	20.1 KB
14. Help! My File Has Got HUGE!.mp4	27.6 MB
14. Help! My File Has Got HUGE!.vtt	9.2 KB
14.1 SQA 14 - Magic Sheet Sizer.xlsx.xlsx	9.2 KB
15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.mp4	30.8 MB
15. Finding Updated Values In One Workbook, And Adding Them To Another Workbook.vtt	11.0 KB
15.1 Sean Destination File.xlsx.xlsx	11.1 KB
15.2 Sean Source File.xlsx.xlsx	13.5 KB
16. Gantt Charts...With A Little More Sophistication!.mp4	34.8 MB
16. Gantt Charts...With A Little More Sophistication!.vtt	12.9 KB
16.1 Gantt Charts - With A Little More Sophisticaton.xlsx.xlsx	76.6 KB
17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.mp4	142.8 MB
17. Vlookups (Or Any Application.WorksheetFunction) Over Ranges.vtt	14.7 KB
17.1 VLookUps In Code....xlsx.xlsx	10.7 KB
18. Adding A Date Stamp If A Change Has Been Made.mp4	49.7 MB
18. Adding A Date Stamp If A Change Has Been Made.vtt	6.3 KB
18.1 Level 3 SQA 18 - Adding A Date Stamp If A Change Has Been Made.xlsx.xlsx	9.9 KB
2. Emailing Routine Adding a Specific Attachment Based On a Criteria.mp4	13.1 MB
2. Emailing Routine Adding a Specific Attachment Based On a Criteria.vtt	4.4 KB
3. Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY.mp4	18.3 MB
3. Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY.vtt	8.9 KB
3.1 Project Tracker.xlsx.xlsx	13.8 KB
4. Saving An Individual Sheet To A Specific Folder.mp4	31.2 MB
4. Saving An Individual Sheet To A Specific Folder.vtt	13.8 KB
4.1 Territory Managers.xlsx.xlsx	16.0 KB
5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.mp4	84.9 MB
5. Saving Multiple Sheets To A Single Workbook In A Specific Folder.vtt	33.1 KB
5.1 Territory Managers Part 2.xlsx.xlsx	23.8 KB
6. Animated Charts...With A Little Something Extra!.mp4	25.5 MB
6. Animated Charts...With A Little Something Extra!.vtt	7.2 KB
6.1 Animated Charts.xlsx.xlsx	19.6 KB
7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.mp4	40.0 MB
7. Extracting Specific Data From A Big File, To A Bunch Of Little Ones.vtt	10.0 KB
7.1 SQA - Neil.xlsx.xlsx	15.9 KB
8. Finding A Search String in Another Workbook With Multiple Sheets.mp4	15.4 MB
8. Finding A Search String in Another Workbook With Multiple Sheets.vtt	6.5 KB
8.1 SQA - Pascal - Run Me From Here.xlsx.xlsx	12.4 KB
8.2 SQA - Pascal - Data Set.xlsx.xlsx	10.5 KB
9. Extracting Unique Tables to Unique Sheets From A Big Data Set.mp4	47.1 MB
9. Extracting Unique Tables to Unique Sheets From A Big Data Set.vtt	17.0 KB
9.1 SQA Neil MPAN Data Set.xlsx.xlsx	837.7 KB
/34. Thank You - Your Special Bonus!/
1. Get Your Next Course Now!.mp4	4.6 MB
1. Get Your Next Course Now!.vtt	1.5 KB
1.1 Code Demo Solution File (Using Level 3 - HR File).xlsx.xlsx	101.7 KB
1.2 123 Get Your Next Course.pdf.pdf	206.6 KB
/4. Doing The (Simple) Math/
1. Sums - The Old Fashioned Way!.mp4	6.4 MB
1. Sums - The Old Fashioned Way!.vtt	3.8 KB
10. The Order Of Mathematical Operation.mp4	13.2 MB
10. The Order Of Mathematical Operation.vtt	8.4 KB
10.1 The Order Of Mathematical Operation.pdf.pdf	444.8 KB
11. POWER USER - Evaluate Formula.mp4	10.9 MB
11. POWER USER - Evaluate Formula.vtt	6.4 KB
2. Sums - Using Autosum.mp4	13.8 MB
2. Sums - Using Autosum.vtt	7.5 KB
3. Quiz Number 3.html	0.2 KB
4. Copying Formulas.mp4	8.1 MB
4. Copying Formulas.vtt	3.9 KB
5. SUMming Horizontally.mp4	7.7 MB
5. SUMming Horizontally.vtt	4.3 KB
6. Basic Formulas - Subtraction.mp4	5.8 MB
6. Basic Formulas - Subtraction.vtt	3.0 KB
7. Basic Formulas - Multiplication.mp4	3.7 MB
7. Basic Formulas - Multiplication.vtt	2.1 KB
8. Basic Formulas - Division.mp4	2.9 MB
8. Basic Formulas - Division.vtt	1.8 KB
9. Average Function.mp4	7.5 MB
9. Average Function.vtt	3.5 KB
/5. Rearranging Things/
1. Inserting New Columns And Rows.mp4	17.0 MB
1. Inserting New Columns And Rows.vtt	8.5 KB
2. Moving Existing Columns And Rows.mp4	6.2 MB
2. Moving Existing Columns And Rows.vtt	3.2 KB
3. Cutting, Copying, Inserting And Deleting.mp4	12.7 MB
3. Cutting, Copying, Inserting And Deleting.vtt	8.4 KB
4. Hiding Columns And Rows.mp4	8.5 MB
4. Hiding Columns And Rows.vtt	3.7 KB
5. Quiz Number 4.html	0.2 KB
/6. Formulas Learning The Clever Stuff!/
1. ROUNDing Functions.mp4	16.0 MB
1. ROUNDing Functions.vtt	8.3 KB
2. Formatting Numbers.mp4	8.0 MB
2. Formatting Numbers.vtt	3.3 KB
3. A Primer In Building Complex Formulas.mp4	6.4 MB
3. A Primer In Building Complex Formulas.vtt	4.0 KB
4. Buliding a Compex Formula.mp4	11.8 MB
4. Buliding a Compex Formula.vtt	5.4 KB
/7. A Few More Essentials/
1. Sorting.mp4	14.6 MB
1. Sorting.vtt	5.7 KB
10. Getting Help.mp4	5.7 MB
10. Getting Help.vtt	2.1 KB
11. Filters.mp4	17.8 MB
11. Filters.vtt	7.6 KB
12. Highlighting Cells.mp4	8.9 MB
12. Highlighting Cells.vtt	2.7 KB
13. Quiz Number 6.html	0.2 KB
14. Closing.mp4	3.9 MB
14. Closing.vtt	2.1 KB
2. Wrapping Text And Soft Enter.mp4	11.7 MB
2. Wrapping Text And Soft Enter.vtt	5.2 KB
3. Adding A New Worksheet.mp4	4.0 MB
3. Adding A New Worksheet.vtt	1.4 KB
4. Creating A Simple Chart.mp4	12.9 MB
4. Creating A Simple Chart.vtt	5.3 KB
5. Quiz Number 5.html	0.2 KB
6. Adding Borders.mp4	8.6 MB
6. Adding Borders.vtt	3.5 KB
7. Customizing the Quick Access Toolbar.mp4	7.2 MB
7. Customizing the Quick Access Toolbar.vtt	2.7 KB
8. Simple Printing.mp4	13.5 MB
8. Simple Printing.vtt	5.1 KB
9. Freezing For An Easier View.mp4	14.4 MB
9. Freezing For An Easier View.vtt	5.5 KB
/8. Bonus Section - The Keyboard Shortcuts/
1. Bonus 1 Whizzing Around Excel.mp4	20.5 MB
1. Bonus 1 Whizzing Around Excel.vtt	9.3 KB
2. Bonus 2 Keyboard Shortcuts.mp4	37.1 MB
2. Bonus 2 Keyboard Shortcuts.vtt	15.0 KB
2.1 Keyboards Shortcuts For Mac Users.html	0.2 KB
2.2 Microsoft Complete List Of Excel Keyboard Shortcuts.txt.txt	0.1 KB
2.3 The Most Popular Excel Keyboard Shortcuts.pdf.pdf	187.6 KB
/9. Bonus Section Absolute and Relative Cell References/
1. A1 Style - Relative Relative.mp4	5.8 MB
1. A1 Style - Relative Relative.vtt	2.6 KB
1.1 Absolute And Relative Cell References.xlsx.xlsx	12.9 KB
2. $A$1 Style - Absolute Absolute.mp4	6.9 MB
2. $A$1 Style - Absolute Absolute.vtt	2.9 KB
3. $A1 Style - Absolute Relative.mp4	4.9 MB
3. $A1 Style - Absolute Relative.vtt	2.5 KB
4. A$1 Style - Relative Absolute.mp4	4.6 MB
4. A$1 Style - Relative Absolute.vtt	2.4 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 782