Title: MIS & Data Analysis in Excel & Access Training Classes in Delhi NCR
1MIS Data Analysis in Excel Access Training
Classes
www.talentmagnifier.com
2- About MIS Data Analysis Excel Access
- We understand that every organization wishes to
remain in the top position in the market and in
order to accomplish that, the most important
resource they can use is information. However,
acquiring such vital information and then
evaluating and filtering it to make it more
useful for the company require talent and skills.
By attending this prestigious MIS Analysis in
Excel Access Training Course, the learners will
be able to gain a thorough comprehension on the
subject through our real time training session.
During their time in the institute, the
applicants will learn to collect data from
different sources, evaluate, manage and implement
it as per the requirements of the company so that
the management could make better financial and
other decisions to enhance the productivity of
the organization. Our industry experienced and
certified trainers will guide you during your
entire period in the institute and help you
understand the strategic planning, management
control and transactions processing processes in
which MIS plays a significant role. They will be
able to operate MS Excel, MS Access and SQL
Server with ease and expertise as these tools
comes very handy in handling large amount of data
and presenting it in a more suitable manner.
www.talentmagnifier.com
3- Why Learn MIS ?
- No one needs to be explained on the importance of
information for any business organization.
gathering information from the marketplace and
customers allows the organization to understand
the market condition, competitors activities,
customers behavior and factors that could affect
their business in more than one way. Without
proper studying these things, a company cannot
achieve success in the market and wont be able
to fulfill the requirements of the customers. MIS
offers the management some hard proof on the
current situation and structure of the
organization and what possible measures are
necessary to be performed to improve the
performance and productivity of the company. It
allows the company to collect, store and manage
important data using different systems and tools
and understand the challenges they can face until
they succeed. - After learning all these benefits MIS can provide
to the company, it is understandable why many
college learners are pursuing this line as their
career. Furthermore, choosing MIS as a career
open many more path for you such as business
analysis or consultant, business process
engineer, system analyst, database administrator,
etc. Plus, the pay in this sector is certainly
good that adds to the motivation.
www.talentmagnifier.com
4- Program Detail
- MIS Training Course is an important and highly
sought after course in the current market due to
its significance for the business organizations
and the individuals with certain abilities. It
involves collecting relevant information from
different sources and managing it wisely using
different systems. This will be taught during
this entire course and some of the crucial
details regarding the course are as follows - The duration of the course is 75 - 80
hours separated ideally in weekends and weekdays,
depending on the students preference. Other
major inclusions of the training include
instructor led classroom with projector and PPT
availability, certification offered after the
successful completion of the course. - Live practical sessions will be held on a regular
basis to test your learnings along with handouts
and assignments. 100 Job placement assistance
also makes this course a must for aspiring
candidates. - Other major aspects of the training include
- Projector based classroom for better
comprehension - Real time training session and workshop to
practice their learning - Highly friendly and responsible admin support
- Regular projects and assignment to test your
knowledge - Weekend classes, as preferred by the learners
- Regular assignments and simple tests are
organized to judge your skills - Workshop Exposure
www.talentmagnifier.com
5- Course Details
- I. Module- Basic Advance Excel Training
- Introduction to Advanced Excel
- Mathematical Functions
- Date Time Function
- Text Functions Data Validation
- Statistical Function Other Functions
- Logical Functions
- Lookup Reference Functions
- Pivot Table and Charts - Import and Export data,
Protect/Unprotect sheets/workbooks. Worksheet
formatting and Print Display. - Data Collection Method With Data Quality
- Collaboration Security Like Share Your
Workbook On Share Drive With Quality - Analysis - Single/Multidimensional Analysis, 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 Chart Technique - How To Make Dynamic
Charts, Bar Charts, Pie Charts, Scatter Chart,
Line Chart, Column Chart, Speedometer Chart,
Gantt Chart. - Advanced Dashboard.
- Report Development
- Live Project Session.
www.talentmagnifier.com
6- II. Module - VBA-Macros Dashboard Programming
- What is VBA How VBA Works with Excel?
- Programming Concepts
- Decision Makers
- Other Kinds of Loops
- Workbook Objects Create or Add Single and
Multiple Workbooks - Worksheet Objects insert a single and Multiple
Worksheets - Cell objects insert Single and multiple Row ,
Column and Cells - Reading and Writing Arrays
- Form Controls and User Forms (Create and Design
an user Form) - VBA Programming Functions
- Excel VBA Power Programming for VBA Macros
- Connection between Excel VBA other platforms
- Effective Error Handling
- Automation Development Reports Live Projects
www.talentmagnifier.com
7- III. Module - MS Access SQL
- MS Access is a Microsoft Relational Database
Management System (RDBMS) -Topics Covered as
follows - MS - Access-
- Understanding Databases
- Creating Tables
- Working with Tables
- Designing a Form
- Designing a Report
- Creating and Using Queries
- Automating Tasks
- SQL-
- SQL Overview
- SQL SELECT statements
- SQL Functions and Expressions
- SQL Updating
- SQL Joins
- SQL Sub Queries and Unions
- SQL Summarization
www.talentmagnifier.com
8Course Time Duration Details
Course Modules Duration (Hours) Duration (Month)
Module 1 - 3 75 - 80 Hours 2 - 3 Months
Module 1 - 2 50 - 60 Hours 1 - 2 Months
Module 2 - 3 50 - 60 Hours 1 - 2 Months
Module 1 25 - 30 Hours 1 Month
Module 2 25 - 30 Hours 1 Month
Module 3 25 - 30 Hours 1 Month
- Live Practical Training with Job Assistance
_at_ 9999420394 9999420393 -
https//www.talentmagnifier.com/
www.talentmagnifier.com
9Talent Magnifier,401, 4th Floor, D-30, Siddharth
Complex, Near Laxmi Nagar Metro Station, Opp
Metro Pillar No. 33, Nearest Dominos,Laxmi
Nagar, New Delhi 110092
Contact us ,91 9999420394 91
9999420393Email info_at_talentmagnifier.com Website
www.talentmagnifier.com