Friday, July 25, 2014

SAS Road Map - SAS, BI , Excel VBA

1.
http://www.signetsoft.com/business-analytics-signet.html

Format numbers
Functions
Lookups
Conditional formatting
Data Validation
Sort and filter
Charts
Pivot Tables and Charts
Tabs: Home, Insert, Formula, Data, Review and View tab
What IF Analysis

Introduction to VBA
Introduction to macro recording, IDE
How VBA works?
VB Editor
Excel object model
Excel macro recorder
Programming concepts
VBA Language elements
Range Objects
Bug extermination techniques
Programming concepts
VBA Language elements
Range Objects
Bug extermination techniques
Communicating with your users
Simple dialog boxes
User form basics
User form controls
User form techniques and tricks
Accessing macros through UI
Creating Work sheet functions
Creating excel add-ins

No comments:

Post a Comment