Call Us Today! +91 99907 48956 | info@analyticstraininghub.com
MIS Certification Course
A management information system (MIS) is a computer system consisting of hardware and software that serve as the backbone of these operations. The major function of MIS is to gather information from multiple systems, soon after gathering the information, then it analyses the information and reports the data which eventually assist in decision making. MIS can be simplified as a collection of systems, hardware, procedures and people. All these segments work together to store, process and produce information that is useful to the organization.
Download Brochure
Instructor -Led Online & Physical Classes
| Batch Start Date | Class Type | Upcoming Slots | Timings | Location |
|---|---|---|---|---|
| 5th Sep 2021 | Online | Sold Out SAT & SUN | 10:30 PM to 12:30 PM | Online |
| 25th Sep 2021 | Online | Seats are filling fast⚡ SAT & SUN weekend batch | 10:30 PM - 12:30 PM | Online |
| 10th Oct 2021 | Online | SAT & SUN weekend batch | Morning Slot | Online |
Can’t find a batch you were looking for?
Course Details
Microsoft Excel
- Introduction to Excel 2013/2016/2019/Office 365
- Application Interface and Key Components of Excel
- Navigating Through Excel Ribbon Tabs
- Exploring Important Excel Options*
- Live Session Exercise
- Splitting data of Single Column into multiple
- 10 Examples to use Auto-fill and Flash Fill
- Magics of Go-To Special
- Merge/Unmerge Cells & Wrap Text
- Extracting Unique Values & Important Ribbon, General and Data Entry Keyboard Shortcuts
- Formatting Essentials Introduction
- Custom Cell Number Formats
- Custom Date/Time Formats
- Working with Comments / Notes
- Format Painter – A Quick way to copy ‘Formatting Attribute’
- Paste Special
- Table, Table Styles & Formatting
- Freeze Panes
- Introduction to Excel Functions and Formulas
- Basics of Functions & Formulas
- Working with Cell References Types
- Most Used Basics & Advanced Functions & Formulas
- Working with Array Formulas
- Creating Customize Formulas Step-by-Step with Live examples
- Creating and Working with Dynamic Ranges using Function and Excel Table features
- Formulas Debugging / Formulas Auditing
- Types of Formula Errors / Error Handling Tricks
- Text Functions: – CLEAN, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, and TEXT etc.
- Date & Time Functions: – DATE, DAYS, TIME, NOW, WEEKNUM, WORKDAY, and WORKDAY.INTL etc.
- Math & Trig Functions: – INT, MOD, ROUND, ROUNDDOWN, SUMIF, SUMIFS, SUMPRODUCT etc.
- Statistical Functions: – AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN, LARGE etc.
- Logical Functions: – IF, IFS, AND, OR, and IFERROR.
- Lookup & Reference Functions: – FORMULATEXT, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, and OFFSET
- Newly Introduced Functions in Recent Version of Excel*: – CONCAT, TEXTJOIN, IFS, SWITCH, DGET, UNIQUE, FILTER etc.
- Nested Conditions/Customize Formulas*
- Data Sorting
- Data Filtering
- Named Ranges
- 10 different ways to use Conditional Formatting
- 10 different use of Data Validation
- What-If Analysis
- Introduction to Excel Charts
- Exploring most commonly used Charts and Templates
- Basics of Charts
- Selecting Requirement based Charts
- Working with Basic Charts:
- Creating Customized / Advanced Charts
- Creating Dynamic Chart
- Working with Dynamic Interactive Charts in Excel using Drop Down
- Working with Chart Elements, Formatting, Chart Styles, Properties etc.
- Introduction to Pivot Table
- Creating a Pivot Table
- Use of Calculated Fields/Items
- Pivot Table Formatting
- Grouping Items & Summarizing data in Pivot Tables
- Grouping and Bucketing data in Pivot Table
- Changing/Modifying Data Sources
- Working with Pivot Table Designs & Layouts
- Exploring Important Pivot Table Options & Field Settings
- Pivot Table Filters
- Changing Pivot Table Summary Calculation
- Use of Slicers in Pivot Table
- Using Source Data to Convert into Infographic Summary
- Introduction to Pivot Charts
VBA & Macros
- Quick Recap of Microsoft Excel
- Introduction to Developer Ribbon Tab
- Introduction to VBA
- What is VBA / Macro in Excel?
- Introduction to Visual Basic Editor Window
- Getting Familiar with Visual Basic Editor (VBE)
- Customizing the VBE Environment
- The Macro Recorder
- Executing / Modifying Recorded Macros
- Saving Macro Workbook
- Introduction to Sub and Function Procedures
- Introducing the Excel VBA Object Model (A must know thing to become Pro in VBA)
- Properties and Methods
- Important and Useful Properties of Application Object
- Working with Ranges Objects
- Working with Comments
- Variable, Data Types and Constant
- Finding Last or Next available Row/Column
- Selecting Rows/Columns/Table (Normally & Dynamically)
- Introduction to VBA Loops & Conditional Statements
- Working with Conditional Statements
- Working with Loops
- Working with Message & Inbox Box
- With-End with Constructs
- Controlling Program Flow
- Introduction to Arrays
- Introduction to Excel VBA Functions and Worksheet Functions
- Difference between R1C1 and A1 style referencing
- Difference between Worksheet Functions Vs Active.cell Formula
- Getting started with VBA Excel Functions
- Getting started with WorksheetFunction
- Working with Function Procedures
- Getting started with User Defined Functions (UDF)
- Fixing arguments of Formulas in VBA
- Working and Creating Customize Functions
- Error Handling & Debugging Techniques
- User Form Introduction
- Exploring Form Controls & ActiveX Controls
- Exploring UserForm Controls
- Cycle/Sequence to follow to create UserForm
- Validating User Inputs
- Testing a UserForm
- User Form Tricks
- Understanding User Form Events
- Working with Pivot Tables
- Charts
- Sorting & Filtering
- Add-Inns
- Type of different Excel events
- Starting an application from Excel
- Interacting with Microsoft Office Apps
- Controlling Excel from another application
- Sending Personalized emails via Outlook
- Sending e-mail attachments from Excel
- Working with Files & Folders
- Converting / Saving Excel File into PDF
My SQL
- An Introduction and Overview of MySQL
- Installation and GUI Tools
- An Overview
- Introducing SELECT statement
- Introducing WHERE clause
- Sort result with ORDER BY
- Using FROM to specify the source tables
- Importance of Clause Orders
- Data Modification tricks
- Creating a database
- Creating a table
- Creating Indexes
- Controlling column behavior with constraints
- Using foreign key constraints
- Creating an ID column
- Changing a schema with ALTER
- Introducing NULL and NOT_NULL
- Introduction to MySQL Data Types
- Setting up default values
- MySQL Warnings
- Alerting a table
- Introduction to MySQL Functions
- String Functions – CONCAT, SUBSTRING, REPLACE, REVERSE, LENGTH, UPPER, LCASE etc.
- Aggregate Functions – COUNT, MIN, MAX, SUM, AVG, ROUND etc
- Date/Time Functions – CURDATE, CURTIME, CURRENT_DATE, LOCALTIME etc.
- Control Flow Functions – IF, IFNULL, NULLIF etc.
- Introduction to JOINS
- Different types of JOINS
- JOINS and Aliases
- Multiple Table Joins
- Creating a simple Subselect
- Understanding of Primary keys and Foreign keys
- Transactions & Stored Routines
- Triggers
- Creating a New User Login
- Granting access to new users
- Backup and Restore databases
- Important Keyboard Shortcuts Guide
- Session Study Material
- Situational Case Studies for Best Practice and Getting Ready for Corporate World
- 6 Months Live Support via Phone/Email/Messages
MIS Training Features
Instructor-led Sessions
40 Hours / 20 Sessions / 10 Weeks
Per Session for 2 Hours
80 Hours for Assignments
Real-life Case Studies
We have included unlimited real life examples and case studies in our course
Assignments
After completing every session you will get assignments, study material & real life based case studies
100% Job Assistance
You will get 100% Job Assistance from us
Why Do You Need MIS Training Course?
Skills in Demand
Data Visualization skills give you the ability to design professional-level Dashboards. You can build complex reports if you have knowledge of Power BI. However, with the knowledge of Power BI , you can do more.
Employability Increases
Now a days companies are preferring those candidates for data management profile who has good skills of Microsoft Excel, VBA, My SQL & Power BI. Many companies heavily depend on these programs for Data Analysis along with visualization.
Job opportunities on the rise
Now, every brand & company has presence at social media that it why Data Analyst demand is increasing everyday. This makes it is a wise career move that has a future in business.
Student Reviews
FAQ's
If you are asking why you should do this program then don’t do it.
As we can see Data profile demand is increasing every day because data is the new oil for every business. And these skills are very basic now so every company prefer their every employee should have at least these basic skills, for more detail you can connect with one of our team members at #919650308956
Of course. This course will give you a head start toward a brilliant professional life.
Though we have so many reasons to join us, let us highlight main points:-
- After completing the course you will 3 months of support time period extra to revise the sessions which are not cleared to you, any problem you are not able to solve that you can take our team’s help
- We provide video recordings if any of the reason you skip your session
- We have well-experienced trainers to teach our students
- Project-based training / unlimited examples to make you understand about the subject / Case Studies after every session / Job Support and many more
Yes, of course, you will be getting “Completion Certificate”
Anyone can learn this program, as these are the basic tools now so everyone should have knowledge of these tools, for more detail please call us @ 9650308956
Obviously career opportunities are going to be increased after completing this course for both Data Management professionals or Non-Data Management professionals.
But yes who all are into Data Management profile they have to learn many more applications to compete in their domain, please have a look
Recommended Courses
Need help? Call our support team 7:00 am to 10:00 pm (IST) at (+91 999-074-8956 | 9650-308-956)