Learn to program
What does the course cover?
The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
Why take this course?
If you are performing repeated actions on workbooks or sheets, it may be possible to automate that work. Importing data, cleaning that data, archiving existing information and similar activities are good candidates for automation in Excel. VBA provides extra options for developers looking to automate Excel.
Who should attend?
Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.
Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.
Course detail and sample lessons
Section 1: Introduction
Lesson 3: Recording A Macro
Lesson 4: Reviewing Macro Code
Lesson 5: Introduction to Excel
Lesson 6: Objects, Methods And Properties
Lesson 7: Differences Between Office 2003, 2007, 2010 And 2013
Lesson 8: Creating A Macro Enabled Workbook
Section 2: Macro Recorder Part 1
Lesson 2: Recording A Macro To Format Cells
Lesson 3: Recording A Macro To Format Cells As Currency
Lesson 4: Recording A Macro To Swap Two Columns
Lesson 5: Recording A Macro Using Relative References Rather Than Absolute
Lesson 6: Recording A Macro To Turn Gridlines On And Off
Lesson 7: Tweaking Macros To Change Their Functionality
Section 3: Macro Recorder Part 2, A Larger Example
Lesson 2: Some Useful Functionality In Excel For Cell Selection
Lesson 3: Importing A Text File
Lesson 4: Filling Blank Cells With Data
Lesson 5: Adding A Column With The Date
Lesson 6: Creating A Pivot
Lesson 7: Creating A Chart
Lesson 8: Deleting Sheets And Charts
Lesson 9: Putting Them All Together
Section 4: Forms
Lesson 2: Creating A Simple Switchboard Form To Call Our Previous Macros
Lesson 3: Adding A Button To The Ribbon To Display The Form
Lesson 4: Using The Auto Open Events To Display The Form
Lesson 5: The Name List Form, Dealing With Events
Lesson 6: Using String Functions To Manipulate Text
Lesson 7: Creating A Form To Interact With Data On A Sheet
Section 5: Loops
Lesson 2: Looping Through Data In A Column With The For Loop
Lesson 4: Using ‘Cells’ To Access A Cell
Lesson 5: Looping Through Variable Length Lists
Lesson 6: Looping Through Data In A Column With Spaces
Lesson 7: Calling Formula To Determine When To Stop A Loop
Lesson 8: Creating Reusable VBA Code
Lesson 9: Finding And Formatting Data Using Loops
Section 6: User Defined Functions
Lesson 2: Creating A User Defined Function (UDF)
Lesson 3: Creating A Variable Discount Calculation UDF
Lesson 4: Error Handling In VBA
Lesson 5: Debugging In VBA
Section 7: Automation
Lesson 2: Automating Word From Excel
Lesson 3: Automating Powerpoint From Excel
Lesson 4: Automating Outlook From Excel
Lesson 5: Getting Data From Access Into Excel Using VBA
Section 8: Security
Lesson 2: Personal Macro Workbook
Lesson 3: Macro Security Levels
Lesson 4: Using A Digital Signature
Section 9: VBA Language Review
Lesson 1: VBA Language Review
Skills you’ll learn
What you’ll be able to do after the course
- Record and edit a macro’s VBA code
- Understand object oriented structure of Excel
- Creating custom forms in Excel
- Macro security and protection of macro code
- Foundations of programming using VBA
- Pump data from databases, CSV files and similar
- Cleanup imported data to remove extra spaces and lines
How you can apply these skills
What you’ll be able to use these skills for
- Create a custom menu structure for Excel users
- Simplify repetitive tasks using Macros and VBA code
- Edit and update existing Excel Macros
- Print specific separate areas of a workbook
- Create custom menu structures and fill-in forms in Excel
- Creating your own functions in Excel
- Export data into other Office applications
When you pass that you will receive an internationally recognised accreditation certificate like this:
Upon completion, you can move onto Excel Level 2, then 3. After you have completed the 3 levels you will be ready to take the Expert or Specialist courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.
Careers that require these skills at this level?
Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.
Want to start learning today?
Joining is simple, easy and risk free with our 7 day money back guarantee. Or sign up for our 7 Day free trial.