MIS & Data Analysis in Excel & Access Training Classes in Delhi NCR

1
MIS 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
8
Course 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
9
Talent 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