iisastr- programmer analyst Home | Enquiry | Contact Us

International Institute
Home Page sas programmer
Career Opportunities
Corporate Training
HR Consulting
Little Bit History About SAS
SAS Syllabus
Data warehousing Syllabus
Advanced Excel Syllabus
Spss Syllabus
Market Research with SPSS
Data Analysis
Corporate Training
current openings

IISASTR aimed at providing world-class Training in the area of Research Analytics (courses offered both regular and Distance), Covering domains such as:

* SAS®/Clinical
* SAS®/Finance
* SAS®/Banking
* SAS®/Advanced Analytics
* SPSS®/Market Research
* Excel/Analytics
* Minitab

IISASTR Articles
Corporate Training
Data Management and Analysis with Advanced Excel

Duration :42 hours
Fee  ;Rs 15,000/-

Bachelor’s degree in any discipline with or without computer knowledge. Ideally suited for BA, B.Com, B.Sc., BBA, BBS & BCA students.

MIS ExecutiveMIS AnalystData AnalystBusiness Analyst

100% job opportunity program in sectors like: KPO, Financial Companies (Banks& Insurance), IT&ITES, Healthcare, Manufacturing and many more in the list.

Salary ranges from 1.8 to 4 Lacs Per Annum


Contents of advanced excel

  • Introduction 
  • Using Excel lists
  • Creating a List
  • Sorting
  • To perform a Simple Sort
  • To Sort by Multiple Columns
  • Data Forms 
  • Adding Data Using the Data Form
  • Finding Records Using Criteria
  • Filtering Data
  • AutoFilter
  • Advanced Filters
  • Special Features for Filtered Lists
  • Totals and Subtotals Total
  • Row
  • Subtotals
  • Managing Windows
  • Multiple Windows
  • Splitting Windows
  • Freezing Panes
  • Linking Data
  • Analysis tool pack
  • Analysis by goal seek
  • Analysis by pivot tables

Automating your Data management & analysis with VBA 

Why Should I Learn Visual Basic for Applications ?
Often people who are skilled with spreadsheets shy away from learning Visual Basic for Applications. Excel carries a lot of built-in functionality so they don’t feel the need to learn programming. In fact, there are a number of reasons to get comfortable with writing macros in Visual Basic for Applications (VBA).

VBA Looks Good on Your Resume
Microsoft Office is used by nearly every employer in the world and the more extensive your skills with the application suite, the more attractive a candidate you are when applying for jobs. Visual Basic for Applications in Excel is the same macro language used in Word, Access or the other Office applications.
Once you know how to write macros in Excel, using macros in Word is just a matter of learning a few new object definitions. Even if you are happy with the company you work for, it never hurts to improve your job skills. The more you can do the more valuable you are to your boss. Besides, you never know what tomorrow will bring and an unexpected layoff could force you to start job hunting.

Get More Value Out of Excel from OfficeVBATrainer
Stretch your software dollar further by using all the features of Excel. If you aren’t using Visual Basic for Applications, Excel is just half an application. It’s a bit like buying a car but making only right turns. Learning to write your own macros opens up a world of functionality. You are no longer limited by built-in functions. You can now write your own and have them do nearly anything you want.
Macros allow you to create complex functions without the intermediate calculation cells that may be required when using built-in functions. For example you might have a list of values and you want to put each value into an equation then sum the values. With built-in functions you’d have to have a cell next to each value that puts it into the equation then another cell that sums the results. A macro could step through each value, perform the calculation, and sum the total all in one cell.

Get Your Work Done Faster after this Training.
When you first learn Visual Basic for Applications, Excel built-in functions might seem like a faster way to do things. Puzzling out program structure and getting results to come out right takes longer than using quick and dirty shortcuts on the spreadsheet.
With time, your VB programming skills will improve and you will create your custom functions faster. Although it takes extra time to create the function up front, it will save time every time you use it. Soon you will have a standard library of self-created functions that you can easily add to every spreadsheet you make.
Don’t be discouraged.  It can take months to become proficient with Visual Basic, but once you are comfortable with it you will be glad you took the time to learn


  • Advanced Excel VBA
  • Advanced Access VBA
  • Advanced PowerPoint VBA
  • Advanced Word VBA 

Courseware for VBA for Excel

  • Object-orientated programming 
  • Working across applications 
  • File System Objects
  • Using built-in file dialog boxes 
  • Macro security
  • Protecting applications 
  • ActiveX controls 
  • Class modules 
  • Good programming techniques 
  • Customizing menus and toolbars 
  • Debugging
  • Handling errors
  • Recording macros 
  • Running macros 
  • Customizing menus and toolbars
  • Writing macros 
  • Selecting cells and ranges
  • Talking to your user
  • Variables
  • Subroutines, arguments and functions
  • Loops and logic
  • Debugging
  • Handling errors
  • Event-handling
  • The Visual Basic rabbit-hole
  • Looping over collections
  • Creating forms
  • Using forms
  • Advanced form controls
  • Programming menus and toolbars
  • Working across applications
  • Crib sheet