Industry-oriented certification MIS & Data Analysis in Excel training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate.
Professional expert Sr. Lead Analyst / Technical Analyst With 10+ Years of working experience will provide you industrial level training.
Receive placement assistance after completion of 70% training, SLA team will arrange interviews till you’ll get the placement.
You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.
You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete SLA workshop.
SLA’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.
MIS & 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 & Data Analytics in Excel Training) for 5 Modules – Weekdays / Weekend
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.
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
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 & Ungroup, Data split.
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
And, Or, If, Iferror, Not, Nested If
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
And, Or, If, Iferror, Not, Nested If
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 & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display
With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
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
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
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.
Introduction to Programming Introduction to logical thinking flowcharts & algorithms
Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic…etc.)
Excel VBA Power Programming For VBA Macros
Overview of Using User forms To Create Business Wizards
Connection between Excel VBA & other platforms
Testing and Debugging Your Code Effective Error Handling Automation Development Reports & Live Projects
Complete SQL in a Class
Fundamentals of SQL
How Relationships Work in SQL
Explaining SQL Strings
Numbers and SQL
SQL Functions and Clause
What are Subselects and Views in SQL
Maintaining SQL Server Database
SQL Server Job Creation
Topics Covered as follows:
|MIS Course Module||MIS Course Duration|
|Module 1 – Basic & 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 & SQL + Any One (Basic SAS/R Programing /Tableau /Power BI)||25 – 30 (Hours)|
|Module 1 & 2 – Excel + VBA / Macros||50 – 60 (Hours)|
|Module 1 & 2 – Excel + VBA / Macros+ Any Two (Basic SAS/R Programing /Tableau /Power BI)||50 – 60 (Hours)|
|Module 2 & 3 – VBA / Macros + Access & SQL||50 – 60 (Hours)|
|Module 2 & 3 – VBA / Macros + Access & 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)|
|MIS Course Schedule||MIS Batch Timing|
|Sunday – Thursday||09:00|11:00|2:30|4:30|
|Saturday & Sunday||09:00|11:00|2:30|4:30|