Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Advanced Excel & VBA Excel Macro Training Program

No Reviews Yet

Fergusson College Road, Pune

Course ID: 7011

Fergusson College Road, Pune

Students Interested 2 (Seats Left 0)

No Reviews Yet

About the Course

Finatics offer program on " Advanced Excel & VBA Excel Macros".

Trained more than 200 Professionals in Advanced Excel.

Professionals working in Data Analytics, Marketing Analytics, KPO, BPO, IT Services.

Provides Excel based data Analytics to Senior Management in Future Group, Reliance General Insurance, Coca Cola & Others for Decision making.

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.


Topics Covered

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

Who should attend

"Only people with logical bend of mind can join the program, Other please excuse".

No Qualification Restriction!!

Pre-requisites

Basics of Micro-Soft Excel.

What you need to bring

Nothing

Key Takeaways

Excel Tricks & Tips!

Well made Exercises

Case Studies

Date and Time

Not decided yet.

About the Trainer

Avg Rating

Reviews

Students

Courses

Abhijit

MBA, B.E

10 Years of Experience in Consulting. Trained more than 300 Students in Advanced Excel.
Provides data consulting to company.
Part of Finatics Analytics Team.

Reviews

No reviews currently

Students Interested 2 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Personality Development Training Classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more