MIS & Business Analytics+Free Advanced SAS Training Course in Delhi|MIS Training Institute in Delhi

Featured

MIS & Data Analyst+Free SAS in Delhi

0 Lessons

Free

Advanced Excel and Data Analysis Training Course

Advanced Excel Certification

Industry-oriented certification MIS and Data Analysis in Excel training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization and corporate.

Experienced Faculty

Professional expert Sr. Lead Analyst / Technical Analyst With 10+ Years of working experience will provide you industrial level training.

Placement Assistance

Receive placement assistance after completion of 70% training, SLA team will arrange interviews till you’ll get the placement.

Lab Facility

You can attain the practical training session to get the indutrial exposure and prepare for the corporate level challanges.

Advanced Excel Workshop

You’ll attain knowledge on bases of real-time scenarios, live projects and best case study to complete SLA workshop.

Admin Support

SLA’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.

What is the correct answer for 28 - 20

MS Excel Training offered by SLA Consultants Delhi is one of the best practical training that is focused on corporate-based job oriented training. MS Excel comes with VBA Macros, and SQL training that enable learners to make a powerful dashboard. If you want to enhance your analytical skill, then MS Excel Training with VBA Macros, SQL is foremost necessary.

Organizations prefer aspirants who have a comprehensive understanding of MS Excel, then practical training will certainly help you out to make an excellent profession in Analytics. Macros, VBA and SQL is an essential part of any analytics associated training program. In MS Excel, VBA Macros, and SQL have multiple applications for tasks like the execution of business logic, automation, manipulation of data, relations amid applications of Office find multiple applications in Excel related tasks such as automation and implementation of business logic in Excel. Aspirants from the different educational background can learn the MS Excel, Visual Basic Application, Macros, and SQL practical training course.

SLA Consultants Delhi designed the course in such a way that enables learners to get hands-on training in an efficient way. SLA gives full admin support to candidates. The instructors help to understand the conceptual as well as technical knowledge to the learners with live projects, practical training with case studies. MS Excel VAB Macros, SQL training is in demand also in those areas where deep analytic skill is not required. Organizations demand candidates with reporting assistance employing MS Excel, VBA Macros, and SQL. SLA Consultants Delhi provides complete training in MS Excel, VAB Macros, and SQL and also an all-inclusive training in Data Analytics and MIS Analytics. If you are serious to make your career in a reputed organization, definitely you must enroll for MS Excel, VBA Macros, and SQL in SLA Consultants Delhi, one of the best ISO certified job oriented training institute that helps learners in every aspect of making a successful career.

MS Excel, VBA Macros, and SQL practical training is a job oriented course offered by SLA Consultants Delhi designed from data analytics expert from the relevant industry. MS Excel, VBA Macros, and SQL training offered by SLA Consultants Delhi is a power-filled course will impact you in what way to create understanding dashboards, SQL and VBA macros through a robust emphasis on case studies to confirm practical knowledge. MS Excel helps to perform data calculation, performing text and logical functions, formatting and conditional formatting, data analysis employing pivot tables, data sorting, filtering, data validation, worksheet and workbook safety, and security, understanding of charts, knowledge of statistical and mathematical functions, overview of Form Controls, Consideration of Data Tools Panel, Macro Recording, etc. Certainly Visual Basic Application teach by SLA Consultants Delhi help to get insightful understanding Error Handling, Automation, Excel Object Model, User-Defined Function, Sub And Function Process, Main Elements Of Programming Language, Object And Memory Management In VBA, ActivexControls, User Form Controls, And Communicating With Database MS Access Through ADO – Exporting/Importing Data etc.

SLA consultants Delhi certainly offers the best MS Excel, VBA Macro, and SQL training and not miss any element of course. All-inclusive training is packed also with Designing Dashboard, Trends, And Setups Using Charts, Instructions, And Tricks To Augment Designing Dashboard, Advanced Charting Techniques By Means Of A Doughnut, Step Chart, Thermometer, Panel Chart, And Pareto Chart, And Designing Sample Dashboard Using Form Controls, etc. As soon as you equipped with the considerably required aids with this MS Excel, VBA Macros, and SQL practical training course, you will get the best understanding to employ these applications to present your skills and gain a competitive advantage over others. SQL help to understand RDBMS Concepts, Database Concepts, Data Integrity Constraints and Types Of Relationships, Queries, Data Types andNULL Values, Operators And Comments In SQL, Data Based Objects Creation, Data Manipulation, Working With Select Statements, And Optimizing Work.

