Advanced Excel Syllabus

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.

1. HB Education and Consulting Services (P) Ltd
New No.89, Old No. 39/40,1
st
Main Road,
Gandhi Nagar, Adyar, Chennai – 6000 020
Tel: [phone]
Email: [email protected] Web: www.hbservices.in
Please call us @ [phone] or [phone] or [phone] or
Email your queries to [email protected]





Advanced Excel Syllabus

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