Code: 
MSEXCEL4VBA1
Duration: 
1-3 Day(s)
Price: 
1750-465

Overview

Learn how to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

Students will gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students will strengthen their knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Audience

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Skills Gained

Upon successful completion of this course, students will be able to: -

  • develop macros
  • format worksheets
  • create an interactive worksheet
  • work with multiple worksheets
  • perform calculations

Course Specifics

Course Outline

Lesson 1: Simple Task Macros

  • Macro basics
  • Edit a macro
  • A toggle macro
  • Make VB code readable
  • Protecting Code

Lesson 2: Manage a task with macros

  • Stepping through a macro
  • R1C1 formula style
  • User Input
  • Relative Reference macro
  • Turn off Excel alerts
  • Assemble the pieces

Lesson 3: Exploring VB Objects

  • Excel Object Model
  • Objects, properties and methods:
  • Application
  • Workbook
  • Worksheet
  • AutoList
  • Object Browser
  • Help
  • Explore the Range object

Lesson 4: Conditional and Looping Control Structures

  • IF THEN ELSE statement on Msg Box
  • Input Box
  • Loops For each loop
  • Counter Loop
  • Do until loop

Lesson 5: User Defined Functions

  • Write a Function
  • If function
  • SELECT CASE statement
  • Use Excel function

Lesson 6: Debugging and Error Handling

  • Event Handling

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

a Location Cost Days Date  
Leicester 255215 Dec 17
Leicester 255230 Nov 17
Leicester 255231 Oct 17
Leicester 255221 Sep 17
Glasgow 328 Aug 17
Leicester 255202 Aug 17
Leeds 331 Jul 17
Liverpool 328 Jul 17
Cambridge 205126 Jul 17
Leicester 255210 Jul 17
London 306 Jul 17
Cambridge 205129 Jun 17
Leicester 255223 Jun 17
Cambridge 465220 Jun 17
Birmingham 319 Jun 17
Cardiff 312 Jun 17
Cambridge 205125 May 17
Oxford 309 May 17
Bath 1750308 May 17
Reading 303 May 17
Bath 1750303 May 17