SLA Consultant Delhi is One of the best MS Excel, VBA Macros, SQL training with the suppleness of joining the learning with live projects, experienced instructors, admin support, certificate, lab facility, placement assistance, and workshop sessions. The classes available both weekdays and weekend for fresher as well as working professionals to explore or boost their career with MS Excel, VBA Macros, and SQL training.

Organizations prefer aspirants who have a comprehensive understanding of MS Excel, VBA Macros, and SQL, this practical training will certainly help you out to make an excellent profession.

Excel provides a lot of features that is certainly compulsory for every organization. Organization demand candidate with mandatory skills of MS Excel and if candidate learns VBA Macros, SQL then it is definitely a plus point in boosting their career.

Candidates from different background such as data analyst, finance analyst, consulting job, and business analyst, etc. can learn MS Excel, VBA Macros, SQL training course assuring best hike in career.

Through MS Excel, VBA Macros, and SQL corporate based job oriented training, you can create dashboards, perform logical functions, manipulate data, use of graphs/charts, perform mathematical/statistical functions to make your job or task inefficient manner.

MIS and Data Analysis in Excel Practical with Interview Guarantee Our Trainer:- 10+ Years of industry experience as a MIS Manager in MNC, Education:- B.Tech Course Duration: 85 – 95 (Hours) with Highly Skilled Corporate Trainers (MIS and Data Analytics in Excel Training) for 5 Modules – Weekdays / Weekend

SLA Consultants Delhi – MIS and Data Analysis in Excel Training Delivery Method:

Web / Desktop Base.
Instructor-Led Classroom Sessions.
Presentations/Demonstration/Practicals of concepts.
Handouts/Assignments/Real-time Exposure to work on Clients.

NOTE: Classes Are Also Available On Module Basis

MIS and Data Analysis in Excel Programme Modules

MIS and Data Analysis in Excel Training Course

Module 1 - Basic and Advance Excel

- Introduction to Excel

Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

- Mathematical Functions in Advanced Excel:-

Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

- Date and Time Function in Advanced Excel:-

Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

- Text Functions and Data Validation in Advanced Excel:-

Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data split.

- Statistical Function and Other Functions in Advanced Excel:-

Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

- Logical Functions in Advanced Excel:-

And, Or, If, Iferror, Not, Nested If

- Lookup and Reference Functions in Advanced Excel:-

VLookup, HLookup, XLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

- Logical Functions in Advanced Excel:-

And, Or, If, Iferror, Not, Nested If

- Power Pivot- MIS, Data Analysis and Visualization:-

Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs and Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display

- Data Collection Method in Advanced Excel

With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality

- Analysis Single/Multidimensional Analysis in Advanced Excel

Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table

- Advanced Dashboard in Excel.

Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot

Two Live Report Development in Advanced Excel – (Real World Data)

Module 2 - Macros | VBA and Dashboard

DASHBOARD and VBA / Macros Programming Objective

Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick Decisions.

Dashboards are Often Called as Management Information System (MIS), Which Provides Information that Organizations Require to Manage Themselves Efficiently and Effectively.

To Define KPIs (Key performance Indicator), Customer Service Dashboards or Project Management Dashboard (Gantt Chart)
Dashboard Reports Based on Tables and Number or Charts/Graphs or Both.

Introduction to Programming Introduction to logical thinking flowcharts and algorithms

Define Objective, Start and End Points; Identifying Solution and Breaking it Into Sequential Steps Writing a
Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros – an Introduction

Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic…etc.)

Excel Macro Language Review (VBA) Including Variables, Data Types, Constants, Arrays, Operators, Expressions, Loops, Logic Decisions And Calling
Overview Of Commanding Excel Using VBA Including A Discussion Of Objects, Properties And Methods
The Power of Macros – What, When, How to use Macros. Introduction to Object Oriented Programming
Objects, Its Functions, Methods and Properties Introduction to Events
Details of Events, How and When to use of Events, Preparing to ‘Macro’ Visual Basic Editor (VBE) – Developer Tab, Security
Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use the VBE – Features, Options, Intelligence Technology
Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window Inbuilt VBE Help Feature – Tips and Tricks
Form Controls vs. ActiveX Controls Getting into the Code
Message Box and Input Box Working with Data in Excel through VBA
Data Types, Constants and Variables
Different type of data type; How and When to use Variables to Store Information.
For-Next, For-Each, Do-While, Do until, Do Loop Decision-Making and Code Branching
If-Then-Else, Select-Case, And/or Nested Conditions
What is user’s Defined Functions? How to create and use them.
Use of Arrays in VBA programming with one dimensional, two dimensional or multi-dimensional analysis

