Name: Microsoft Excel Essentials: Level Three
Price: 199 USD

About This Course

Excel is the most commonly used and in demand tool for making sense of data. When you can harness that power, you will become a more valuable employee. If you run a business, being proficient in Excel can help you see your business in a completely different light. If you want to fully harness the power of Excel, then learning how to program in VBA – Visual Basic for Applications, is essential.

This course is if you want to join the Excel Elite, and program your own solutions, if you want to automate most of your work, do more in less time with less effort, if you want to earn more money and you may even fancy a career change.

In this course you will learn everything you need to know about coding in Visual Basic for Applications (VBA), why Visual Basic for Applications (VBA) is the powerhouse which is the engine that lives under the hood where all the magic can happen, the step-by-step process, methods that build powerful solutions easily and quickly, how to streamline your code for efficiency that will give you confidence to program your own solution.

Our Promise to You

By the end of this course, you will have learned Visual Basic for Applications in Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about coding in Visual Basics for applications in Excel.

Course Curriculum

Section 1 - What Is It All About
	Why Should I Learn How To Code?	00:00:00
	The Fifteen Golden Rules Of Coding	00:00:00
	Downloadable Materials	00:00:00
Section 2 – Introducing Your Personal Built In Translator - The Macro Recorder
	Introducing The Visual Basic Editor And Recording Our First Macro	00:00:00
	Saving Macro-Enabled Workbooks And Security Settings	00:00:00
	Moving Code Around	00:00:00
	Stepping Out. Well, In Actually – Debugging Made Easy	00:00:00
	With And End With	00:00:00
	Streamlining You Code Or Get Rid Of What You Don’t Need	00:00:00
	Combining Your Code	00:00:00
	A Little Privacy Please	00:00:00
	Keyboard Shortcuts And Why I Don’t Use Them	00:00:00
	Why You Can’t Get By With Just Recording Macros	00:00:00
Section 3 - The Building Blocks Of Coding: Your Dictionary And Phrase Book Of Success
	Introduction To The Coding Section	00:00:00
	Getting All The Code For This Section	00:00:00
	Changing Your VBE Settings	00:00:00
	Protecting Your Code	00:00:00
	Objects, Methods And Properties	00:00:00
	Understanding The Hierarchy	00:00:00
	The Range Object	00:00:00
	The Cells Object	00:00:00
	The Active Cell Property	00:00:00
	The Offset Property	00:00:00
	The End Property	00:00:00
	Dynamic Range Selection	00:00:00
	The Current Region Property	00:00:00
	Activate Vs. Select	00:00:00
	Between The Sheets	00:00:00
	Calling A Sheet By Its VB Name	00:00:00
	Sheets Vs. Worksheets	00:00:00
	Getting Around The Workbooks	00:00:00
	The Value Property – Writing Data	00:00:00
	The Value Property – Reading And Writing Data	00:00:00
	Copy And Paste	00:00:00
	Commonly Used Properties	00:00:00
	Coding Exercise: The Rainbow	00:00:00
	The Address Property	00:00:00
	The Row And Column Properties	00:00:00
	Capturing The Column Letter	00:00:00
	More Useful Properties	00:00:00
	Even More Useful Properties	00:00:00
	Opening Another Workbook Programmatically	00:00:00
	Closing Workbooks Programmatically	00:00:00
	Coding Exercise: Open/Write/Close	00:00:00
