study overseas chennai +91 - 44 - 42115338
+91 - 9884987719 (Adyar)
+91 - 7550245795 (Velachery)
Advanced Excel 2010 Training

Advanced Excel 2010 Training

Training Name

:

Advanced Excel 2010

Description

:

Advanced Excel Using VBA Concept.

Weekend Batch

:

Available

Training Time

:

8 hrs per day (Sat & Sun)

Duration

:

24hrs

Venue

:

HB Educational Services, 39/40, 1st Main Road, Gandhi Nagar, Adyar, Chennai-20HB Educational Services, 2/189, 2nd Floor,100 Feet Road, Vijayanagar, Velachery, Chennai-42

Target Audience

Any Working professionals with basic Excel knowledge

Training Overview

In this advanced course you will learn powerful skills with Excel that let you automate tasks using macros, do advanced analysis of data and collaborate and share data with others, developing and applying macros using Procedures and Functions, Using Objects, Controlling Program Flow, Utilizing Variables and Expressions, Debugging the code, Handling Errors and Employing Forms and Controls.

Training Content

Getting started with Macros

  • Recording and Modifying Macros
  • Assigning Macros to Toolbar, Buttons, Shortcut key

Visual Basic for Applications Environment

  • Visual Basic Editor and its options
  • Component Management
  • Shortcuts

Introduction to Procedural Programming

  • Procedures: Functions and Sub-routines
  • Data Types

Control Flow

  • If ...Then....Elseif....Else....Endif
  • Case
  • Do...Loop , While
  • For... Next
  • Exit
  • VBA and Sheet Data Exchange (Cells, Range Methods)
  • Getting and Printing Data from Users (InputBox, MsgBox)
  • how to link with Ms Access and SQL

Pre-Requisites

:

Basic Excel

Participant Fee

:

On Request

Please reach our Adyar Center @ +91-44-42115338, or 91-9884987719 (Whatsapp & Call Support)

Please reach our Velachery Center @ +91-7550245795 (Whatsapp & Call Support)

Live Chat Business

_+

Live Chat Business