Excel VBA Power Programming For VBA Macros

Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files. Opening and Saving Files
How to Analyze Data On Multi Worksheets And Build Summary Sheets
How to Access The Windows File And Folder System To Open And Close Workbooks
How to Protect Your Code Against Error
How to Use Excel And VBA To Create Basic Dash Boards
How to Create Your Own Custom Business Worksheet Functions In VBA
How to Create Basic Report Generation Tools Using Excel VBA, Microsoft Word And PowerPoint
How to Use The Excel Visual Basic Macro Recorder To Record Excel Tasks In VBA And Then Interpret The Code

Overview of Using User forms To Create Business Wizards

Working with User Forms and User Forms Events like List box, Combo box, Option Buttons, Check box, Text box, Labels, Command button, Toggle button.
How to create dynamic dashboard on user form with different controls
How to link various user form with each other to create a complete interface between user and system

Connection between Excel VBA and other platforms

How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website through VBA
How to Establish Connection Between Excel VBA and power presentation to create power point through VBA
How to Establish Connection Between Excel VBA and Access database to update the data in access through VBA
How to Establish Connection Between Excel VBA and outlooks through VBA
How to Establish Connection Between Excel VBA and MS Word through VBA

Testing and Debugging Your Code Effective Error Handling Automation Development Reports and Live Projects

Module 3 - MS – Access and SQL

Access is a relational database management system (RDBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. … It can also import or link directly to data stored in other applications and databases. Introduction to SQL

SQL Course overview
Installing the test environment
What is SQL?
Editors and Platforms to learn SQL

Complete SQL in a Class

Quick-start introduction
Using the basic SELECT statement
Selecting Rows
Selecting columns
Counting rows
Inserting data
Updating data
Deleting data
Import and Export data

Fundamentals of SQL

Databases and tables
SQL syntax overview
Data Definition, Data Manipulation, Data Control, Transactional Control statements
Creating tables
Deleting a table
Inserting rows into a table
Deleting rows from a table
What is NULL?
Controlling column behaviours with constraints
Changing a schema with ALTER
Filtering data with WHERE, LIKE, and IN
Removing duplicates with SELECT DISTINCT
Sorting with ORDER BY

How Relationships Work in SQL

Understanding Joins
Accessing related tables with JOIN
Multiple related tables

Explaining SQL Strings

About SQL strings
Finding the length of a string
Selecting part of a string
Removing spaces with TRIM
Making strings uppercase and lowercase

Numbers and SQL

About numeric types
Finding the type of a value
Integer division and remainders
Rounding numbers

SQL Functions and Clause

The Aggregate functions MIN, MAX, AVG, SUM and COUNT, UPPER, LENGTH, LOWER
The GROUP BY and HAVING clauses Grouping in a combination with joining
Triggers in SQL

Triggers in SQL

Concept of Trigger
Create Trigger for (Insert, Update, Delete)
Alter Trigger

What are Subselects and Views in SQL

Creating a simple subselect
Searching within a result set
Creating a view
Creating a joined view

Maintaining SQL Server Database

Backup Database
Restore Database

SQL Server Job Creation

How to create job in SQL Server Agent
How to schedule job

Topics Covered as follows:

Access environment and tools
Database terminology and concept
Designing database in Access
Understanding RDBMS
Working with the Design side of Tables
- Create Query
- Join Tables That Have No Common Fields
- Work with Subdatasheets
- Create Sub queries
Working with the runtime of Tables
Data Migration and Importing
Working with the Design side of Queries
Working with the runtime of Queries
Working with the Design side of Forms
- Adding Controls to Forms
- Creating Sub forms
- Organizing Information with Tab Pages
- Displaying a Summary of Data in a Form
- Applying Conditional Formatting
Working with the runtime of Forms, Managing Switchboard
Working with the Design side of Reports
- Organize Report Information
- Format Reports Include Charts in a Report
- Add a Calculated Field to a Report
- Add a Sub report to an Existing Report
Working with the runtime of Reports
Working with the Design side of Macros
- Creating a Macro Restricting Records Using a Condition
- Automating Data Entry Using a Macro
Working with the runtime of Macros
How to create a functional specification
Build a real-world business application
Putting altogether and deployment

Module 4 - Tableau / MS Power BI/SAS Base and Advanced ( Free Any One )

Module 4 a) Tableau

Module 1 – Getting Started with Tableau

