EXCEL VB SCRIPT ALL VERSIONS

Microsoft-Excel-Logo.png

Included in the course

  •  A course attendance certificate
  •  Tea and Biscuits during breaks
  • Lunch
  •  A notepad and pen
  •  A manual and datafiles

Course Code: EXCEL-VB

Duration: 1 Day 

***Course Content is based on Excel 2010 ***

You will automate your job tasks in Microsoft® Office Excel® .

Study Methods available for this course;

   Classroom Training    Onsite Training
   Mentored Learning   Correspondence
   Virtual Classroom Training    Part Time Training
   E-Learning

GET A QUOTE NOW!


Name:*
E-mail:*
Phone:
-
Date:
Study Method:
Course Code:
Course Description:
No of Students:
Message:*
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

Prerequisites
Target Student

Contact Information

Address

Durbanville, Cape Town

Call Us
021 065 0347
Email

info@idigisol.co.za

Subscribe to our mailing list

* indicates required

Live Help

Live Help

Quick Contact

Search