Section 1 : Excel Essentials Level 1 Basics - Master Excel Step-By-Step

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 2 lecture 1 About Certification

Section 2 : An Introduction To Level 1

Lecture 1 About Proctor Testing

Section 3 : . Start Here - All The Basics

Lecture 1 Opening Excel, and Creating a Shortcut copy 00:03:46 Duration
Lecture 2 The Anatomy Of A Workbook Where Everything Is, An 00:15:19 Duration
Lecture 3 A Quick Review Of What's Where 00:06:12 Duration
Lecture 4 Accessing The F Keys (Function Keys) On A Laptop 00:00:55 Duration
Lecture 5 Always Do This First! - Save Your New Workbook 00:02:01 Duration
Lecture 6 Let's Enter Some Data 00:01:42 Duration
Lecture 7 Editing Data 00:01:42 Duration
Lecture 8 Ooops. I Made A Mistake - Undo and Redo 00:01:21 Duration
Lecture 9 Changing Appearance Of Text With Formatting 00:09:03 Duration
Lecture 10 A Quick Word On Formatting 00:01:20 Duration
Lecture 11 Formatting Text - Alignment 00:03:07 Duration
Lecture 12 Saving Time With AutoFilling Sequences 00:04:41 Duration
Lecture 13 POWER USER - Adding Your Own Lists To Autofill 00:04:23 Duration
Lecture 14 Saving Time With Format Painter 00:02:48 Duration
Lecture 15 Changing The Column Width 00:03:33 Duration
Lecture 16 Tidy Large Titles With Merge And Centre 00:03:01 Duration
Lecture 17 Entering Data - A Couple Of Shortcuts 00:03:57 Duration

Section 4 : Doing The (Simple) Math

Lecture 1 Sums - The Old Fashioned Way! 00:03:11 Duration
Lecture 2 Sums - Using Autosum 00:05:33 Duration
Lecture 3 Copying Formulas 00:03:17 Duration
Lecture 4 SUMming Horizontally 00:03:17 Duration
Lecture 5 Basic Formulas - Subtraction. 00:02:28 Duration
Lecture 6 Basic Formulas - Multiplication 00:01:33 Duration
Lecture 7 Basic Formulas - Division 00:01:22 Duration
Lecture 8 Average Function 00:02:41 Duration
Lecture 9 The Order Of Mathematical Operation
Lecture 10 POWER USER - Evaluate Formula 00:04:51 Duration

Section 5 : Rearranging Things

Lecture 1 Inserting New Columns And Rows 00:06:21 Duration
Lecture 2 Moving Existing Columns And Rows 00:02:27 Duration
Lecture 3 Cutting, Copying, Inserting And Deleting 00:06:07 Duration
Lecture 4 Hiding Columns And Rows 00:02:41 Duration

Section 6 : Formulas Learning The Clever Stuff!

Lecture 1 Rounding Functions 00:05:55 Duration
Lecture 2 Formatting Numbers 00:02:12 Duration
Lecture 3 A Primer In Building Complex Formulas 00:03:10 Duration
Lecture 4 Buliding a Compex Formula 00:04:20 Duration

Section 7 : A Few More Essentials

Lecture 1 Sorting 00:04:16 Duration
Lecture 2 Wrapping Text And Soft Enter 00:04:00 Duration
Lecture 3 Adding A New Worksheet 00:01:08 Duration
Lecture 4 Creating A Simple Chart. 00:04:21 Duration
Lecture 5 Adding Borders 00:02:36 Duration
Lecture 6 Customizing the Quick Access Toolbar 00:02:11 Duration
Lecture 7 Simple Printing 00:03:34 Duration
Lecture 8 Freezing For An Easier View 00:04:07 Duration
Lecture 9 Getting Help 00:01:39 Duration
Lecture 10 Filters 00:06:22 Duration
Lecture 11 Highlighting Cells 00:02:04 Duration
Lecture 12 Closing 00:01:30 Duration

Section 8 : Bonus Section - The Keyboard Shortcuts

Lecture 1 Bonus 1 Whizzing Around Excel 00:06:46 Duration
Lecture 2 Bonus 2 Keyboard Shortcuts 00:11:18 Duration

Section 9 : Bonus Section Absolute and Relative Cell References