Overview Of Tableau
Tableau Architecture
Installation And Configuration Of Tableau 10

Module 2 – Connecting to The Data

Managing Metadata
Managing Extracts
Data Sources
Cross-Database Joins
Data Aggregation And Data Ports
Tableau Charts
Bar Charts and Stacked Bars Data Blending
Tree Maps and Scatter Plots
Individual Axes, Blended Axes, Dual Axes and Combinational Chart

Module 3 – Visual Analytics

Drill Down and Hierarchies
Sorting, Filtering and Grouping
Trend and Reference Lines
Forecasting and Clustering
Analysis with Cubes and MDX

Module 4 – Developing First Bar Chart

Connecting Tableau to Data File
Navigating Tableau
Calculated Fields
Adding Colors, Labels and Formatting

Module 5 – Time Series, Maps and Aggregation

Data Extracts and Time Series
Understanding Granularity, Aggregation and Level of Details
Default Location in Maps
Custom Geo Coding
Symbol Map and Filled Map

Module 6 – First Dashboard

Into Section
Joining Data In Tableau
Working With Maps and Hierarchies
Scatter Plot and Applying Filters in Different Sheets
Creating First Dashboard

Module 7 – Blending Data and Dual Axis Charts

Duplicate Values
Multiple Fields
Data Blending
Dual Axis Chart
Building Calculated Fields

Module 8 – Table Calculation and Storytelling

Downloading Dataset and Connection
Mapping
Building Table Calculation For Gender
Bins and Distributions for Age
Tree Map Chart
Advanced Dashboard
Storyline and Storytelling

Module 9 – Data Preparation

Data Format
Data Interpreter
Multiple Columns And Pivot
Metadata Grid
Advanced Data Preparation

Module 4 b) MS Power BI

A Quick Introduction

What is MSPBI and its scope
Learn the common work flow in MSPBI
Building blocks of MSPBI and its relations
Quick demo how to create a business dashboard in MSPBI
MSPBI components
Old vs. new technologies
Power BI Desktop/Service/Mobile

Getting Business Data

Get data in shape for use with MSPBI
Combining two or more data sets (source data) for reporting
Tackling messy data in MSPBI
Clean and transform data

Modelling in Power BI

How to connect many different data sources
Manage data source (database) relationships
Unique keys
Calculated columns and more
Custom calculations to evaluate time-based functions
Build calculated tables based on DAX formulas and expressions
Creating and viewing visuals easier with optimized models
Discover hierarchal drill-down tools for date fields

Data Visualization

Create and customize visualization in MSPBI and its power
Use combination charts
Create and format slicers with it
Map visualizations and its utilization
Use tables and matrixes
Long live bubbles
scatter charts in action
Advanced funnel and waterfall charts
Drive fast dashboard insights with gauges and numbers
Color your visualization world with colors
shapes and scales
Adding personal touch
logo etc. to reports and dashboards
Display and present your dashboard in a way you want with summarize data
Control how your report elements overlap with each other
Learn to drill into hierarchies
Manage how levels are shared (Z-order in reports)
How to use R visuals in MSPBI

Data Exploring and Sharing

Quick insights in Power BI Service
Create and configure a dashboard
Share dashboard with your organization
Display and edit visuals- tiles
full screen
Get more space on your dashboard
Install and configure a personal gateway
Excel and MSPBI
Import and excel table into Power BI
Import excel files with data models and power view sheets
Connect One Drive for business to MSPBI
Excel data in Power BI summary

DAX (Data Analysis Expression) Application

DAX and its basic building blocks
Create calculated columns (fields) and measures in MSPBI using DAX formulas
Breadth of functions available in DAX
User variables in DAX
Create expressions across multiple tables with relational functions;
Filter and evaluate tables using advanced table functions

4.C SAS Base and Advanced

Module 4.1 – SAS Base

INTRODUCTION TO SAS PROGRAMMING

Working in the SAS Environment
Working with the Windows
Enhance Editor
Result Window
Log Window
Explorer Window
Output Window
Program Editor Window

BASICS OF SAS LANGUAGE

SAS Libraries
Data Sets
Cube
Data View
Referencing Files in Catalog
Creating a SAS Program
Components of SAS Program
Characteristics of SAS Program
Layout of SAS Program

ACCESSING DATA

Use FORMATTED, LIST and COLUMN input to read raw data files
Use INFILE statement options to control processing when reading raw data files
Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls
Use SAS functions to convert character data to numeric and vice versa

COMBINING SAS DATA SETS

