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

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

#### Section 2 : An Introduction To Level 1

 Lecture 3 About Proctor Testing Pdf

#### Section 3 : . Start Here - All The Basics

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

#### Section 4 : Doing The (Simple) Math

 Lecture 21 Sums - The Old Fashioned Way! 3:11 Lecture 22 Sums - Using Autosum 5:33 Lecture 23 Copying Formulas 3:17 Lecture 24 SUMming Horizontally 3:17 Lecture 25 Basic Formulas - Subtraction. 2:28 Lecture 26 Basic Formulas - Multiplication 1:33 Lecture 27 Basic Formulas - Division 1:22 Lecture 28 Average Function 2:41 Lecture 29 The Order Of Mathematical Operation Lecture 30 POWER USER - Evaluate Formula 4:51

#### Section 5 : Rearranging Things

 Lecture 31 Inserting New Columns And Rows 6:21 Lecture 32 Moving Existing Columns And Rows 2:27 Lecture 33 Cutting, Copying, Inserting And Deleting 6:7 Lecture 34 Hiding Columns And Rows 2:41

#### Section 6 : Formulas Learning The Clever Stuff!

 Lecture 35 Rounding Functions 5:55 Lecture 36 Formatting Numbers 2:12 Lecture 37 A Primer In Building Complex Formulas 3:10 Lecture 38 Buliding a Compex Formula 4:20

#### Section 7 : A Few More Essentials

 Lecture 39 Sorting 4:16 Lecture 40 Wrapping Text And Soft Enter 4:0 Lecture 41 Adding A New Worksheet 1:8 Lecture 42 Creating A Simple Chart. 4:21 Lecture 43 Adding Borders 2:36 Lecture 44 Customizing the Quick Access Toolbar 2:11 Lecture 45 Simple Printing 3:34 Lecture 46 Freezing For An Easier View 4:7 Lecture 47 Getting Help 1:39 Lecture 48 Filters 6:22 Lecture 49 Highlighting Cells 2:4 Lecture 50 Closing 1:30

#### Section 8 : Bonus Section - The Keyboard Shortcuts

 Lecture 51 Bonus 1 Whizzing Around Excel 6:46 Lecture 52 Bonus 2 Keyboard Shortcuts 11:18

#### Section 9 : Bonus Section Absolute and Relative Cell References

 Lecture 53 A1 Style - Relative Relative 2:16 Lecture 54 \$A\$1 Style - Absolute Absolute 2:44 Lecture 55 \$A1 Style - Absolute Relative 2:16 Lecture 56 A\$1 Style - Relative Absolute 2:1

#### Section 10 : Bonus Section Student Questions Answered!

 Lecture 57 Reverse Engineering A Sample Spreadsheet 20:56 Lecture 58 Casing And Text Functions 20:56 Lecture 59 Level 1 SQA 03 - Charts From A Filtered List 2:54

#### Section 11 : Excel Essentials Level 2 - IntermediateAdvanced

 Lecture 60 Intro To Level 1:58

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

 Lecture 61 Proof Of Concept 4:50 Lecture 62 Planning Ahead 6:2 Lecture 63 Creating Our Data Entry Screen 4:8 Lecture 64 (Custom) Formatting Dates And Time 4:8 Lecture 65 Simple Calculations With Time 2:36 Lecture 66 More (Useful) Calculations With Time 8:7 Lecture 67 It's About Time (And Dates! 8:28 Lecture 68 Adding Time 3:40 Lecture 69 Creating A Template From An Image. 11:35 Lecture 70 Importing A Template From An Existing Excel File. 2:22 Lecture 71 Converting Time To A Decimal 5:42 Lecture 72 A Little Bit Of Simple Data Entry 3:12 Lecture 73 Simple Conditional Formatting For A Cleaner View 4:43 Lecture 74 Calculating Time Out Of House Using Travel Time 4:47 Lecture 75 Simple Logical Testing And Nested Logical Testing 8:29 Lecture 76 Building Text Strings With A Formula 12:10 Lecture 77 Before We Move On...Accessing The Developer Ribbon 1:5 Lecture 78 A Tick Box Exercise (Of Sorts) 7:11 Lecture 79 populating Check Boxes 11:49 Lecture 80 Radio Buttons as an Alternative to Check Boxes 13:26 Lecture 81 PRACTICE EXERCISE 1 - Time To Add A New Entry 1:40 Lecture 82 Defining A Working Area, And Protecting Your Work 4:41 Lecture 83 PRACTICE EXERCISE 2 - Set Up A Working Area 1:7

