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
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
Section 13 : Project 2 - Building A Database With Excel
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
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!
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
Section 24 : Automating All Your Reports!
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
Section 34 : Thank You - Your Special Bonus!
|
Lecture 1 | Get Your Next Course Now! | 00:01:13 Duration |