Concatenation
One-One Merging
Match Merging
One-One Reading
Updating or Setting

CONDITIONAL STATEMENTS

IF and IF THEN statement
IF ELSE statement
Where condition
Like , Into Statements
Loops ( Do, While )

WRITING DATA TO EXTERNAL FILES

File Statement
Put Statement

GENERATING REPORTS

Generate list reports using the PRINT and REPORT procedures

Combine SAS data sets using the DATA step

CREATING SAS DATA SETS

Create temporary and permanent SAS data sets
Create and manipulate SAS date values
Control which observations and variables in a SAS data set are processed and output

DATA STEP PROCESSING

Program Data Vector (PDV)
Execution Phase and Compilation Phase
Get Started with Output Delivery System (ODS)

STATEMENT OPTIONS

Global Statements
Local Statements
List Input
Modified Input
Column Input
Named Input

MANAGING DATA

Exploring SAS data libraries using base SAS utility procedures
Sorting observations in a SAS data set
Conditionally execute SAS statements
Use assignment statements in the DATA step
Modify variable attributes using options and statements in the DATA step
Use SAS functions to manipulate character data, numeric data, and SAS date values
Enhance reports through the use of labels, SAS formats, and user-defined formats
Generate summary reports and frequency tables using base SAS procedures

DEBUGGING AND HANDLING ERRORS

Identify and resolve programming logic errors
Checking for Errors, Warnings, Un-Initialization, missing values
Recognize and correct syntax errors
Examine and resolve data errors

PROCEDURES

Proc Sort
Proc Transpose
Proc Print
Proc Contents
Proc Formats, Proc Compare
Proc Append, Proc Tabulate
Proc Report
Proc Import, Proc Export
ProcFreq
Proc Means

Module 4.2 –SAS Advanced

ADVANCE SAS TRAINING SYLLABUS

Introduction to SAS Macro Language Elements
Introduction to Macro Variables
Automatic Macro Variables
User define Macro Variables
How Macro processing will undergo inside the SAS system
Macro Statements
Macro Functions
Autocall Macros

SAS MACROS

SAS Libraries
Introduction to SAS Macro Language Elements
Introduction to Macro Variables
Automatic Macro Variables
User define Macro Variables
How Macro processing will undergo inside the SAS system
Macro Statements
Macro Functions
Autocall Macros

ACCESSING DATA USING SQL

Introduction to Proc SQL
Generate detail reports by working with a single table or joining tables using PROC SQL

Generate summary reports by working with a single table or joining tables using PROC SQL
Inserting data into Tables
Alter and update the tables
Construct sub queries within a PROC SQL step
SQL pass through Facility
Connecting to DBMS
Natural Joins
Inner Joins
Outer Joins
Access Dictionary Tables using the SQL procedure
Work with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints

MACRO PROCESSING

Creating and using user-defined and automatic macro variables within the SAS Macro Language
Automating programs by defining and calling macros using the SAS Macro Language
Various system options available for macro debugging
Displaying values of user-defined and automatic macro variables in SAS log
Understand the use and implantation of macro functions

Module 5 - Basic SAS

Module 6 - Basic Tableau

Module 7 - R Programming

Module 8 - MS Power BI

Find the Advanced Excel and MIS course details below. Classes and Course can be designed/customize as per request

Duration of Module

Excel Course Module	Duration
Module 1 – Basic and Advanced Excel + Any One (Basic SAS/R Programing /Tableau /Power BI)	25 – 30 (Hours)
Module 2 – VBA / Macros + Any One (Basic SAS/R Programing /Tableau /Power BI)	25 – 30 (Hours)
Module 3 – Access and SQL + Any One (Basic SAS/R Programing /Tableau /Power BI)	25 – 30 (Hours)
Module 1 and 2 – Excel + VBA / Macros	50 – 60 (Hours)
Module 1 and 2 – Excel + VBA / Macros+ Any Two (Basic SAS/R Programing /Tableau /Power BI)	50 – 60 (Hours)
Module 2 and 3 – VBA / Macros + Access and SQL	50 – 60 (Hours)
Module 2 and 3 – VBA / Macros + Access and SQL Any Two (Basic SAS/R Programing /Tableau /Power BI)	60 – 70 (Hours)
Module 1 to 3 – Excel + VBA / Macros Access + SQL	75 – 80 (Hours)
M 1 to 4 – Excel + VBA / Macros Access + SQL + ( SAS Base + Advanced) Any Two (R Programing /Tableau /Power BI)	85 – 95 (Hours)

