loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Advance Excel and VBA

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Dheeraj

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Advance Excel and VBA

Advance Excel and VBA

Guru Teg Bahadur Nagar, Delhi

7,500

1 Reviews
0 Interested

About the Course


Advanced Excel and VBA has become the basic needs of today's corporate environment. Everyone and anyone who wants to walk up the Corporate Ladder should join this course.

Topics Covered

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Advanced Excel and VBA has become the basic needs of today's corporate environment. Everyone and anyone who wants to walk up the Corporate Ladder should join this course.

ADVANCED EXCEL FUNCTIONS
? Various Methods and Uses of Advance Excel Formulas
? VLOOKUP, HLOOKUP
? SUMIF, SUMIFS, SUMPRODUCT, DSUM
? COUNTIF, COUNTIFS, IF
? IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT
? GETPIVOTDATA
? DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH ETC


Various Methods and Uses of IF Conditions


? When should use the "IF" Conditions?
? Creation of Multiple IF Conditions in One Cell
? Use the IF Conditions with the Other Advance Functions
? How to use nested IF statements in Excel with AND, OR Functions


ADVANCED EXCEL OPTIONS
? Various Methods of Filter and Advance Filter options
? Creating and Updating Subtotals
? Various Methods of Text to Column options
? Uses of Data Grouping and Consolidation options
? Uses of Goal Seek and Scenarios Manager
? Various Method of Sorting Data
? Creating, Formatting and Modifying Chart
? Data Validation, Creating drop down lists using different data sources
? Linking Workbooks and Uses of Edit Link options
? Excel Options, Customizing the Quick Access Tool Bar

Pivot Tables & Charts
? Various Methods and Options of Pivot Table
? Using the Pivot Table Wizard
? Changing the Pivot Table Layout
? Subtotal and Grand total Options
? Formatting
? Grouping Items
? Inserting Calculated Fields
? Pivot Table Options
? Calculation in Pivot Table
? Display and Hide Data in Field
? Select, Move & Clear Pivot Data
? Creating and Modifying Pivot Chart


Advance Use of Function
? Mixing Function to get Various MIS Outputs
? Creating Data Table
? Advance Data Validation
? Using conditional formatting with Formulas and Function
? Using Name Manager
? Array Formulas
Importing Data from External Sources


Macros
? What is a Macro?
? Creating Excel Macro
? Running Macros and Editing
? Automating Tasks with Macro



Introduction to VBA

? Introduction to Excel

? Introduction to Programming

? VBA Overview and the IDE

? Quick Review of Macros

? Working with Macros

? How to use Visual Basic Editor (Programming Environment)

Advantages of VBA

? An easy-to-use and versatile language

? Integrated with off-the-shelf products

Understanding The VBA Editor, Module and Procedures

? The Visual Basic Editor

? Parts of the VBA Editor

? Modules and Macros

? About VBA Forms, Sub Procedures & Modules

? Creating Forms

? Using Controls and their Properties

? Running VBA Forms in Excel



VBA Syntax and Grammar

? Objects – The Grammar

? Using Properties and Methods

? Understanding Parameters

? The Object Browser

? Understanding object hierarchy

? Tools for better coding

? Moving to Other Cells

? Editing Specific Cells

Variables, Arrays & Constants

? Using the Immediate Window

? Gaining greater control through the immediate window

? Formatting Cells

? Using Variables

? Constants

? Object Variables

? Dimensioning and usage of variables

? Displaying data and obtaining data from the user

Storing data in variables

? How and when to declare variables

? Selecting data types

? Fixed and dynamic arrays

? Constants

Control Structure and Program Flow

? IF (ElseIf, Else)

? Select Case()

? For Next Loop

? For Each Loop()

? Do Until Loop and Do While Loop

? With, End With

? Nesting Code

Building procedures

? Creating Sub and Function procedures

? Calling procedures

? Passing arguments to procedures



Building Intuitive User Interfaces

? Communicating with the user through the message box

? Gathering user information with the input box

? Utilizing the File Dialog object and Dialogs collections

