| Course Management | You are Offering Professional Course | Locality Shivaji Nagar |
Finatics offer program on " Advanced Excel & VBA Excel Macros".
"Only people with logical bend of mind can join the program, Other please excuse".
Course Fess: 12500/- . Duration: 1 Month ( 24 Hours, Weekend Batch)
Note: Kindly don't ask for discount, only group Discount available for people more than 3.
Part I Advanced Excel
>> Paste Special, Go to Box, Conditional Formatting
>> Creating Multi Dimensional formulas with Referencing
>> Working with Mutliple Name Ranges
>> Lookup Functions: VLookup, Hlookup,Offset, Match
>> Conditional Operations: Sumif, Sumifs, Countif, Countifs, Averageif
>> Nesting with IF statements
>> Pivot Tables
>> Multiple Filtering & Subtotals
>> Data Validation
>> Manipulating Text Functions
>> What if Analysis ( Sensitivity: {one way & Two way data tables}, Scenario Anaylsis, Goal Seek)
>> Dynamic Charts, 3D Charts
Part II VBA Macro
Introduction to Visual basic
>> VB - Code Editor Window
>> Properties window in Code Editor
>> Excel Objects & Module
>> Macro Recording & Replay
Visual Basic Programming
>> Visual Basic Syntax
>> Variable & Its Properties
>> Methods & Its Properties
>> Conditions & Loops
>> Functions & Procedures
>> Debugging & Error Handling
Exploring the Excel Sheets
>> How to use range & cells
>> Worksheet & Workbooks & their Properties
>> Working with Excel Data
>> Case Study to test & practice Macros