Batch Timings

Excel Course Schedule	Excel Batch Timing
Monday to Friday	8:00 AM – 10:00 AM
Monday to Friday	10:00 AM – 12:00 PM
Monday to Friday	2:00 PM – 4:00 PM
Monday to Friday	4:00 PM – 6:00 PM
Saturday/Sunday	8:00 \| 12:00 \| 2:00 \| 4:00
Sunday	8:00 AM – 10:00 AM
Sunday	10:00 AM – 12:00 PM
Sunday	2:00 PM – 4:00 PM
Sunday	4:00 PM – 6:00 PM

Download Advanced Excel Course Brochure

Adv Excel, MIS and Data Analysis

VBA Macros-Access and SQL

Data Analytics

Business Analyst Course

FAQ

What are the prerequisites for MS Excel, VBA Macros and SQL Training?

Who should attend this course?

Is the course is corporate based job oriented training program?

What are the career prospects after the completion of the course?

Does SLA Consultants Delhi provide certification for the course?

Will the candidate get assured placement assistance?

Testimonials

Rishu Singh (Aarush)

I had a Great experience with SLA Consultants while Training. I have done PHP training with practical guidance and great support. The PHP course flowed in a step by step and detailed manner which was good for easily understanding and helps in self-practice. After completion of my course, I got really good job opportunities provided by SLA.

Rishu Singh

VcareAll Solution Pvt. Ltd.

Rahul Pal

From my point of view, I’ll strongly recommend SLA Consultants, Training Institute for Analyst courses. I am pursuing my Data Analyst Course from this institute under the guidance & knowledge of Data Analyst trainers, my two modules (advance Excel and VBA) of the course has been completed. I must say, they have good training faculty, as well as have the great infrastructure for learning and practicing.

Rahul Pal

Rohit Bhagat

I strongly recommend SLA Consultants, Training Institute for doing courses. I am doing my Data Analyst course in SLA Consultants-Head Office, till now my two modules(advanced excel and VBA) have been completed. Its been good experience with trainer, shared me a lot of knowledge in brief. At institute the trainers and admin staff is good.

Rohit Bhagat

Deepak Sharma

I have completed Advanced Excel & Visual Basic Automation training course from SLA Consultants. I had amazing experience after completion of the training program and I would like to say thanks to the trainer, who elaborate solution for all the problems very quickly at the same time with very easy Technic to better understanding. Trainers are very kind and helpful. I would like to rank him 5 out of 5. I am so much obliged and feeling grateful, thanks a ton for the great support by trainers and thank you SLA Consultants.

Deepak Sharma

MIS & Data Analyst Executive

Amit Kumar

I hope, my review may help to those who are searching for an institution where they can enhance their skills and get a placement as well. I have joined SLA Consultants for complete MIS course, my trainer is one of the best teacher of my life. Who are searching for an institute joined it immediately without the hassle & wasting your time. The trainer will teach you both theoretical as well as practical knowledge, also prepare you for interviews. The best thing about a trainer is that they help you even after you completion of your course, share queries on e-mail or Whats-App your query and you will get your problem resolved. My overall experience was awesome.

Amit Kumar

MIS & Data Analyst Executive

Vinay Tiwari

My experience in SLA is quite well. I have taken classes for both modules Advance Excel and VBA Macros. Whenever I raised for any doubt and to be honest my all queries and doubt were sorted out patiently. I must say my trainer was quite supportive and patiently explained everything. Even though I have taken classes on weekend basis, but never feel like that the course is running or missing anywhere. And now I am too confident about Excel and VBA after completion of training under expert trainers. I will always recommend everyone to Join SLA Consultants if they are interested in MIS and RPA etc..

Vinay Tiwari

MIS & Data Analyst

Abhishek Bharti

I have great experience in SLA Consultants for Excel and VBA Macros with expert trainers.

Abhishek Bharti

MIS Executive

Hemant Harshwal

I have joined SLA Consultants for Advanced Excel and VBA. Have gone through no. of classes and got good knowledge about Excel and VBA. Our trainer was very supportive and patiently explains everything. He is very cooperative apart of training he also suggests regarding our career.

Hemant Harshwal

Data Analyst

Himanshu Nautiyal

I have done MIS & VBA course form SLA Consultants under the guidance of Anoop Sir, he has a very good knowledge & experience. He is a professional Trainer & his way of teaching is very good. It is great experience for me to grow with my skill & work efficiency. It is very good Platform who wants to build-up their career in MIS. Also thanks to Swati Mam for Co-ordinate with us and help me to find a good platform.

