/
/
/

Microsoft Excel VBA

(5.0)1 review
Recent reviews of this course provider

Introduction to Microsoft Excel

Clare was a really helpful and funny trainer and made the course fly by it wasn'...more

See all reviews
Add to shortlistShortlisted by 72 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-VBA-courses/55677834/

Course description

Microsoft Excel VBA:

Price: the price opposite is a total per day, click on View Course for full price details

Benefits of Microsoft Excel VBA Course

Our Microsoft Excel VBA course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). VBA gives you the ability to do what you normally do in Excel, but much faster and allows you to work with ease with enormous sets of data. We have designed this course structure that is relevant for business use. This is a hands-on learning experience which is more instructive than textbook. Our Microsoft Excel VBA course looks at creating and developing macros, working with worksheets and performing calculations. Please refer to the course content for a full list of topics covered. At the end of the course the delegate will have covered the fundamentals of VBA. Our trainers are qualified and experienced professionals with years of experience in teaching the Microsoft suite of products. For successful completion of this Microsoft course you would need knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Course Content

Developing Macros

  • Create a Macro Using the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys
  • Set Macro Security

Formatting Worksheets Using Macros

  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report

Creating an Interactive Worksheet

  • Determine the Dialog Box Type
  • Capture User Input

Working with Multiple Worksheets

  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets

Performing Calculations

  • Create User-Defined Functions
  • Automate SUM Functions

A total price for training up to 6 people and computers are provided free of charge (one per person).

Additional entry requirements

Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Training for employers

This course has been specifically designed for companies training their employees.

Course reference: MSEXVB (use this when contacting provider)

Course info
598 views

Location:

Basingstoke, RG21 3EE, Birmingham, B1 1BD, Brighton, BN1 1YR, Bristol, BS1 6EA, Cambridge, CB1 1BH + 32 more

Time:

During the day

Duration:

1 day

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

Level:

BeginnerIntermediate Advanced

From: £792

Other Visual Basic courses

Microsoft Access VBA (1 day)

Insight IT Training Limited

Duration: Variable

Advanced

Certificate of Attendance

Microsoft Access VBA (2 days)

Insight IT Training Limited

Duration: Variable

Advanced

Certificate of Attendance

View 2 courses

Summary of all course reviews for Insight IT Training Limited

1 review

(100%)

Average student ranking

Reviews of other courses at Insight IT Training Limited

insight-it-training

Introduction to Microsoft Excel
5 5
Hotcourses
by Tony - August 2017

Clare was a really helpful and funny trainer and made the course fly by it wasn't dull and was very engaging.

Was this review helpful? Yes No
1 Hotcourses user(s) found the following review helpful.

Please note reviews of Introduction to Microsoft Excel are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Microsoft Excel VBA by Insight IT Training Limited on Hotcourses

Ask a question

Get course info