Excel 2010 - VBA

Displaying courses for United States [Change]

Overview

The student will learn to automate job tasks in Microsoft® Office Excel® 2010.

Objectives

Upon successful completion of this course, students will be able to: - develop a macro. - format worksheets using macros. - create an interactive worksheet. - work with multiple worksheets. - perform calculations.

Audience

This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Syllabus

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

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 1 day
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Visual Basic for Applications
United States
This skill has an average salary of
US$91,264
and is mentioned in
0.36%
of job ads in this area.
Debugging
United States
This skill has an average salary of
US$100,836
and is mentioned in
1.16%
of job ads in this area.