Himanshu Nautiyal

Fortune Marketing Pvt.Ltd.

Rajesh Pratap Singh

I’ve joined SLA Consultants for Advance excel and VBA It helps me to move my career. Especially Anoop Sir is very good teacher and his teaching style is awesome. One thing I want to tell you about new joiners who has no experience in Industry, they can build-up their career platform through SLA Consultants.

Rajesh Pratap Singh

Rahul Kumar

I have done MIS & VBA Training form SLA Consultants under the guidance of MR. ANOOP YADAV, he has a very good knowledge & experience in Corporate & MNC. He is professional Trainer & his way of teaching is as per the corporate requirement. I’d great experience for me to grow my skill & work efficiency. It is very good pelt from who wants to build-up their career in MIS.

Rahul Kumar

MIS Executive at ASIAN COLOUR COATED ISPAT LTD

Neeraj Gupta

SLA Consultants is too good & very helpful. If u want to achieve something in your life so please join today SLA Consultants. Especially I would like to thank faculties & placement team.

Neeraj Gupta

MIS Executive at Shriram Automall India Ltd

Archit Khandelwal

Thanks to SLA consultants for giving me such type of opportunity, Great Institute with great teaching faculty. SLA is one of the class-apart institutions for those who learn something. I got a job in Fortune marketing Pvt Ltd as MIS Executive. SLA give me the confidence of ” I CAN “

Archit Khandelwal

MIS Executive at Fortune Marketing Pvt. Ltd

Anil Kumar

It was one of the best decisions to join SLA consultants for my course. The course that I pursued here was very well planned and executed. I’m highly satisfied with Anoop Sir. The lectures were easy to understand & industrial based & every doubt of mine was properly explained. I would recommend SLA consultants to all those who are willing to grow in their careers and do well.

Anil Kumar

MIS Coordinator at IQOR

Kumar Gautam

I joined MIS/VBA training at SLA. This type of practical oriented classroom training is very helpful & who’ll follow Anoop sir classes with this approach ensures that they will learn completely about subject in short period of time. “SLA Consultants” is the best for learning job-oriented classroom programs. Thanks to Anoop sir and Swati for the best placement support.

Kumar Gautam

MIS Coordinator at IQOR

Ummed Ali

SLA Consultants is better institute to learn practical training courses than any others. it provides the best training to their students. The teaching staff is very knowledgeable especially Anoop Sir for MIS and VBA courses. I learned a lot there and better career path.

Ummed Ali

MIS Executive at Evaxo pharma Pvt. Ltd

Bhavani Singh

The experience with SLA was phenomenal. It trained me to become industry ready and exposed me to various important work practices. The staff is extremely cordial and cooperative. The faculty members are the experienced and experts in the subjects taught by them. I thank SLA for the quality services and placement assistance provided by them.

Bhavani Singh

MIS Executive at G.D. FOODS MFG. (I) PVT LTD.

Anil Kumar Pal

Thanks to SLA consultants, my company values me a lot. I can churn out data from a huge database within a few minutes and keep the management happy. The ever cooperative trainers of SLA have made me capable of doing that and I will be grateful to them.

Anil Kumar Pal

MIS Executive at Recharge it Now

Priyanka Tiwari

I did not know what to do in life. Then I saw the ad of SLA Consultants. After getting knowledge of all their course offerings, I selected MIS and loved it from the start. Thank you for making my career and helping me get a good life SLA.

Priyanka Tiwari

MIS Executive at Concepts & Solutions

Santosh Kumar

When I joined, I didn’t have a clue about MIS Management and now my friends call me an expert of MIS. All thanks to SLA Consultants who filled me with great knowledge and software training without charging a lot of money.

Santosh Kumar

MIS Executive at Jai Shree Stationers Pvt. Ltd.

Kapil Negi

Data Management has always attracted me. SLA Consultants turned this hobby in a professional skill by teaching me all about MIS Management. I got a good job now and I am very happy with my life.

Kapil Negi

MIS Executive at Genpect

Aditya Pratap

I’ve completed the MIS training from SLA Consultants and now I believe that SLA provides the excellent & quality training. I got placed in a reputed company with complete placement support provided the SLA placement team.

Aditya Pratap

MIS Executive at CS Datamation Research Services Pvt Ltd

Avinash

The team of trainers working with SLA is amazing. The support staff is always there to help and Arbind Sir was a great guide. I will never forget my time at SLA and I thank them for the job they helped me get after I completed my course.

