Excel, VBA | Macro Training


     

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