Lecture 1 A1 Style - Relative Relative 00:02:16 Duration
Lecture 2 $A$1 Style - Absolute Absolute 00:02:44 Duration
Lecture 3 $A1 Style - Absolute Relative 00:02:16 Duration
Lecture 4 A$1 Style - Relative Absolute 00:02:01 Duration

Section 10 : Bonus Section Student Questions Answered!

Lecture 1 Reverse Engineering A Sample Spreadsheet 00:20:56 Duration
Lecture 2 Casing And Text Functions 00:20:56 Duration
Lecture 3 Level 1 SQA 03 - Charts From A Filtered List 00:02:54 Duration

Section 11 : Excel Essentials Level 2 - IntermediateAdvanced

Lecture 1 Intro To Level 00:01:58 Duration

Section 12 : Project 1 - Creating A Data Entry Screen To Populate

Lecture 1 Proof Of Concept 00:04:50 Duration
Lecture 2 Planning Ahead 00:06:02 Duration
Lecture 3 Creating Our Data Entry Screen 00:04:08 Duration
Lecture 4 (Custom) Formatting Dates And Time 00:04:08 Duration
Lecture 5 Simple Calculations With Time 00:02:36 Duration
Lecture 6 More (Useful) Calculations With Time 00:08:07 Duration
Lecture 7 It's About Time (And Dates! 00:08:28 Duration
Lecture 8 Adding Time 00:03:40 Duration
Lecture 9 Creating A Template From An Image. 00:11:35 Duration
Lecture 10 Importing A Template From An Existing Excel File. 00:02:22 Duration
Lecture 11 Converting Time To A Decimal 00:05:42 Duration
Lecture 12 A Little Bit Of Simple Data Entry 00:03:12 Duration
Lecture 13 Simple Conditional Formatting For A Cleaner View 00:04:43 Duration
Lecture 14 Calculating Time Out Of House Using Travel Time 00:04:47 Duration
Lecture 15 Simple Logical Testing And Nested Logical Testing 00:08:29 Duration
Lecture 16 Building Text Strings With A Formula 00:12:10 Duration
Lecture 17 Before We Move On...Accessing The Developer Ribbon 00:01:05 Duration
Lecture 18 A Tick Box Exercise (Of Sorts) 00:07:11 Duration
Lecture 19 populating Check Boxes 00:11:49 Duration
Lecture 20 Radio Buttons as an Alternative to Check Boxes 00:13:26 Duration
Lecture 21 PRACTICE EXERCISE 1 - Time To Add A New Entry 00:01:40 Duration
Lecture 22 Defining A Working Area, And Protecting Your Work 00:04:41 Duration
Lecture 23 PRACTICE EXERCISE 2 - Set Up A Working Area 00:01:07 Duration

Section 13 : Project 2 - Building A Database With Excel

Lecture 1 Simple VLOOKUP 00:04:17 Duration
Lecture 2 Get Some Data In, And Split It 00:03:54 Duration
Lecture 3 Using Data Validation To Get The Right Input 00:03:47 Duration
Lecture 4 Let's Build Our Database 00:06:12 Duration
Lecture 5 Importing Data From A Text File 00:02:02 Duration
Lecture 6 Importing Data From A Word File 00:02:37 Duration
Lecture 7 Pulling Data From Multiple Sources 00:03:33 Duration
Lecture 8 Using OTHER Look-Ups To Look Up 00:05:25 Duration
Lecture 9 LOOKUP From A LOOKUP With No Intermediary Step 00:02:20 Duration
Lecture 10 Data Arrays Don't Have To Start At A 00:02:58 Duration
Lecture 11 ome Common Reasons VLook-Ups Fail 00:06:02 Duration
Lecture 12 One Inherent Flaw In Vlook Up 00:01:11 Duration
Lecture 13 POWER USER - A Breakdown Of Looking Up Backwar 00:06:44 Duration
Lecture 14 The Other Way Of Looking Up Backwards 00:06:49 Duration
Lecture 15 Backwards Look-Ups In Action 00:03:47 Duration
Lecture 16 POWER USER - Dealing With Inconsistencies In U 00:08:19 Duration
Lecture 17 POWER USER - Fuzzy Vlook-Ups 00:03:33 Duration
Lecture 18 POWER USER - Vlook-Ups With Multiple Inputs 00:09:39 Duration
Lecture 19 POWER USER - Looking Up Multiple Inputs Using 00:04:45 Duration
Lecture 20 VLOOKUPs Brother...HLOOKUP 00:05:05 Duration
Lecture 21 POWER USER - The Holy Grail - How To Return 00:13:34 Duration
Lecture 22 What To Look For When THAT Formula Didn't Wor 00:04:06 Duration
Lecture 23 The Fastest Way To Modify Your Column Numbers 00:07:25 Duration
Lecture 24 POWER USER - Vlook-Ups With Moving Columns 00:03:06 Duration
Lecture 25 Putting It All Together 00:09:53 Duration
Lecture 26 The Finishing Touch - How Many Records Did I 00:04:28 Duration

