Excel 2007 Macros

Excel VBA Course Duration: This is a 3 full day Excel 2007 Macros Course. Course starts at 09:00 and runs until 17:00, with a one hour break for lunch, and two short snack breaks.

Miminum Requirements: You must have good Excel skills and understand key concepts of spreadsheets, or equivalent. It is not necessary to have programming knowledge.

Intended Audience: This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel 2007 Macros and Visual Basic for Applications (VBA) programming language.

Excel 2007 VBA (Macro) Course Objectives:

After attending the VBA Macro Training course, you will be able to:

  • Learn How to Record, Build and Run Macros in Excel 2007
  • Write VBA Code Manually using Excel
  • Perform Loops, Controls and Error Handling
  • Create User forms and Sheet Controls in Excel
  • Use Events to trigger speciic VBA code

Detailed Outline for 3 Day Excel 2007 Macro Training

Lesson 1:

  • Make a Macro do Simple Tasks
  • Difference between VBA & Macro
  • Creating a Simple Macro
  • Changing Multiple Properties at Once
  • Manipulating Recorded Properties
  • Recording Methods in a Macro

Lesson2:

  • Make a Macro Do Complex Task
  • Opening the Report File
  • Filling in Missing Labels
  • Adding a Column of Dates
  • Appending to the Database
  • Deleting the Worksheet

Lesson3:

  • Explore Workbooks and Worksheets
  • Understanding Workbooks
  • Understanding Worksheets

Lesson 4:

  • Explore Range Objects

Lesson 5:

  • Explore Data Objects
  • Working with Excel Table
  • Working with Pivot Table Reports
Lesson6:

  • Explore Graphical Objects
  • Explore Chart Objects

Lesson 7:

  • Control Visual Basic
  • Creating Loops
  • Managing Large Loops

Lesson 8:

  • Extend Excel and Visual Basic
  • Creating Custom Functions
  • Handling Errors

Lesson 9:

  • Launch Macros with Events
  • Creating Custom Command buttons
  • Handling Worksheet and Workbook Events

Lesson 10:

  • Use Dialog Box Controls on a Worksheet
  • Using a loan Payment Calculator
  • Retrieving a Value from a list
  • Protecting the Worksheet

Lesson 11:

  • Create a Custom Form
  • Preparing a form’s functionality

 

Excel 2007 VBA (Macro) Course Objectives:

After attending the VBA Macro Training course, you will be able to:

  • Learn How to Record, Build and Run Macros in Excel 2007
  • Write VBA Code Manually using Excel
  • Perform Loops, Controls and Error Handling
  • Create User forms and Sheet Controls in Excel
  • Use Events to trigger speciic VBA code

Go To Top

Detailed Outline for 3 Day Excel 2007 Macro Training

Lesson 1:

  • Make a Macro do Simple Tasks
  • Difference between VBA & Macro
  • Creating a Simple Macro
  • Changing Multiple Properties at Once
  • Manipulating Recorded Properties
  • Recording Methods in a Macro

Lesson2:

  • Make a Macro Do Complex Task
  • Opening the Report File
  • Filling in Missing Labels
  • Adding a Column of Dates
  • Appending to the Database
  • Deleting the Worksheet

Lesson3:

  • Explore Workbooks and Worksheets
  • Understanding Workbooks
  • Understanding Worksheets

Lesson 4:

  • Explore Range Objects

Lesson 5:

  • Explore Data Objects
  • Working with Excel Table
  • Working with Pivot Table Reports
Lesson6:

  • Explore Graphical Objects
  • Explore Chart Objects

Lesson 7:

  • Control Visual Basic
  • Creating Loops
  • Managing Large Loops

Lesson 8:

  • Extend Excel and Visual Basic
  • Creating Custom Functions
  • Handling Errors

Lesson 9:

  • Launch Macros with Events
  • Creating Custom Command buttons
  • Handling Worksheet and Workbook Events

Lesson 10:

  • Use Dialog Box Controls on a Worksheet
  • Using a loan Payment Calculator
  • Retrieving a Value from a list
  • Protecting the Worksheet

Lesson 11:

  • Create a Custom Form
  • Preparing a form’s functionality

 

Go To Top

Intended Audience: This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel 2007 Macros and Visual Basic for Applications (VBA) programming language.

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

How To Register

This course is scheduled to run at our Microsoft VBA Excel 2007 training center at Beach Road in Singapore. View our Training Calendar for available dates. Enquire or Register by filling the form at the top right of this page.

Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at (65) 6296-2995.

Custom In-House / Corporate Training
The course can also be run on specific dates that suits you.

Call our Corporate Training Hotline at (65) 6296-2995 if you have a group of 5 or more participants.

You can email to training@intellisoft.com.sg for Corporate Training Rates.

Some of the companies that experienced our trainings

Get Creative With Illustrator
&
Accelerate Your Career

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!