Avinash

MIS Executive at Serco Global Services

Tegbahadur Singh

My love for Data Management was turned into a career opportunity by SLA Consultants. They helped me learn all latest MIS software and made me a champion of Data Management. I have a great career path thanks to the SLA Team.

Tegbahadur Singh

MIS Executive at Renovision Automation

Sushil kumar yadav

Thanks to SLA consultants, my company values me a lot. I can churn out data from a huge database within a few minutes and keep the management happy. The ever cooperative trainers of SLA have made me capable of doing that and I will be grateful to them.

Sushil kumar yadav

MIS Executive at Bharti Infratel

Rajbir Sharma

SLA Consultants played the role of a friend, philosopher and guide in my career. They helped me learn complex software and complicated terminologies in such a manner that I now excel at MIS Management. I also love the job they have helped me get.

Rajbir Sharma

Sr. MIS Executive at Computer Junction Pvt. Ltd.

Pawan Gupta

I think SLA Consultants is the best place for skill development. They made me a professional from a fresher and I have seen them do the same for hundreds of students. I highly recommend them to very student or professional seeking career growth.

Pawan Gupta

MIS Executive - Rosmerta Technology Ltd.

Anand Kumar Jha

MIS Executive - Rosmerta Technology Ltd.

Nazia Praveen

From the first day I entered the office of SLA Consultants, they helped me. I completed the admission process swiftly and started learning MIS whenever it was convenient. Now I am working in a full time job that’s not hectic but enjoyable.

Nazia Praveen

MIS Executive - Globalite Retails Pvt Ltd

Hariom Agarwal

The staff, trainers, and management of SLA Consultants is great. These people really help freshers like me to get a good job. They have changed thousands of lives and I am happy to say that mine was also changed by them. So thank you.

Hariom Agarwal

MIS Executive - Globalite Retails Pvt Ltd

Indresh Kumar

I didn’t know anything about MIS management when I joined SLA Consultants. They helped me to learn the craft of managing, sorting and presenting data and now I am a valuable asset in my company. Thank You, SLA Consultants. I will always be grateful to you.

Indresh Kumar

MIS Executive - Recharge it Now

Md Sadik

SLA Consultants played the role of a friend, philosopher and guide in my career. They helped me learn complex software and complicated terminologies in such a manner that I now excel at MIS Management. I also love the job they have helped me get.

Md Sadik

MIS Executive at Evaxo Pharma Pvt. Ltd.

MIS & Data Analyst+Free SAS in Delhi

Advanced Excel and Data Analysis Training Course

SLA Consultants Delhi – MIS and Data Analysis in Excel Training Delivery Method:

NOTE: Classes Are Also Available On Module Basis

MIS and Data Analysis in Excel Programme Modules

MIS and Data Analysis in Excel Training Course

DASHBOARD and VBA / Macros Programming Objective

Module 4 a) Tableau

Module 1 – Getting Started with Tableau

Module 2 – Connecting to The Data

Module 3 – Visual Analytics

Module 4 – Developing First Bar Chart

Module 5 – Time Series, Maps and Aggregation

Module 6 – First Dashboard

Module 7 – Blending Data and Dual Axis Charts

Module 8 – Table Calculation and Storytelling

Module 9 – Data Preparation

Module 4 b) MS Power BI

A Quick Introduction

Getting Business Data

Modelling in Power BI

Data Visualization

Data Exploring and Sharing

DAX (Data Analysis Expression) Application

4.C SAS Base and Advanced

Module 4.1 – SAS Base

INTRODUCTION TO SAS PROGRAMMING

BASICS OF SAS LANGUAGE

ACCESSING DATA

COMBINING SAS DATA SETS

CONDITIONAL STATEMENTS

WRITING DATA TO EXTERNAL FILES

GENERATING REPORTS

CREATING SAS DATA SETS

DATA STEP PROCESSING

STATEMENT OPTIONS

MANAGING DATA

DEBUGGING AND HANDLING ERRORS

PROCEDURES

Module 4.2 –SAS Advanced

ADVANCE SAS TRAINING SYLLABUS

SAS MACROS

ACCESSING DATA USING SQL

MACRO PROCESSING

Module 7.1- Introduction to Business Analytics

Module 7.2- Introduction to R

Find the Advanced Excel and MIS course details below. Classes and Course can be designed/customize as per request

Duration of Module

Batch Timings

Download Advanced Excel Course Brochure

FAQ

Testimonials

Related Courses