Adv.Excel VBA Training

Excel, VBA | Macro Training

VBA is an object-oriented programming language and well suited to beginners. It provides many of the Visual Basic programming facilities through the Excel application. Thus, students who have access to Excel can gain familiarity with Visual Basic without having to set up to the full blown program. With VBA, programmers have the power to customize Excel application that would be impossible to achieve with Excel alone. VBA can often provide a faster, and sometimes easier to implement solution, than could be achieved with Excel alone. Excel is made up of a series of objects that can be manipulated through code.

All these objects are required to complete various tasks while using Excel. For instance, if an Excel financial report form is complete, the user might open the workbook containing a worksheet with the report from, enter data in a range on that form, and save the workbook, The workbook, worksheet and range are all excel objects, VBA can be used to manipulate such objects, making it easier to complete the task of submitting the financial report. E-mailing the report can also be automated.

Book - VBA for Excel witten by Hirdesh Bhardwaj

 

Course Details

Advanced Excel

  • Spreadsheet Basics
  • Spreadsheets Operations
  • Text Formatting- Custom
  • Creating a Formula
  • Conditional Formatting
  • Relative and Absolute Reference
  • Data Validation
  • Popular functions (Lookup, Conditional, Date, Text, Account etc.)
  • Text to columns wizard
  • Name Manger, Selection, Define Name
  • Split / Freeze Panes
  • Share workbook & Track changes
  • Charting and Analyzing Data
  • Advanced Filter (Based on 10 different scenarios)
  • Creating and Editing Charts
  • Pivot Tables - Wizard
  • Consolidate Data Tool
  • Dependency List using Indirect
  • Goal Seek
  • Importing data from other sources
  • Lookup and conditional functions
  • Creating Dashboard
  • Solver Tool - Wizard
  • Macros / VBA Basics

VBA Programming

Visual Basic Editor
  • The Project Explorer
  • The Properties Window
  • Variables and Data Types in VBA
Loops and Statements in VBA
  • Structure of Functions and Procedure
  • If....Then....Else Statements
  • For....Next and Do Until... Loop
  • Select Case.... End Select
  • With Selection.... End With
  • For Each Loop
Form Controls
  • Understanding User forms and References
  • Combo box, Radio Button, Group box, Check box
  • Built in Dialog Boxes, Calendar
  • Project Study on GUI Pattern
Working on Actions / Events
  • Events - Workbook, Worksheet Level Events
  • Working with Excel Range and Data
  • Worksheet and Workbook Operations,
  • Using Excel Functions in VBA
  • Volatile Functions
Interactive Windows and Reporting
  • Message box, Tools & Controls
  • Create Chart
  • Export report in PDF
  • Filters and Reporting
Mail Functions-Outlook / MAPI
  • Send automated mail, Outlook Configurations, MAPI
  • Filter Mails into Folders
  • Export Mails, Attachments in a specific location
Database Connectivity
  • Excel -Access Connectivity -Select, Retrieve, Insert Data Operations
  • Excel-SQL Connectivity -Select, Retrieve, Insert Data Operations

Course Duration

  • 2-3 Months ( WeekDays & WeekEnd Classes)
  • Class Duration : 2-3 Hrs
Advanced Excel with VBA - Download

CONTACT US

  • 225, S Square Tower, Old Delhi Road,
    Near Bus Stand, Opp Raj Cinema, Gurgaon
  • Email: info@websjyoti.com
  • Contact: 0124-436-0863
    +91-8802000175

Also Available at