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