Advanced Excel Training in Chennai

With regard to your enquiry, the details have been disclosed for your reference:

Program Name: Advanced Excel 2010

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.
Duration: 3 days
Batch Size: 5 – 10 Members
Pricing: Rs.7865/- (Fee includes Courseware, Stationery and Course Completion Certificate)

Training Content:

Getting started with Macros
o Recording and Modifying Macros
o Assigning Macros to Toolbar, Buttons, Shortcut key

Visual Basic for Applications Environment
o Visual Basic Editor and its options
o Component Management
o Shortcuts

Introduction to Procedural Programming
o Procedures: Functions and Sub-routines
o Data Types

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

About the Training Company:
HB Educational Services , a leading IT Training & Certification Company in Chennai offering diverse IT Education Courses, Corporate Training Programs and Distance Education Programs.

Please call us @ +91-44-42115338 or +91-9884987719 or +91-9677167119 or Email us @ [email protected] for more details