#### Section 13 : Project 2 - Building A Database With Excel

 Lecture 84 Simple VLOOKUP 4:17 Lecture 85 Get Some Data In, And Split It 3:54 Lecture 86 Using Data Validation To Get The Right Input 3:47 Lecture 87 Let's Build Our Database 6:12 Lecture 88 Importing Data From A Text File 2:2 Lecture 89 Importing Data From A Word File 2:37 Lecture 90 Pulling Data From Multiple Sources 3:33 Lecture 91 Using OTHER Look-Ups To Look Up 5:25 Lecture 92 LOOKUP From A LOOKUP With No Intermediary Step 2:20 Lecture 93 Data Arrays Don't Have To Start At A 2:58 Lecture 94 ome Common Reasons VLook-Ups Fail 6:2 Lecture 95 One Inherent Flaw In Vlook Up 1:11 lecture 96 POWER USER - A Breakdown Of Looking Up Backwar 6:44 lecture 97 The Other Way Of Looking Up Backwards 6:49 lecture 98 Backwards Look-Ups In Action 3:47 lecture 99 POWER USER - Dealing With Inconsistencies In U 8:19 lecture 100 POWER USER - Fuzzy Vlook-Ups 3:33 lecture 101 POWER USER - Vlook-Ups With Multiple Inputs 9:39 lecture 102 POWER USER - Looking Up Multiple Inputs Using 4:45 lecture 103 VLOOKUPs Brother...HLOOKUP 5:5 lecture 104 POWER USER - The Holy Grail - How To Return 13:34 lecture 105 What To Look For When THAT Formula Didn't Wor 4:6 lecture 106 The Fastest Way To Modify Your Column Numbers 7:25 lecture 107 POWER USER - Vlook-Ups With Moving Columns 3:6 lecture 108 Putting It All Together 9:53 lecture 109 The Finishing Touch - How Many Records Did I 4:28

#### Section 14 : Project 3 - Named Ranges

 lecture 110 A Simple Static Named Range Using A Single Ce 3:44 lecture 111 Creating A Named Range Using A Range Of Cells 2:54 lecture 112 Using Row Labels To Name Multiple Ranges 2:34 lecture 113 POWER USER - A Magic Trick Using Row And Colu 4:55 lecture 114 POWER USER - Dynamic Named Ranges 8:7 lecture 115 POWER USER - What To Do With Dynamic Names Ra 5:22 lecture 116 3035 - POWER USER - Dynamic Charts 10:28 lecture 117 3040 - Horizontal Dynamic Named Ranges For Ch 11:10

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

 lecture 118 Welcome to What Can I Have For Dinner or...Wh 1:25 lecture 119 Hyperlinking To A Different Sheet In The Same 3:33 lecture 120 Creating Our First Macro 5:37 lecture 121 Assigning A Macro To A Button 4:13 lecture 122 Creating A List For Our Dropdown Using A Dyna 1:40 lecture 123 Using A Conditional Format To Know When A Val 4:35 lecture 124 Copying Conditional Formats And Creating Our 2:50 lecture 125 Building Our Formula...INDIRECT Function 2:55 lecture 126 Building Strings For Indirect Sheet And Cell 7:17 lecture 127 It's A One Or A Zero 2:36 lecture 128 Working The Percentages And Adding Traffic Li 4:6 lecture 129 POWER USER - The HYPERLINK Function (And Prob 3:17 lecture 130 PRACTICE EXERCISE 1 - Fill In The Blanks 0:59 lecture 131 PRACTICE EXERCISE 2 - Pretty It Up (With A Ma 1:46 lecture 132 PRACTICE EXERCISE 3 - Create A VLOOKUP Using 2:13

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

 lecture 133 Creating A Gantt Chart Using A Worksheet 7:39 lecture 134 Building The First Part Of Our Logical Test lecture 135 Multiple Logical Tests At Once Using AND 8:28 lecture 136 Conditional Formatting...Where The Magic Happ 5:33 lecture 137 Gantt Charts Using The Built In Charting Tool 4:51 lecture 138 SQA - Gantt Charts With Different Colours For 7:47

#### Section 17 : Bonus Section - Just For Fun

 lecture 139 How I Created Randomly Generated License Plat 7:14

