Home / Advanced Excel Course in Chennai
Advanced Excel Course in Chennai
last updated on
2015-05-15T14:59:51

Training Overview


Looking for an Excel course for beginners to experts? This  course has something for everyone, covering beginner, intermediate and advanced lessons in Excel. you will learn basic techniques including how to use math, statistical, logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. You will also learn intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.


Target Audience


Any Working professionals with basic Excel knowledge


Training Content


Getting started with Macros

  • Recording and Modifying Macros
  • Assigning Macros to Toolbar, Buttons, Shortcut key

Visual Basic for Applications Environment

  • Visual Basic Editor and its options
  • Component Management
  • Shortcuts

Introduction to Procedural Programming

  • Procedures: Functions and Sub-routines
  • Data Types

Control Flow

  • If ...Then....Elseif....Else....Endif
  • Case
  • Do...Loop , While
  • For... Next
  • Exit
  • VBA and Sheet Data Exchange (Cells, Range Methods)
  • Getting and Printing Data from Users (InputBox, MsgBox)
  • how to link with Ms Access and SQL

Pre-Requisites


Basic Excel


Participant Fee


On Request

please call us @  91-44-42115338 , SMS to  91-9677167119 or Whatsapp @  91-9884987719 or Email your queries to education@hbservices.in

Share this announcement on: