Excel 2007 Macros and VBA

In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.

Course Outline

In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.

Objectives

• You will apply automation to job tasks in Microsoft Office Excel 2007
• Creating, editing and debugging macros
• Format worksheets using macros
• Create an interactive worksheet
• Work with multiple worksheets
• Perform Calculations

Target Student

• Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA)

Outline

• Section 1 - Developing Macros
  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys
  • Work with Macro Security
• Section 2 - Formatting Worksheets Using Macros
  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report
• Section 3 - Creating an Interactive Worksheet
  • Determine the Dialog Box Type
  • Capture user Input
• Section 4 - Working with Multiple Worksheets
  • Insert, Copy and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets
• Section 5 - Performing Calculations
  • Create user-Defined Functions
  • Automate SUM Functions

Additional Details

Pre-Requisites

* Knowledge of Microsoft Office Excel 2007, including how to create, edit, format and print worksheets that contain charts, and sorted and filtered data. * To ensure your success, we recommend the following On-Track courses, or equivalent knowledge in Microsoft Office Excel 2007: Levels 1, 2 and 3.

Certificates offered

Certificate of completion

Cancellation Policy

Should you postpone or cancel your course you must give 5 business days notice.

Map & Reviews

On Track Computer Training
[ View Provider's Profile ]

On Track Computer Training Center
1600 - 650 West Georgia Street
Vancouver, British Columbia
Canada   V6B 4N7

Reviews

 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

   

Great instructor - made it so much easier to get through a whole day staring at a computer!

Reviewed by Laurenne S. 2012

   

There wasnt enough taught in the course. I didnt find it went into enough detail and the handout is terribly written. The instructor was okay but he focused too much on how "Not to do something" then how to just do it correctly, on certain course material which confused people. I think less breaks, more days added so we can learn more about what MS project has to offer.

Reviewed by Emma S. 2012

   

One of the best training that I have ever emcountered.

Reviewed by Cenk O. 2011

   

The course was great and helped me learn a lot of skills using Excel for work. The instructor was really nice and knowledgable. Although my only complaint and concern is that the course was really rushed and i feel like some people wouldnt be able to keep up with the training.

Reviewed by Amanda C. 2011

   

I'd like to see a course at this level that is more in depth. More practice excercises, over a longer period of time. I was pleased the instructor made himself available to students even after the course was complete (gave us his email if we had any follow up questions).

Reviewed by Charity . 2011

   

Alan has a done an exceptional job. He is very knowledgeable and goes out of his way to explain everything in details. He is very patient and answers all my questions. He is an awesome teacher!

Reviewed by Peter C. 2011

   

I did note body odour of presenter was strong. Only critisism I have. Everything else was excellent.

Reviewed by Richard V. 2011

   

Alan was an excellent instructor!

Reviewed by Jami S. 2011

   

Excellent Excel 2 course, Alan is a very good instructor. I would take additional courses.

Reviewed by Rosmary C. 2011

   

I wondered why Access 2003 instead of 2010. I should have checked that before I took it. Anyway the course was great and I learned a lot and the Instructor was so nice and kind, I enjoyed his class.

Reviewed by Alma L. 2011

   

Haven't really looked over the course book much as I made lots of notes. Only comment re: technlogy was I had no internet connection which was a bit of a hassle during the lunch break as I wanted to check my email and my company website and had to use another desk.

Reviewed by Sheree G. 2011