Section 14 : Project 3 - Named Ranges

Lecture 1 A Simple Static Named Range Using A Single Ce 00:03:44 Duration
Lecture 2 Creating A Named Range Using A Range Of Cells 00:02:54 Duration
Lecture 3 Using Row Labels To Name Multiple Ranges 00:02:34 Duration
Lecture 4 POWER USER - A Magic Trick Using Row And Colu 00:04:55 Duration
Lecture 5 POWER USER - Dynamic Named Ranges 00:08:07 Duration
Lecture 6 POWER USER - What To Do With Dynamic Names Ra 00:05:22 Duration
Lecture 7 3035 - POWER USER - Dynamic Charts 00:10:28 Duration
Lecture 8 3040 - Horizontal Dynamic Named Ranges For Ch 00:11:10 Duration

Section 15 : Project 4 - What Can I Have For Dinner

Lecture 1 Welcome to What Can I Have For Dinner or...Wh 00:01:25 Duration
Lecture 2 Hyperlinking To A Different Sheet In The Same 00:03:33 Duration
Lecture 3 Creating Our First Macro 00:05:37 Duration
Lecture 4 Assigning A Macro To A Button 00:04:13 Duration
Lecture 5 Creating A List For Our Dropdown Using A Dyna 00:01:40 Duration
Lecture 6 Using A Conditional Format To Know When A Val 00:04:35 Duration
Lecture 7 Copying Conditional Formats And Creating Our 00:02:50 Duration
Lecture 8 Building Our Formula...INDIRECT Function 00:02:55 Duration
Lecture 9 Building Strings For Indirect Sheet And Cell 00:07:17 Duration
Lecture 10 It's A One Or A Zero 00:02:36 Duration
Lecture 11 Working The Percentages And Adding Traffic Li 00:04:06 Duration
Lecture 12 POWER USER - The HYPERLINK Function (And Prob 00:03:17 Duration
Lecture 13 PRACTICE EXERCISE 1 - Fill In The Blanks 00:00:59 Duration
Lecture 14 PRACTICE EXERCISE 2 - Pretty It Up (With A Ma 00:01:46 Duration
Lecture 15 PRACTICE EXERCISE 3 - Create A VLOOKUP Using 00:02:13 Duration

Section 16 : Project 5 - Using Excel For Gantt Charts...Timel

Lecture 1 Creating A Gantt Chart Using A Worksheet 00:07:39 Duration
Lecture 2 Building The First Part Of Our Logical Test
Lecture 3 Multiple Logical Tests At Once Using AND 00:08:28 Duration
Lecture 4 Conditional Formatting...Where The Magic Happ 00:05:33 Duration
Lecture 5 Gantt Charts Using The Built In Charting Tool 00:04:51 Duration
Lecture 6 SQA - Gantt Charts With Different Colours For 00:07:47 Duration

Section 17 : Bonus Section - Just For Fun

Lecture 1 How I Created Randomly Generated License Plat 00:07:14 Duration

Section 18 : Student Questions Answered!

Lecture 1 Calls Text Data - Or How To Return a Column T 00:06:42 Duration
Lecture 2 Calls Text Data 2 - This Time Using Text! 00:09:02 Duration
Lecture 3 Extracting Phone Numbers From A Cell 00:02:40 Duration
Lecture 4 What Is The CHOOSE Function Really Used For 00:14:48 Duration
Lecture 5 Casing And Text Functions 00:06:35 Duration
Lecture 6 Dynamic Charting From A Drop Down 00:10:03 Duration
Lecture 7 Extracting a Unique List, And Summing The Mon 00:02:26 Duration
Lecture 8 SUMIF With Dynamic Sum Range 00:05:55 Duration
Lecture 9 Vlookups With Pictures! 00:04:30 Duration
Lecture 10 Data Validation With Dependent Drop-downs 00:03:42 Duration
Lecture 11 Data Validation With Dependent Drop downs (Dy 00:08:31 Duration
Lecture 12 Using 2 Labels As A Lookup From Drop-downs 00:06:47 Duration
Lecture 13 Tiered Pricing - SUMming So Many At One Price 00:09:00 Duration
Lecture 14 The Middle Name Problem, and Solution! 00:09:03 Duration
Lecture 15 Finding Matches, And Counting Entries 00:08:06 Duration
Lecture 16 Fee Calculator, or LOOKUPs That Are True, Not 00:05:43 Duration
Lecture 17 The IF(s) Functions 00:06:01 Duration
Lecture 18 Drop Down List, Shifting Ranges 00:06:07 Duration
Lecture 19 Dynamic Calculations From Another Sheet 00:12:46 Duration

Section 19 : Excel Essentials Level 3 - VBA Programming

Lecture 1 Why Should I Learn How To Code 00:10:28 Duration

Section 20 : What's It All About, Alan

Lecture 1 The 15 Golden Rules Of Coding 00:06:24 Duration

Section 21 : Introducing Your Personal Built In Translator...

Lecture 1 Introducing The Visual Basic Editor, & Record 00:11:10 Duration
Lecture 2 Saving Macro-Enabled Workbooks, And Security 00:03:17 Duration
Lecture 3 Moving Code Around 00:04:38 Duration
Lecture 4 Stepping Out. Well, In Actually! - Debugging 00:05:51 Duration
Lecture 5 With And End With 00:12:35 Duration
Lecture 6 Streamlining You Code, Or, Get Rid Of What Yo 00:07:53 Duration
Lecture 7 Combining Your Code 00:06:18 Duration
Lecture 8 A Little Privacy Please 00:03:19 Duration
Lecture 9 Keyboard Shortcuts, And Why I Don't Use Them. 00:02:03 Duration
Lecture 10 Why You Can't Get By With Just Recording Macr 00:10:53 Duration

Section 22 : The Building Blocks Of Coding...Your Dictionary

Lecture 1 Introduction To The Coding Section 00:05:36 Duration
Lecture 2 Getting All The Code For This Section 00:05:58 Duration
Lecture 3 Changing Your VBE Settings 00:02:47 Duration
Lecture 4 Protecting Your Code 00:02:11 Duration
Lecture 5 Objects, Methods And Properties 00:06:27 Duration
Lecture 6 Understanding The Hierarchy 00:03:37 Duration
Lecture 7 The Range Object 00:03:04 Duration
Lecture 8 The Cells Object 00:02:43 Duration
Lecture 9 The ActiveCell Property 00:02:15 Duration
Lecture 10 The Offset Property 00:02:18 Duration
Lecture 11 The End Property 00:02:50 Duration
Lecture 12 Dynamic Range Selection 00:02:33 Duration
Lecture 13 The CurrentRegion Property 00:02:05 Duration
Lecture 14 ACTIVATE vs. SELECT 00:01:43 Duration
Lecture 15 Between The Sheets 00:02:40 Duration
Lecture 16 Calling A Sheet By Its VB Name 00:02:55 Duration
Lecture 17 Sheets Vs. Worksheets 00:02:02 Duration
Lecture 18 Getting Around The Workbooks
Lecture 19 The Value Property - Writing Data 00:05:26 Duration
Lecture 20 The Value Property - Reading And Writing Data 00:02:35 Duration
Lecture 21 Copy And Paste 00:02:58 Duration
Lecture 22 Commonly Used Properties
Lecture 23 CODING EXERCISE The Rainbow 00:02:21 Duration
Lecture 24 The Address Property 00:04:04 Duration
Lecture 25 The Row and Column Properties 00:01:35 Duration
Lecture 26 Capturing The Column Letter 00:02:01 Duration
Lecture 27 More Useful Properties 00:03:06 Duration
Lecture 28 Even More Useful Properties 00:02:55 Duration
Lecture 29 Opening Another Workbook Programmatically 00:06:20 Duration
Lecture 30 Closing Workbooks Programmatically 00:03:41 Duration
Lecture 31 CODING EXERCISE OpenWriteClose 00:03:41 Duration

Section 23 : The Programmers Toolbox...The Techie Stuff, Made

Lecture 1 Introduction To The Programmers Toolbox 00:00:50 Duration
Lecture 2 Variables - Local Variables 00:06:46 Duration
Lecture 3 Variables - Local Variables With A Twist 00:03:40 Duration
Lecture 4 Variables - Module Level Variables 00:03:43 Duration
Lecture 5 Variables - Project Level Variables 00:03:02 Duration
Lecture 6 Bonus - Calling A Sub Stored In A DIFFERENT 00:04:18 Duration
Lecture 7 A Neat Trick To Force Variable Declaration 00:01:10 Duration
Lecture 8 Variables - All The Techie Bits 00:09:12 Duration
Lecture 9 An Introduction To Looping 00:01:07 Duration
Lecture 10 Looping With Do...Loop 00:05:02 Duration
Lecture 11 Looping With For...Next 00:02:34 Duration
Lecture 12 Looping With A Stepped For...Next 00:02:02 Duration
Lecture 13 Looping With While...Wend 00:07:11 Duration
Lecture 14 An Introduction To Logical Testing 00:01:41 Duration
Lecture 15 Logical Testing - A Simple If Test 00:06:43 Duration
Lecture 16 Logical Testing - A Simple If Test Using Cell 00:05:12 Duration
Lecture 17 Logical Testing - If Then Else 00:03:17 Duration
Lecture 18 Logical Testing - If Then Else Using Cells 00:03:41 Duration
Lecture 19 Logical Testing - Testing Multiple Criteria 00:03:33 Duration
Lecture 20 Logical Testing - Testing If One Is True, And 00:02:19 Duration
Lecture 21 Logical Testing - Testing If Either Value Is 00:03:22 Duration
Lecture 22 Logical Testing - Select Case 00:06:16 Duration
Lecture 23 Maths - Doing Simple Maths In Code 00:02:43 Duration
Lecture 24 Maths - Writing Formulas To Single Cells 00:06:57 Duration
Lecture 25 Maths - Writing Formulas To Ranges Of Cells 00:05:20 Duration
Lecture 26 Maths - Using Excel's Built-in Functions 00:03:56 Duration
Lecture 27 Maths - Built-in Functions With Defined Range 00:03:25 Duration
Lecture 28 InputBox - Getting User Input Using The Input 00:05:29 Duration
Lecture 29 Manipulating The User Input With Casing 00:05:55 Duration
Lecture 30 InputBox - Getting User Input Using The Input 00:05:55 Duration
Lecture 31 Message Boxes - Simple Message Boxes 00:04:06 Duration
Lecture 32 Message Boxes - Testing Which Button Was Pre 00:04:47 Duration
Lecture 33 Arrays - An Introduction 00:02:38 Duration
Lecture 34 Arrays - A Simple One Dimensional Dynamic Ar 00:04:44 Duration
Lecture 35 Arrays - A Simple One Dimensional Static Arra 00:05:56 Duration
Lecture 36 Arrays - A Simple Two Dimensional Static Arra 00:05:33 Duration
Lecture 37 Arrays - Extracting Useful Data Based On User 00:07:42 Duration
Lecture 38 Arrays - The Most Efficient Way To Capture An 00:04:55 Duration
Lecture 39 Arrays - Using An Array As A Data Source For 00:02:56 Duration

Section 24 : Automating All Your Reports!

Lecture 1 Introduction To Report Automation Section 00:02:29 Duration
Lecture 2 A Special Note For Office 2010 Users 00:01:20 Duration
Lecture 3 Recording The Bones Of The Code 00:04:25 Duration
Lecture 4 Streamlining The Add New Sheet Code 00:06:12 Duration
Lecture 5 Deconstructing The Profit By Day Code 00:02:09 Duration
Lecture 6 Building Source Data Strings Dynamically At R 00:07:53 Duration
Lecture 7 Creating The Run Order and Data Capture Subs. 00:03:48 Duration
Lecture 8 Solving That Naming Problem 00:03:04 Duration
Lecture 9 POWER USER - Sizing Your Charts Precisely 00:03:17 Duration
Lecture 10 Changing The Chart Title (And Why We Do It Se 00:02:38 Duration
Lecture 11 Deconstructing The Pivot Tables (It's Slightl 00:07:36 Duration
Lecture 12 Titles, Money And Sorting 00:04:46 Duration
Lecture 13 Butchering One Table, To Create Another 00:04:33 Duration
Lecture 14 Adding The Commentary - Building Strings Dyna 00:07:31 Duration
Lecture 15 Adding The Commentary Using Data From The Sh 00:03:57 Duration
Lecture 16 POWER USER - How DO You Make Specific Words B 00:04:37 Duration
Lecture 17 POWER USER - INSTR...A Very Useful Function 00:05:03 Duration
Lecture 18 INSTR And Paying Attention To Detail 00:02:54 Duration
Lecture 19 Tidy Up The Title 00:03:01 Duration
Lecture 20 Easy As Pie (Chart) 00:05:53 Duration
Lecture 21 Prettying Up Our Pie Chart 00:02:50 Duration
Lecture 22 Putting It All Together 00:04:50 Duration

Section 25 : The Data Is Out There...On The Internet, That Is

Lecture 1 Introduction To Web Query Section 00:01:38 Duration
Lecture 2 Pulling Data From The Internet - Capturing Th 00:04:03 Duration
Lecture 3 Getting To Cancun And London From Rome 00:06:00 Duration
Lecture 4 Data Clean Up 00:04:11 Duration
Lecture 5 A Simple Find And Replace 00:02:07 Duration
Lecture 6 Getting Our Formulas Right 00:03:52 Duration
Lecture 7 Streamlining The Formulas Code 00:03:07 Duration
Lecture 8 POWER USER - Displaying Messages In The Statu 00:04:17 Duration
Lecture 9 Putting It All Together 00:01:55 Duration

Section 26 : Workbook Events You Don't Have To Run Code To Have Code Run!

Lecture 1 Intro To The Events Section 00:02:06 Duration
Lecture 2 WorkBook SheetActivate 00:04:09 Duration
Lecture 3 WorkBook BeforePrint 00:02:48 Duration
Lecture 4 WorkBook SheetChange 00:01:14 Duration
Lecture 5 WorkBook Open - Creating An Auto-Back Up 00:05:17 Duration
Lecture 6 WorkBook Open - Creating A Splash Screen 00:03:55 Duration
Lecture 7 WorkBook Open - Calling Other Code 00:05:41 Duration
Lecture 8 WorkBook BeforeClose 00:03:09 Duration
Lecture 9 WorkSheet Activate - You Can't Pick This! 00:01:44 Duration
Lecture 10 WorkSheet Activate - You Might Pick This! 00:02:45 Duration
Lecture 11 WorkSheet Change 00:02:32 Duration
Lecture 12 WorkSheet Change - A More Useful Use 00:04:58 Duration
Lecture 13 WorkSheet Activate - Top Secret Classified In 00:03:31 Duration
Lecture 14 WorkSheet Events - BONUS - 4 New Things To Tr 00:08:34 Duration

Section 27 : User Defined Functions...What To Do If The Function You Need

Lecture 1 User Defined Functions...What They Are, And H 00:05:40 Duration
Lecture 2 Using A UDF To Return Information 00:01:41 Duration
Lecture 3 Creating A Countdown Timer With A UDF 00:08:31 Duration
Lecture 4 A Custom UDF For Calculating Volume Discount. 00:04:08 Duration
Lecture 5 A UDF For Getting All Your Sheet Names 00:03:05 Duration
Lecture 6 Calling A UDF From A Different Workbook 00:01:48 Duration
Lecture 7 The SuperCountIf And SuperSumIf UDF's 00:09:32 Duration

Section 28 : Bonus Section Controlling Windows - Folder Creation Gizmo

Lecture 1 Intro To Folder Creation Gizmo 00:02:24 Duration
Lecture 2 Creating A New Folder With A Single Line Of C 00:00:55 Duration
Lecture 3 A Single Level Folder Structure 00:05:27 Duration
Lecture 4 Folders Within Folders 00:05:36 Duration

Section 29 : Bonus Section eMail Automation...Why WRITE emails!

Lecture 1 Intro To The Emailing Section 00:02:53 Duration
Lecture 2 Understanding The eMail Routine 00:04:57 Duration
Lecture 3 Deconstructing How We Capture All The Data 00:10:15 Duration
Lecture 4 The eMail Loop 00:05:06 Duration

Section 30 : Bonus Section Word Automation - Controlling Word From Excel

Lecture 1 Intro To The Word Section 00:00:45 Duration
Lecture 2 Understanding The Word Routine 00:02:18 Duration
Lecture 3 Deconstructing How We Capture All The Data 00:03:02 Duration
Lecture 4 Formula Modifications With Unique Values 00:03:19 Duration
Lecture 5 Efficient Sorting 00:02:56 Duration
Lecture 6 Building The Text And Wrap Up 00:05:17 Duration

Section 31 : Bonus Section PowerPoint Automation - Create Your Presentati

Lecture 1 Intro To PowerPoint Section 00:01:12 Duration
Lecture 2 A Run Through The PowerPoint Base Code
Lecture 3 Setting Up The Shell Of The Code 00:03:14 Duration
Lecture 4 Who's Presenting This... 00:02:32 Duration
Lecture 5 Adding A Slide With A Logo And Text. 00:08:20 Duration
Lecture 6 Prettying Up The Formatting (More Lego Coding) 00:02:03 Duration
Lecture 7 Using Slide 1 To Create Slide 2 00:04:33 Duration
Lecture 8 Adding A Chart As A Picture 00:06:43 Duration
Lecture 9 Adding Pivot Tables (And Another Chart) 00:09:12 Duration
Lecture 10 Final Slide, And Wrap Up 00:02:12 Duration

Section 32 : Importing Specific Data From

Lecture 1 Intro To Importing Data From A Folder Full Of 00:03:26 Duration
Lecture 2 Looping Through All Excel Files In A Folder 00:03:56 Duration
Lecture 3 The Folder Picker 00:03:12 Duration
Lecture 4 A More Useful Loop Through Files 00:03:21 Duration
Lecture 5 The Data Grabber(er) 00:13:17 Duration

Section 33 : Student Questions Answered

Lecture 1 Get rid of rows in a array 00:05:49 Duration
Lecture 2 Emailing Routine Adding a Specific Attachment 00:03:34 Duration
Lecture 3 Adding A Date Stamp, And Going To The Inserti 00:07:26 Duration
Lecture 4 Saving An Individual Sheet To A Specific Fold 00:11:42 Duration
Lecture 5 Saving Multiple Sheets To A Single Workbook In A S 00:27:30 Duration
Lecture 6 Animated Charts...With A Little Something Ext 00:06:23 Duration
Lecture 7 Extracting Specific Data From A Big File, To 00:07:25 Duration
Lecture 8 Finding A Search String in Another Workbook W 00:04:55 Duration
Lecture 9 330. Extracting Unique Tables to Unique Sheets Fro 00:13:06 Duration
Lecture 10 Protecting Specific Cells and Data Validation 00:11:35 Duration
Lecture 11 Dynamically Populating A Reusable Array While 00:05:24 Duration
Lecture 12 Sequential PDF Creation With Pictures 00:17:02 Duration
Lecture 13 File Picker, And Report Generator With Intell 00:13:10 Duration
Lecture 14 Help! My File Has Got HUGE! 00:07:27 Duration
Lecture 15 Finding Updated Values In One Workbook, And A 00:09:10 Duration
Lecture 16 Gantt Charts...With A Little More Sophisticat 00:10:31 Duration
Lecture 17 Vlookups (Or Any Application.WorksheetFunctio 00:12:21 Duration
Lecture 18 Adding A Date Stamp If A Change Has Been Made 00:05:36 Duration

Section 34 : Thank You - Your Special Bonus!

Lecture 1 Get Your Next Course Now! 00:01:13 Duration