#### Section 18 : Student Questions Answered!

 lecture 140 Calls Text Data - Or How To Return a Column T 6:42 lecture 141 Calls Text Data 2 - This Time Using Text! 9:2 lecture 142 Extracting Phone Numbers From A Cell 2:40 lecture 143 What Is The CHOOSE Function Really Used For 14:48 lecture 144 Casing And Text Functions 6:35 lecture 145 Dynamic Charting From A Drop Down 10:3 lecture 146 Extracting a Unique List, And Summing The Mon 2:26 lecture 147 SUMIF With Dynamic Sum Range 5:55 lecture 148 Vlookups With Pictures! 4:30 Lecture 149 Data Validation With Dependent Drop-downs 3:42 lecture 150 Data Validation With Dependent Drop downs (Dy 8:31 lecture 151 Using 2 Labels As A Lookup From Drop-downs 6:47 lecture 152 Tiered Pricing - SUMming So Many At One Price 9:0 lecture 153 The Middle Name Problem, and Solution! 9:3 lecture 154 Finding Matches, And Counting Entries 8:6 lecture 155 Fee Calculator, or LOOKUPs That Are True, Not 5:43 lecture 156 The IF(s) Functions 6:1 lecture 157 Drop Down List, Shifting Ranges 6:7 lecture 158 Dynamic Calculations From Another Sheet 12:46

#### Section 19 : Excel Essentials Level 3 - VBA Programming

 lecture 159 Why Should I Learn How To Code 10:28

#### Section 20 : What's It All About, Alan

 lecture 160 The 15 Golden Rules Of Coding 6:24

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

 lecture 161 Introducing The Visual Basic Editor, & Record 11:10 lecture 162 Saving Macro-Enabled Workbooks, And Security 3:17 lecture 163 Moving Code Around 4:38 lecture 164 Stepping Out. Well, In Actually! - Debugging 5:51 lecture 165 With And End With 12:35 lecture 166 Streamlining You Code, Or, Get Rid Of What Yo 7:53 lecture 167 Combining Your Code 6:18 lecture 168 A Little Privacy Please 3:19 lecture 169 Keyboard Shortcuts, And Why I Don't Use Them. 2:3 lecture 170 Why You Can't Get By With Just Recording Macr 10:53

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

 lecture 171 Introduction To The Coding Section 5:36 lecture 172 Getting All The Code For This Section 5:58 lecture 173 Changing Your VBE Settings 2:47 lecture 174 Protecting Your Code 2:11 lecture 175 Objects, Methods And Properties 6:27 lecture 176 Understanding The Hierarchy 3:37 lecture 177 The Range Object 3:4 lecture 178 The Cells Object 2:43 lecture 179 The ActiveCell Property 2:15 lecture 180 The Offset Property 2:18 lecture 181 The End Property 2:50 lecture 182 Dynamic Range Selection 2:33 lecture 183 The CurrentRegion Property 2:5 lecture 184 ACTIVATE vs. SELECT 1:43 lecture 185 Between The Sheets 2:40 lecture 186 Calling A Sheet By Its VB Name 2:55 lecture 187 Sheets Vs. Worksheets 2:2 lecture 188 Getting Around The Workbooks lecture 189 The Value Property - Writing Data 5:26 lecture 190 The Value Property - Reading And Writing Data 2:35 lecture 191 Copy And Paste 2:58 lecture 192 Commonly Used Properties lecture 193 CODING EXERCISE The Rainbow 2:21 lecture 194 The Address Property 4:4 lecture 195 The Row and Column Properties 1:35 lecture 196 Capturing The Column Letter 2:1 lecture 197 More Useful Properties 3:6 lecture 198 Even More Useful Properties 2:55 lecture 199 Opening Another Workbook Programmatically 6:20 lecture 200 Closing Workbooks Programmatically 3:41 lecture 201 CODING EXERCISE OpenWriteClose 3:41

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

 lecture 202 Introduction To The Programmers Toolbox 0:50 lecture 203 Variables - Local Variables 6:46 lecture 204 Variables - Local Variables With A Twist 3:40 lecture 205 Variables - Module Level Variables 3:43 lecture 206 Variables - Project Level Variables 3:2 lecture 207 Bonus - Calling A Sub Stored In A DIFFERENT 4:18 lecture 208 A Neat Trick To Force Variable Declaration 1:10 lecture 209 Variables - All The Techie Bits 9:12 lecture 210 An Introduction To Looping 1:7 lecture 211 Looping With Do...Loop 5:2 lecture 212 Looping With For...Next 2:34 lecture 213 Looping With A Stepped For...Next 2:2 lecture 214 Looping With While...Wend 7:11 lecture 215 An Introduction To Logical Testing 1:41 lecture 216 Logical Testing - A Simple If Test 6:43 lecture 217 Logical Testing - A Simple If Test Using Cell 5:12 lecture 218 Logical Testing - If Then Else 3:17 lecture 219 Logical Testing - If Then Else Using Cells 3:41 lecture 220 Logical Testing - Testing Multiple Criteria 3:33 lecture 221 Logical Testing - Testing If One Is True, And 2:19 lecture 222 Logical Testing - Testing If Either Value Is 3:22 lecture 223 Logical Testing - Select Case 6:16 lecture 224 Maths - Doing Simple Maths In Code 2:43 lecture 225 Maths - Writing Formulas To Single Cells 6:57 lecture 226 Maths - Writing Formulas To Ranges Of Cells 5:20 lecture 227 Maths - Using Excel's Built-in Functions 3:56 lecture 228 Maths - Built-in Functions With Defined Range 3:25 lecture 229 InputBox - Getting User Input Using The Input 5:29 lecture 230 Manipulating The User Input With Casing 5:55 lecture 231 InputBox - Getting User Input Using The Input 5:55 lecture 332 Message Boxes - Simple Message Boxes 4:6 lecture 233 Message Boxes - Testing Which Button Was Pre 4:47 lecture 234 Arrays - An Introduction 2:38 lecture 235 Arrays - A Simple One Dimensional Dynamic Ar 4:44 lecture 236 Arrays - A Simple One Dimensional Static Arra 5:56 lecture 237 Arrays - A Simple Two Dimensional Static Arra 5:33 lecture 238 Arrays - Extracting Useful Data Based On User 7:42 lecture 239 Arrays - The Most Efficient Way To Capture An 4:55 lecture 240 Arrays - Using An Array As A Data Source For 2:56

#### Section 24 : Automating All Your Reports!

 lecture 241 Introduction To Report Automation Section 2:29 lecture 242 A Special Note For Office 2010 Users 1:20 lecture 243 Recording The Bones Of The Code 4:25 lecture 244 Streamlining The Add New Sheet Code 6:12 lecture 245 Deconstructing The Profit By Day Code 2:9 lecture 246 Building Source Data Strings Dynamically At R 7:53 lecture 247 Creating The Run Order and Data Capture Subs. 3:48 lecture 248 Solving That Naming Problem 3:4 lecture 249 POWER USER - Sizing Your Charts Precisely 3:17 lecture 250 Changing The Chart Title (And Why We Do It Se 2:38 lecture 251 Deconstructing The Pivot Tables (It's Slightl 7:36 lecture 252 Titles, Money And Sorting 4:46 lecture 253 Butchering One Table, To Create Another 4:33 lecture 254 Adding The Commentary - Building Strings Dyna 7:31 lecture 255 Adding The Commentary Using Data From The Sh 3:57 lecture 256 POWER USER - How DO You Make Specific Words B 4:37 lecture 257 POWER USER - INSTR...A Very Useful Function 5:3 lecture 258 INSTR And Paying Attention To Detail 2:54 lecture 259 Tidy Up The Title 3:1 lecture 260 Easy As Pie (Chart) 5:53 lecture 261 Prettying Up Our Pie Chart 2:50 lecture 262 Putting It All Together 4:50

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

 lecture 263 Introduction To Web Query Section 1:38 lecture 264 Pulling Data From The Internet - Capturing Th 4:3 lecture 265 Getting To Cancun And London From Rome 6:0 lecture 266 Data Clean Up 4:11 lecture 267 A Simple Find And Replace 2:7 lecture 268 Getting Our Formulas Right 3:52 lecture 269 Streamlining The Formulas Code 3:7 lecture 270 POWER USER - Displaying Messages In The Statu 4:17 lecture 271 Putting It All Together 1:55

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

 lecture 272 Intro To The Events Section 2:6 lecture 273 WorkBook SheetActivate 4:9 lecture 274 WorkBook BeforePrint 2:48 lecture 275 WorkBook SheetChange 1:14 lecture 276 WorkBook Open - Creating An Auto-Back Up 5:17 lecture 277 WorkBook Open - Creating A Splash Screen 3:55 lecture 278 WorkBook Open - Calling Other Code 5:41 lecture 279 WorkBook BeforeClose 3:9 lecture 280 WorkSheet Activate - You Can't Pick This! 1:44 lecture 281 WorkSheet Activate - You Might Pick This! 2:45 lecture 282 WorkSheet Change 2:32 lecture 283 WorkSheet Change - A More Useful Use 4:58 lecture 284 WorkSheet Activate - Top Secret Classified In 3:31 lecture 285 WorkSheet Events - BONUS - 4 New Things To Tr 8:34

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

 lecture 286 User Defined Functions...What They Are, And H 5:40 lecture 287 Using A UDF To Return Information 1:41 lecture 288 Creating A Countdown Timer With A UDF 8:31 lecture 289 A Custom UDF For Calculating Volume Discount. 4:8 lecture 290 A UDF For Getting All Your Sheet Names 3:5 lecture 291 Calling A UDF From A Different Workbook 1:48 lecture 292 The SuperCountIf And SuperSumIf UDF's 9:32

#### Section 28 : Bonus Section Controlling Windows - Folder Creation Gizmo

 lecture 293 Intro To Folder Creation Gizmo 2:24 lecture 294 Creating A New Folder With A Single Line Of C 0:55 lecture 395 A Single Level Folder Structure 5:27 lecture 296 Folders Within Folders 5:36

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

 lecture 297 Intro To The Emailing Section 2:53 lecture 298 Understanding The eMail Routine 4:57 lecture 299 Deconstructing How We Capture All The Data 10:15 lecture 300 The eMail Loop 5:6

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

 lecture 301 Intro To The Word Section 0:45 lecture 302 Understanding The Word Routine 2:18 lecture 303 Deconstructing How We Capture All The Data 3:2 lecture 304 Formula Modifications With Unique Values 3:19 lecture 305 Efficient Sorting 2:56 lecture 306 Building The Text And Wrap Up 5:17

#### Section 31 : Bonus Section PowerPoint Automation - Create Your Presentati

 lecture 307 Intro To PowerPoint Section 1:12 lecture 308 A Run Through The PowerPoint Base Code lecture 309 Setting Up The Shell Of The Code 3:14 lecture 310 Who's Presenting This... 2:32 lecture 311 Adding A Slide With A Logo And Text. 8:20 lecture 312 Prettying Up The Formatting (More Lego Coding) 2:3 lecture 313 Using Slide 1 To Create Slide 2 4:33 lecture 314 Adding A Chart As A Picture 6:43 lecture 315 Adding Pivot Tables (And Another Chart) 9:12 lecture 316 Final Slide, And Wrap Up 2:12

#### Section 32 : Importing Specific Data From

 lecture 317 Intro To Importing Data From A Folder Full Of 3:26 lecture 318 Looping Through All Excel Files In A Folder 3:56 lecture 319 The Folder Picker 3:12 lecture 320 A More Useful Loop Through Files 3:21 lecture 321 The Data Grabber(er) 13:17

#### Section 33 : Student Questions Answered

 lecture 322 Get rid of rows in a array 5:49 lecture 323 Emailing Routine Adding a Specific Attachment 3:34 lecture 324 Adding A Date Stamp, And Going To The Inserti 7:26 lecture 325 Saving An Individual Sheet To A Specific Fold 11:42 lecture 326 Saving Multiple Sheets To A Single Workbook In A S 27:30 lecture 327 Animated Charts...With A Little Something Ext 6:23 lecture 328 Extracting Specific Data From A Big File, To 7:25 lecture 329 Finding A Search String in Another Workbook W 4:55 lecture 330 330. Extracting Unique Tables to Unique Sheets Fro 13:6 lecture 331 Protecting Specific Cells and Data Validation 11:35 lecture 332 Dynamically Populating A Reusable Array While 5:24 lecture 333 Sequential PDF Creation With Pictures 17:2 lecture 334 File Picker, And Report Generator With Intell 13:10 lecture 335 Help! My File Has Got HUGE! 7:27 lecture 336 Finding Updated Values In One Workbook, And A 9:10 lecture 337 Gantt Charts...With A Little More Sophisticat 10:31 lecture 338 Vlookups (Or Any Application.WorksheetFunctio 12:21 lecture 339 Adding A Date Stamp If A Change Has Been Made 5:36

#### Section 34 : Thank You - Your Special Bonus!

 lecture 340 Get Your Next Course Now! 1:13