Code: 
MSEXCEL4VBA1
Duration: 
1-4 Day(s)
Price: 
205-790

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
London 790323 Oct 17
Milton Keynes 684323 Oct 17
Leeds 658323 Oct 17
Sheffield 658323 Oct 17
Belfast 310 Oct 17
Coventry 658325 Sep 17
Bristol 658325 Sep 17
Birmingham 658325 Sep 17
Leicester 255221 Sep 17
Bristol 314 Sep 17
Nottingham 658305 Sep 17
Slough 658305 Sep 17
Leicester 658305 Sep 17
Reading 658305 Sep 17
Manchester 658314 Aug 17
Liverpool 658314 Aug 17
Exeter 311 Aug 17
Leicester 255202 Aug 17
Coventry 658331 Jul 17
Bristol 658331 Jul 17
Birmingham 658331 Jul 17
Milton Keynes 658331 Jul 17
Cambridge 205126 Jul 17
Leeds 320 Jul 17
London 318 Jul 17
Manchester 658317 Jul 17
Leicester 658317 Jul 17
Nottingham 658317 Jul 17
Reading 658317 Jul 17
Liverpool 658317 Jul 17
Slough 658317 Jul 17
Leicester 255210 Jul 17
London 790403 Jul 17
Leeds 658403 Jul 17
Sheffield 658403 Jul 17
Cambridge 205129 Jun 17
Leicester 255223 Jun 17
Cardiff 322 Jun 17