"SAS, Advance Excel, VBA & MIS" is no longer available

No Reviews Yet

Indirapuram, Delhi

Course ID: 11542

Indirapuram, Delhi

No Reviews Yet

Date and Time

Not decided yet.

About Akshay Kumar (sas certified)

Mr. Akshay has 5 Yrs. of working experience in data analysis and contributed growth to various organisations. Currently, he is working with Barcleys Bank As Business Analyst.
>> 5 Yrs. of exp in SAS and SAS Macro, SQL
>> VBA is an added advantage of Mr. Akshay
No reviews currently Be the First to Review

About the Course

Since MIS Plays vital role for the growth of an organisation. We've created a bunch of MIS tools which will help you creating attractive MIS reports, plans, organisational analysis, HR practices and many other financial reports.

Topics Covered

Accessing Data
Managing Data
Summarizing Data
Reading and Writing Different Data Types
Data Transformations
Debugging Techniques
Processing Data Iteratively
Combining SAS data sets
Analyzing Data
Presenting Data

SASĀ® Macro Language
Macro Variables
Macro Definitions
Data Step and SQL Interfaces
Macro Programs

SQL Processing with SASĀ®
Basic Queries
Combining Tables
Creating and Modifying Tables and Views

Focus on real scenarios of Reporting / Data Management / Automation
Difference between basic and advance Excel
Advance Formulas
Data Management and Analysis
Reporting Techniques
Pivot Table, Macros
Concepts of VBA
Excel Data Handling with VBA
Use of SQL Queries
User Form, List Box, Combo Box, Buttons etc.
Application Design
Database, Tables, Fields and Properties
SQL Queries, Reports and Data Management
VBA Programming and Data Management
Forms, Reports & Application Design

Who should attend

Marketing Professionals, HR, Organizational Heads, Finance Personnel, Business Heads


>> Knowledge of Basic Excel will be an added advantage for the candidate
>> If the candidates have prior knowledge of data handling, will be good for VBA parts.

What you need to bring

>> Laptops preferably if required
>> Notepads
>> Pens / Pencils

Key Takeaways

On completion of the course, students will have,
>> In-depth in SAS, Excel, VBA and MIS
>> Reports, Charts, Functions


No reviews currently Be the First to Review


Post your requirement and let us connect you with best possible matches for SAS Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more