Advanced Topics in Excel 2007:

● Using shortcut keys
● Managing Multiple Excel Sub-Windows effectively
● Using various built-in functions
● Using Name Manager to name cells/ranges
● Formula Auditing in Excel
● Advanced Formatting techniques in Excel
● Linking cells/sheets/workbooks
● Object Embedding in Excel
● Using Quick Access Toolbar in Excel 2007
● Working with Shapes/Objects and formatting them
● Print Options
● Creating Sub-Totals
● Using VLOOKUP / HLOOKUP
● Creating Pivot Tables
● Working with Charts
● Using Filters
● Defining Validation Rules
● Grouping Ungrouping Rows/Columns
● Using Solver and Goal Seek

Understanding on Macros:

● How to record a macro
● How to edit a macro
● How to debug a macro
● Implementing macro security and digital signatures.
● How to assign a short cut button to a macro.
● Tips on analyzing the requirement and recording a successful macro

● Visual Basic in Applications:-

● VBA and its advantages.
● Overview of VBA editor
● How to use various features in VBA editor.
● Definition of Modules. How to create and delete VB module.
● Events, How to add a event to a workbook, How to make Macro work automatically when a workbook is opened, saved etc..
● How to use references and help in VBA

VBA Programming Kit:

● How to declare variables, arrays, assign values etc.
● How to declare constants and data types
● Methods and Properties
● Using IF and Loop functions in VBA
● Input and Output facilities in programming
● Workbooks and worksheets.
● Ranges and Cells

● Creating User Forms:-

● What is User form, Advantages
● Techniques in creating user form.