Creating customized dialogs with User Form objects

? Command buttons

? List and Combo boxes

? Labels

? Option buttons

? Check boxes

? Text boxes

? Frames

? Adding more functionality with advanced ActiveX control

Fonts & Background

? Using Font Property in cells

? Using Various Background Properties in Excel VBA

? Creating a Counter

? String Handling

? Using Left, Right, Instr, Mid and Len Functions in VBA

? Range Selection and Manipulation

Objects and Collections

? Workbook and Worksheet Object

? Range Object and Cell Properties

? Methods and Properties

? Assigning Objects

? Using Name Arguments

Array

? What is Array& why use array

? Declaring an Array

? Sorting Data in Array

? 2-Dimention Array

? Dynamic Array

? UBourd

? Storing Data in a range of an Array Elements

? Using various array functions

Functions

? Using Excel Worksheet Functions in VBA

? VBA Functions

? User-Defined Functions

? Adding Help to User Defined Functions

? Declaring Variables in User Defined Functions

? Using Ranges in User Defined Functions

? Creating and Managing an Add-in for User Defined Functions

Internet and Excel

? Copy Hyperlinks and Text from a webpage to Spreadsheet

Interacting with Other Office Applications

? Communicating with Word and PowerPoint using Excel VBA

Running SQL Queries within Excel Environment

Modifying Menus and Toolbars

? Simplifying user interaction with the Command Bar object

? Adding and removing CommandBarControl objects

Who should attend

Managers, Top Executives, Data Analysts, Executives, CEOs, Students, Working Professionals, Accountants

Pre-requisites

Basic Computer Knowledge, Microsoft Office tools like Word, Excel and Powerpoint knowledge

What you need to bring

Notepad and Pen"

Key Takeaways

Understand MS Excel in a whole new way with new applications
• Navigate through Extensive data with greater ease & efficiency
• Illustrate &Display the data in a more comprehensive manner
• Perform Conditional Analysis with Precision and Clarity
• Format Excel Sheets & Data and ensure better representation
• Dig through & Deduce Conclusions from complex Data Sets
• Create Multi use forms and Situation based test sheets
• Calculate complex calculation, What IF Calculations through Excel.

Six Months MS Excel support to you (we're just an email away!)

C.D containing Shortcuts, tips, tricks, solved copy of excel illustrations, practice files to all participants after the training.
Reviews

Recommendations & reviews from previous Customers:

Bhawna

"I had a doubt that there is so much to cover in Advance Excel and VBA and how will he be able to cober the complete syllabus in just 2 days workshop..but he proved me wrong. He has such a good command on subject that even two days were more than enough.. Hats off to his knowledge and skills.. The Best Advance Excel and VBA trainer in NCR... "

attended Advance Excel and VBA


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 1 of 1
N

Nitasha 13/08/2014

Hi Dheeraj,

I am a Chartered Accountant by profession and want to learn Advanced Excel and VBA, one of my friends has referred you, she attended your workshop and was quite impressed.

The content you have mentioned, would two days be sufficient and will I get the complete worth of my money?

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Bhawna

"I had a doubt that there is so much to cover in Advance Excel and VBA and how will he be able to cober the complete syllabus in just 2 days workshop..but he proved me wrong. He has such a good command on subject that even two days were more than enough.. Hats off to his knowledge and skills.. The Best Advance Excel and VBA trainer in NCR... "

attended Advance Excel and VBA


Date and Time

Not decided yet.

About the Trainer

Dheeraj Ailawadi picture

Dheeraj Ailawadi

BCA, MCA and MBA (IT)


Working in IT industry with more than 7 years of experience working on MS Excel.

I have conducted various soft skills as well as IT training workshops, with MS Excel being my specialization.

I am a Microsoft Certified Trainer.

Have trained numerous corporates and Trainers.

Have been taking face to face classes in Delhi/ NCR however out of Delhi/NCR we conduct online sessions.

I have been using latest techniques and methodologies for delivering training.

Emphasis being given on modern and industrial based training sessions.
Seats Left-

Students Interested 0

Course Id: 22528