Microsoft Office Excel 2010 VBA

Code: 084288
Course duration: 1 days

084288-Microsoft Office Excel 2010 VBA

Course Description

Course Objective: You will automate your job tasks in Microsoft® Office Excel® 2010.

Course 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.

Course Content

Lesson 1: Developing Macros

Topic 1A: Create a Macro Using the Macro Recorder

Topic 1B: Edit a Macro

Topic 1C: Debug a Macro

Topic 1D: Customize the Quick Access Toolbar and Hotkeys

Topic 1E: Set Macro Security

Lesson 2: Formatting Worksheets Using Macros

Topic 2A: Insert Text

Topic 2B: Format Text

Topic 2C: Sort Data

Topic 2D: Duplicate Data

Topic 2E: Generate a Report

Lesson 3: Creating an Interactive Worksheet

Topic 3A: Determine the Dialog Box Type

Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets

Topic 4A: Insert, Copy, and Delete Worksheets

Topic 4B: Rename Worksheets

Topic 4C: Modify the Order of Worksheets

Topic 4D: Print Worksheets

Lesson 5: Performing Calculations

Topic 5A: Create User-Defined Functions

Topic 5B: Automate SUM Functions

084288

Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review