Learning Outcome
- Learn to use the features of Microsoft Office 2016 to create professional looking documents, spreadsheets and presentations.
- Work with various forecasting, analytical and financial functions and features in Microsoft Excel 2016
- Build rich and attractive presentations using advanced features of Microsoft PowerPoint 2013.
- Implement queries and reports in Microsoft Access 2013 and understand how to store and maintain data.
- Learn how to use various web productivity tools by Google.
- Learn the fundamentals of IT programming.
- Develop, test and modify VBA procedures (macros)
- Learn business accounting and inventory management tally software that provides various facilities like multilingual operations, online functions and processing for small and medium businesses.
Who This course is for?
- MIS Aspirants
- Management Graduates
- Want Data Management Expertise
- Want a career in MIS, Data Analytics & Data Management
Best MIS Training in Pitampura Delhi & Best MIS Training Institute in Pitampura Delhi
4.90 out of 5
based on 9599 ratings.
5 Student Rating.
A Management Information System (MIS) provides organization with the information they require in an organized manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory.
This training will provide the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology, which is MACRO-Automation.
Our MIS course is divided into two terms. The first term covers skills required for Office automation and web productivity tools. The second term trains you in programming principles & techniques and automated financial accounting.
APTECH Pitampura Delhi - the best MIS training institute in Pitampura Delhi provides the best MIS training in Pitampura Delhi based on the latest industry requirements and standards, Ans thus helps the students to acquire their dream jobs and best career at various MNCs with attractive salary packages.
APTECH Pitampura Delhi’s MIS certification course in Pitampura Delhi has been designed by professional as per latest industry requirements keeping in view the advanced MIS course content and whole syllabus is based on the professional requirement of the student in order to help them get placed in Multinational companies and achieve their career goals.
APTECH Pitampura Delhi is one of the Oldest MIS training centers in Pitampura Delhi with best infrastructure and lab facilities. APTECH Pitampura Delhi trains and develops best of MIS learners transforming them into thorough professionals at very reasonable MIS training fees, keeping in mind the training and course content requirement of each student.
APTECH Pitampura Delhi is the best MIS training institutes in Pitampura Delhi that provides 100% placement support and training to all students at affordable MIS training fees. APTECH Pitampura Delhi also provides fast track MIS training classes in Pitampura Delhi.
Term 1
Office Automation
- Starting with Windows Operating System
- Creating Folders and Files in Windows Operating System
- Installing and Removing Programs
- Starting with Office 2016
- New Features of Office 2016
- Using Microsoft Word 2016
- Styling Documents in Word 2016
- Using Shapes, Pictures and Word arts in Word 2016
- Reviewing Documents
- Templates and Forms in Word 2016
- Mail Merge in Word 2016
- Using Microsoft Excel 2016
- Formulas and Functions in Excel 2016
- Analyzing data in Excel 2016
- Starting with Microsoft PowerPoint 2016
- Creating PowerPoint Presentation in PowerPoint 2016
- Transitions and Animations in PowerPoint 2016
- Using Microsoft Outlook 2016
- Configure Outlook 2016
- Sending and receiving E-mails in Outlook 2016
Financial Analysis using Excel 2016
- New Features of Excel 2016
- Customizing Ribbon and Quick Access Bar
- Flash Fill, AutoFill and AutoComplete
- Worksheet Protection and locking/unlocking of cells
- Sharing Workbooks
- Formula Precedents and Dependents
- Iterative Calculations
- SUMIFS(), COUNTIFS() and basic counting functions
- Mathematical, Trigonometry, Statistical, and Financial functions
- Text, Logical, and LookUp functions
- Quick Analysis Tool for Data Analysis
- Data Consolidation
- Charts and Different types of Charts
- Chart elements, Chart Area, Plot Area, and Chart Axes
- Chart Title, Legend, and Gridlines
- Trendline and Data Series
- Conditional Formatting
- Sparklines
- Pivot Table and Pivot Charts
- Power View
- Analysis Toolpak
- Correlation and Covariance
- Histogram and moving average
- Goal seek and Solver for what-if analysis
- Automatic Data Processing using Macros
- Creating and Running Macros
- Assigning Macro to a command button
- Macro Security and Add-ins
- Creating Forms
Advanced Presentation Techniques
- Create, Save and Pin Presentation
- Apply Transition Effects to Slides
- Slide Sections
- Animations in a Presentation
- Notes and Handouts
- Set up a slide show and rehearse timings
- Create self-running and custom slide shows
- Record a slide show and add narrations
- Share a presentation
- Broadcast a presentation
- Converting a presentation into a video
- Export a presentation as a Word file and as a PDF
- Insert Audio and Video in a presentation
- Presenter View
Data Management using MS Access
- Overview of DBMS and RDBMS
- Starting with MS Access 2016
- Creating a database
- Tables, Data Types, Fields and Field Properties
- Data Entry Validations
- Sorting and Filtering Data
- Relationships
- Queries
- Creating, Designing and Modifying Queries
- Summarizing Query Results
- Calculated Fields in Queries
- Sort and Filter Data in Queries
- Forms
- Types of Forms, Subforms
- Formatting Forms
- Reports
- Creation of Reports
- Header and Footer of Reports
- Multitable Reports and labels
- Conditional Formatting on Reports
Term 2
Web Productivity Tools
- Introducing Google Apps
- Types of Services Provided by Google Apps
- Working with Gmail
- Send and Receive Emails
- Add Attachments to E-mail
- Forward E-Mail
- Creating and Managing Contacts in Google Contacts
- Creating Tasks in Gmail
- Chat in Gmail
- Working with Google Calendar
- Add appointments and events.
- Using Google Drive to Store Files Online
- Google Documents
- Google Spreadsheets
- Google Presentations
- Google Forms
- Google Sites
- Creating a Google Site
- Adding and Editing pages in a site
Programming Practices and Techniques
- Introduction to Programming Tools
- Flowcharts & Pseudocodes
- Algorithms, Flowcharts, Pseudocodes
- Operators
- Selection Constructs: If, If-Else, Case construct
- Iterations Constructs: For, While
- Arrays
- File Handling
Programming in VBA
- Introduction to VBA
- VBA Programming Fundamentals
- Sub Procedures
- Function Procedures
- Events
- Working with External Data & Files
- Introducing User Forms
- Advanced User Form Techniques
- Custom Add-Ins
SQL Programming
- Introduction to DBMS
- SQL Databases
- Creating and Managing Tables
- SQL Data Types
- SQL Constraints: Primary Key, Foreign Key, Not NULL
- Inserting Records
- Fetching Records from Table
- Using where, group by, having conditions for custom queries
- Relationships in SQL
- Fetching Data from Multiple Tables
- Procedures in SQL
Financial Accounting with GST
- Introduction to Accounting
- Principles of Accounting
- Revenues and Capital Expenditures
- Recording of Transaction
- Preparation of Voucher
- Recording of Transactions in Tally ERP 9
- Input Tax Credit
- Claiming Input Tax Credit under GST
- Calculation of GST
- Introduction to IND-AS
- Rectification of Errors
- Locating the Errors
- Rectifying the Errors
- Depreciation
- Methods of Recording Depreciation
- Disposing Assets
- Bank Reconciliation Statement in Tally ERP 9
- Methods of Bank Reconciliation
- Inventory Record Keeping
- Valuation of Inventory
- Preparation of Final Accounts using Tally ERP 9.
- Final Accounts for Manufacturing Entities
- Final Accounts for Non-Manufacturing Entities
- Accounting Ratios
- Ratio and Ratio Analysis
- Accounting for Joint Ventures, Consignment and Inland Branches
- Interest Calculation
- Tax Collected at Resource
- Interest on Delayed Payment of GST
- Interest on undue or wrong payment of ITC
- Voucher Types: Reversing Journal, Point of Sales, Refund Voucher, Memorandum Voucher, Inventory Voucher
- Budget and Controls in Tally ERP 9
- Generation and Submission of GSTR
- E Way Bill
- Printing Invoices with Tally ERP 9
- Nil Rated and Zero-Rated Purchases
- TDS/TCS return in GST
- Returns under GST
