Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

SAS, Advance Excel, VBA & MIS

No Reviews Yet

Indirapuram, Delhi

Course ID: 11542

Indirapuram, Delhi

₹ 25,000

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

SAS TOPICS
Introduction
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
Introduction
Macro Variables
Macro Definitions
Data Step and SQL Interfaces
Macro Programs

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

ADVANCE EXCEL, VBA AND MIS TOPICS
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

Pre-requisites

>> 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

Reviews

No reviews currently Be the First to Review

Discussions

₹ 25,000

Post your requirement and let us connect you with best possible matches for SAS Training classes Post your requirement now
₹ 25,000 Enquire