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

50 %
50 %
Information about MIS & Data Analysis in Excel & Access Training Classes in Delhi

Published on January 10, 2018

Author: talentmagnifer

Source: authorstream.com

slide 1: MIS Data Analysis in Excel Access Training Classes www.talentmagnifier.com slide 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 slide 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 customer’s 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 won’t 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 slide 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. o Other major aspects of the training include o Projector based classroom for better comprehension o Real time training session and workshop to practice their learning o Highly friendly and responsible admin support o Regular projects and assignment to test your knowledge o Weekend classes as preferred by the learners o Regular assignments and simple tests are organized to judge your skills o Workshop Exposure www.talentmagnifier.com slide 5:  Course Details I. Module- Basic Advance Excel Training o Introduction to Advanced Excel – Mathematical Functions Date Time Function Text Functions Data Validation Statistical Function Other Functions Logical Functions Lookup Reference Functions o Pivot Table and Charts - Import and Export data Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display. o Data Collection Method With Data Quality - Collaboration Security Like Share Your Workbook On Share Drive With Quality o 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 o Advanced Chart Technique - How To Make Dynamic Charts Bar Charts Pie Charts Scatter Chart Line Chart Column Chart Speedometer Chart Gantt Chart. o Advanced Dashboard. o Report Development o Live Project Session. www.talentmagnifier.com slide 6: II. Module - VBA-Macros Dashboard Programming o What is VBA How VBA Works with Excel o Programming Concepts o Decision Makers o Other Kinds of Loops o Workbook Objects Create or Add Single and Multiple Workbooks o Worksheet Objects insert a single and Multiple Worksheets o Cell objects insert Single and multiple Row Column and Cells o Reading and Writing Arrays o Form Controls and User Forms Create and Design an user Form o VBA Programming Functions o Excel VBA Power Programming for VBA Macros o Connection between Excel VBA other platforms o Effective Error Handling o Automation Development Reports Live Projects www.talentmagnifier.com slide 7: III. Module - MS Access SQL MS Access is a Microsoft Relational Database Management System RDBMS - Topics Covered as follows: MS - Access:- o Understanding Databases o Creating Tables o Working with Tables o Designing a Form o Designing a Report o Creating and Using Queries o Automating Tasks SQL:- o SQL Overview o SQL SELECT statements o SQL Functions and Expressions o SQL Updating o SQL Joins o SQL Sub Queries and Unions o SQL Summarization www.talentmagnifier.com slide 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 www.talentmagnifier.com Live Practical Training with Job Assistance 9999420394 | 9999420393 https://www.talentmagnifier.com/ slide 9: Talent Magnifier 401 4th Floor D-30 Siddharth Complex Near Laxmi Nagar Metro Station Opp Metro Pillar No. 33 Nearest Domino’sLaxmi Nagar New Delhi – 110092 Contact us +91 9999420394 +91 9999420393 Email :infotalentmagnifier.com Website:www.talentmagnifier.com

Add a comment

Related presentations