Section 4 - The Programmers Toolbox: The Techie Stuff, Made Easy
	Introduction To The Programmers Toolbox	00:00:00
	Variables – Local Variables	00:00:00
	Variables – Local Variables With A Twist	00:00:00
	Variables – Module Level Variables	00:00:00
	Variables – Project Level Variables	00:00:00
	Bonus – Calling A Sub Stored In A Different Workbook	00:00:00
	A Neat Trick To Force Variable Declaration	00:00:00
	Variables – All The Techie Bits	00:00:00
	An Introduction To Looping	00:00:00
	Looping With Do Loop	00:00:00
	Looping With For Next	00:00:00
	Looping With A Stepped For Next	00:00:00
	Looping With While Wend	00:00:00
	An Introduction To Logical Testing	00:00:00
	Logical Testing – A Simple If Test	00:00:00
	Logical Testing – A Simple If Test Using Cells	00:00:00
	Logical Testing – If Then Else	00:00:00
	Logical Testing – If Then Else Using Cells	00:00:00
	Logical Testing – Testing Multiple Criteria	00:00:00
	Logical Testing – Testing If One Is True And One Is False	00:00:00
	Logical Testing – Testing If Either Value Is True	00:00:00
	Logical Testing – Select Case	00:00:00
	Maths – Doing Simple Maths In Code	00:00:00
	Maths – Writing Formulas To Single Cells	00:00:00
	Maths – Writing Formulas To Ranges Of Cells	00:00:00
	Maths – Using Excel’s Built-In Functions	00:00:00
	Maths – Built-In Functions With Defined Ranges	00:00:00
	InputBox – Getting User Input Using The InputBox Function	00:00:00
	Manipulating The User Input With Casing	00:00:00
	InputBox – Getting User Input Using The InputBox Method	00:00:00
	Message Boxes – Simple Message Boxes	00:00:00
	Message Boxes – Testing Which Button Was Pressed	00:00:00
	Arrays – An Introduction	00:00:00
	Arrays – A Simple One Dimensional Static Array	00:00:00
	Arrays – A Simple One Dimensional Dynamic Array	00:00:00
	Arrays – A Simple Two Dimensional Static Array	00:00:00
	Arrays – The Most Efficient Way To Capture An Array	00:00:00
	Arrays – Extracting Useful Data Based On User Input	00:00:00
	Arrays – Using An Array As A Data Source For A VLookup	00:00:00
Section 5 - Automating All Your Reports
	Introduction To Report Automation Section	00:00:00
	A Special Note For Office 2010 Users	00:00:00
	Recording The Bones Of The Code	00:00:00
	Streamlining The “Add New Sheet Code”	00:00:00
	Deconstructing The “Profit By Day” Code	00:00:00
	Building Source Data Strings Dynamically At Runtime	00:00:00
	Creating The Run Order and Data Capture Subs	00:00:00
	Solving That Naming Problem	00:00:00
	Power User – Sizing Your Charts Precisely	00:00:00
	Changing The Chart Title (And Why We Do It Separately)	00:00:00
	Deconstructing The Pivot Tables (It’s Slightly Different)	00:00:00
	Titles, Money And Sorting	00:00:00
	Butchering One Table, To Create Another	00:00:00
	Adding The Commentary – Building Strings Dynamically At Runtime	00:00:00
	Adding The Commentary Using Data From The Sheet We’re On	00:00:00
	Power User – How Do You Make Specific Words Bold	00:00:00
	Power User – Instr: A Very Useful Function	00:00:00
	Instr And Paying Attention To Detail	00:00:00
	Tidy Up The Title	00:00:00
	Easy As Pie (Chart)	00:00:00
	Prettying Up Our Pie Chart	00:00:00
	Putting It All Together	00:00:00
Section 6 - The Data Is Out There On The Internet, That Is
	Introduction To Web Query Section	00:00:00
	Pulling Data From The Internet – Capturing The Data For Rome	00:00:00
	Getting To Cancun And London From Rome	00:00:00
	Data Clean Up	00:00:00
	A Simple Find And Replace	00:00:00
	Getting Our Formulas Right	00:00:00
	Streamlining The Formulas Code	00:00:00
	Power User – Displaying Messages In The Status Bar (Cool)	00:00:00
	Putting It All Together	00:00:00
Section 7 - Workbook Events: You Don't Have To Run Code To Have Code Run
	Introduction To The Events Section	00:00:00
	Work Book Sheet Activate	00:00:00
	Work Book Before Print	00:00:00
	Work Book Sheet Change	00:00:00
	Work Book Open – Creating An Auto-Back Up	00:00:00
	Work Book Open – Creating A Splash Screen	00:00:00
	Work Book Open – Calling Other Code	00:00:00
	Work Book Before Close	00:00:00
	Work Sheet Activate – You Can’t Pick This	00:00:00
	Work Sheet Activate – You Might Pick This	00:00:00
	Work Sheet Change	00:00:00
	Work Sheet Change – A More Useful Use	00:00:00
	Work Sheet Activate – Top Secret Classified Information	00:00:00
	Work Sheet Events: Bonus – Four New Things To Try	00:00:00
Section 8 - User Defined Functions: What To Do If The Function You Need Isn't In Excel
	User Defined Functions: What They Are And How You Make Them	00:00:00
	Using A User Defined Functions To Return Information	00:00:00
	Creating A Countdown Timer With A User Defined Functions	00:00:00
	A Custom User Defined Functions For Calculating Volume Discount	00:00:00
	A User Defined Functions For Getting All Your Sheet Names	00:00:00
	Calling A User Defined Functions From A Different Workbook	00:00:00
	The Super CountIf And SuperSumIf User Defined Functions	00:00:00
Section 9 - Bonus Section: Controlling Windows - Folder Creation Gizmo
	Introduction To Folder Creation Gizmo	00:00:00
	Creating A New Folder With A Single Line Of Code	00:00:00
	A Single Level Folder Structure	00:00:00
	Folders Within Folders	00:00:00
Section 10 - Bonus Section: E-Mail Automation: Why Write Emails
	Introduction To The Emailing Section	00:00:00
	Understanding The E-Mail Routine	00:00:00
	Deconstructing How We Capture All The Data	00:00:00
	The E-Mail Loop	00:00:00
Section 11 - Bonus Section: Word Automation - Controlling Word From Excel
	Introduction To The Word Section	00:00:00
	Understanding The Word Routine	00:00:00
	Deconstructing How We Capture All The Data	00:00:00
	Formula Modifications With Unique Values	00:00:00
	Efficient Sorting	00:00:00
	Building The Text And Wrap Up	00:00:00
Section 12 - Bonus Section: PowerPoint Automation - Create Your Presentation In Seconds
	Introduction To PowerPoint Section	00:00:00
	A Run Through The PowerPoint Base Code	00:00:00
	Setting Up The Shell Of The Code	00:00:00
	Who’s Presenting This	00:00:00
	Adding A Slide With A Logo And Text	00:00:00
	Prettying Up The Formatting (More Lego Coding)	00:00:00
	Using Slide One To Create Slide Two	00:00:00
	Adding A Chart As A Picture	00:00:00
	Adding Pivot Tables (And Another Chart)	00:00:00
	Final Slide, And Wrap Up	00:00:00
Section 13 - Importing Specific Data From Multiple Files
	Introduction To Importing Data From A Folder Full Of Files	00:00:00
	Looping Through All Excel Files In A Folder	00:00:00
	The Folder Picker	00:00:00
	A More Useful Loop Through Files	00:00:00
	The Data Grabber	00:00:00
Section 14 - Student Questions Answered
	Get Rid Of Rows In An Array	00:00:00
	Emailing Routine: Adding A Specific Attachment Based On A Criteria	00:00:00
	Adding A Date Stamp And Going To The Insertion Point Automatically	00:00:00
	Saving An Individual Sheet To A Specific Folder	00:00:00
	Saving Multiple Sheets To A Single Workbook In A Specific Folder	00:00:00
	Animated Charts With A Little Something Extra	00:00:00
	Extracting Specific Data From A Big File To A Bunch Of Little Ones	00:00:00
	Finding A Search String In Another Workbook With Multiple Sheets	00:00:00
	Extracting Unique Tables To Unique Sheets From A Big Data Set	00:00:00
	Protecting Specific Cells And Data Validation	00:00:00
	Dynamically Populating A Reusable Array While Looping Through A Table	00:00:00
	Sequential PDF Creation With Pictures	00:00:00
	File Picker And Report Generator With Intelligent Filing	00:00:00
	Help: My File Has Got Huge	00:00:00
	Finding Updated Values In One Workbook, And Adding Them To Another Workbook	00:00:00
	Gantt Charts With A Little More Sophistication	00:00:00
	VLookups (Or Any Application Worksheet Function) Over Ranges	00:00:00
	Adding A Date Stamp If A Change Has Been Made	00:00:00