Advanced MIS Training

Course Duration : 05 Months, Course Fee : 25000/-

advanced misAdvanced MIS Training designed for working professionals having basic knowledge on MS-Excel along with knowledge on Database Management System. The Advanced MIS Training by ACLM Institute of Professional Studies can change your approach on data operation and will also gain confidence about visualizing any complex data sets. You can also set your career goal as a data analyst. Contact Us @ +91-9718812233 or drop a mail to info@aclm.in to book your free demo session. Dream your career to a right track as Data Analyst with ACLM Institute of Professional Studies.

What is Advanced MIS Training

advanced mis trainingWhenever you think about data representation, reporting, customization and automation with the help of market boosting database technologies advanced MIS will always works. This training will be based on core practical concepts with the help of different case studies on the phenomenal changes of data over the period. The course has been designed for Working professionals as well as Freshers or Data Manager, who think about data analyst as a key role player in their life.

Tools used in the training

  • Microsoft Excel (2007 / 2010 / 2013)
  • Microsoft Access (2007 / 2010 / 2013)
  • SQL Query Injection (Any database)
  • VBA (EXCEL + ACCESS)
  • Dynamic Dashboard Preparation
  • Presenting with Power Point

 

Topics Covered

MS EXCEL PART

  • Focus on real scenarios of Reporting / Data Management / Automation, Difference between basic and advance Excel, Excel Basics, Excel Settings, Advanced Formulas, Name Manager, Absolute and Relative fields, Goal Seek / Scenario, Managing Lists, Cross Reference (Absolute & Relative)
ADVANCE EXCEL PART
  • Conditional formatting, User Settings for Excel Application Level, Data Management and Analysis, Reporting Techniques, Pivot Table, Macros, Concepts of VBA, Excel Data Handling with VBA, Use of SQL Queries, Userform, Listbox, Combobox, Buttons etc., Application Design
DATA FILTERING / DATA FORMATTING
  • Understanding Different Data Types, Using String / Text / Number / Long Data Types with examples, Managing Date Time Format, Handling Long Date time Format, Data Correction, Identifying bad data, Conversion of different data types, Importing and accessing different file types in excel
ADVANCE EXCEL SECURITY
  • Protecting Excel File, Protecting worksheet, Workbook, Enable / Disable Range, Allow users to edit range, Protecting users to edit range, Field Controls using customised user access
FORM BASED
  • Database, Tables, Fields and Properties, Form Properties, Variables, Functions, Modules, Subroutines, Conditional Validations, Using Other ActiveX Tools like, Calendar, Watch, PDF..., Looping Constructs (While, Do While, For, Foreach, If Else, If then else...) Functional Parameters
DATA ACCESS PARTS
  • SQL Queries, Reports and Data Management, VBA Programming and Data Management Forms, Reports & Application Design
VARIOUS MIS TECHNIQUE WITH THE HELP OF EXCEL VBA PROGRAMMING
  • Get an overview of different Analytical Process, Differentiating Modules, Sub-Modules, Procedures, Data handling with the help of Access, ACCESS Forms and Reports, Writing Access Queries, Reporting and Formatting by different angles, Macro generation and application, design, Writing custom queries as per the need, Fundamentals of data handling, MIS, EXCEL and Access, Using of Developer Tools to Excel Worksheet, Using of ActiveX tools to Excel, Worksheet, Using of Developer tools to VBA Programming, Enabling / Disabling ActiveX Tools to VBA
USING CHARTS  / GRAPHS / PIVOT CHARTS / PIVOT TABLE
  • Setting Data Source, Getting Charts / Graphs using Referential fields, Getting ACCESS Data Getting Other Data
DATA SOURCE
  • Setting Data Source, Getting XML Data, Getting ACCESS Data, Getting Other Data
RETRIEVING DATA FROM SINGLE TABLE
  • Integration of Database, Connecting to a DBMS Using the SQL Procedure
DATA Connectivity
  • Connecting to a excel Using the SQL Procedure, Connecting to a access Using the SQL Procedure, Connecting to a DBMS Using the DSN
ACCESS
  • Creating Tables / Queries / Forms, Insert / Update Statement, User Form / Field Updation,  Multiple SQL Statements, The SQL Procedure, The Access Procedure, Requirements to Connect to a Database
ODBC
  • Understanding how to use the ODBC with Excel, Set up a data source for a database driver, Defining the ODBC API, ODBC Terminology, Defining the Data Source Manager, ODBC Driver, Data Source

MS ACCESS PART

Access User Interface
  • Access Ribbon,File, Save a Database as Templates, Home, Create, External Data, Database Tools, Contextual Tabs, Quick Access Toolbar, Object Navigation Pane, Access Work Surface, Access Option Dialog Box, Object Overview, Tables  Queries,  Forms,  Reports, Macros & Modules, Process Overview, Exercise: Getting Around the Access Environment, Create Database using a wizard
Fundamentals
  • Approach to Database Design, Top down Database Design, Bottom up Database design, Reality, Gather Information, Data Mapping, Sample Data Map, Normalization, First Normal Form, Second Normal Form, Third Normal Form, Table Relationship
Table & their View
  • Datasheet View, Selection Tools, Table Layout Tools, Sorting & Filtering Tools, Print Records, Record Navigation, Working in Datasheet View, Working with Table in Datasheet View, Design View, Open a table in Design View, Design View layout
Tables
  • Creating an Access Database, Creating a New Database, Data Types, Determine Data Type, Create a Table in Design View, Delete a Fields, Rename a Table, Linking Table from External Source, Import table from other database, Tables and Templates and Application Parts
Queries
  • Definition & Purpose, Types, Views, Select Queries with criteria, Logical Operators, Group & Total with Queries, Total Row with group By, Action Queries, Make Table Queries    Append , Queries,     Update Queries, Delete Queries Creating Crosstab Queries, Delete Queries, Rename Queries
Form
  • Definition & Purpose, Layout Design & Views, Adding a Header & Footer, Adding Logo to the Header, Adding a Title to the header, Arranging Filed on a form, Spacing Objects o a form, Alter a Form, Remove form Control, Format Forms, Adding Data Record in Form View, Form Record Navigation, One Click Forms, Basic Data Entry Form, Datasheet Form, Split Form, Create a Form with Form Wizard
Reports
  • Definition & Purpose, Views, Report Header, Page Header, Group Header, Details Group Footer,   Page Footer, Report Footer, Adding a Report Header/Footer, Adding a logo to the Header, Adding a Title to the Header, Adding fields to Reports, Add Calculated Fields, Arranging Fields on a Report, Resizing the Details Sections, Grouping 7 Sorting, Setting Properties on a Report, Report Property Setting, Section Property Sheet, Object Property Sheet, Adding Records Counts, Special Report Fields, Dates, Page Numbering, Controls, Application Parts, Deleting a Report, Formatting a Reports, One Click Report, Formalize the Relationship between Tables
Relationship
  • Data Type and Relationship, Views, One Click Report, Formalize the Relationship between Tables
Macro
  • Open a Table, Form and Record, Run a Query, Print a Report, Running a Macro, Creating Simple Macros
Completing the Desktop Application
  • The Navigation Form, Running Macros from a Navigation Form, Setting the Navigation Form as a Default Form, Creating a navigation Form, Splitting the database, Encrypt with password, Distributing the Front-End Database, Database Maintenance, Compact & Repair, Backup recovery a database, Maintain Backup Compatibility

Visual Basic for Applications (VBA)

  • MS Office is supported by Visual Basic for Applications (VBA), an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components.
  • Learn using vba for all microsoft applications like word, excel, power point and outlook.

DASHBOARD AREA

  • Dynamic Dashboard preparation, Using Developer Controls over Charts, Graphs and Tables, Using Dynamic Data Table, Power Pivot, SQL Plugins, Creating, Installing and Using Different Plug-Ins, Creating your own Tools

CASE STUDY & ASSIGNMENTS

  • Work on various real time scenario to make you perfect with all above learning;
  • Collection of 10 different case studies to make you perfect;
  • A set of more than 50 assignments will grasp your intensity towards data analysis.

Who Should Attend

  • Freshers, who wish to make career in data analysis;
  • Data architects, who want to develop dynamic applications and
  • "Power Users" can use it to build software applications, like other Office applications.

Pre-requisites

  • Basic knowledge of Excel as well as;
  • Basic Knowledge of Database;

What You Need To Bring

  • Notepads, Laptop, Pen / Pencil

Key Takeaways

  • Microsoft office specialist Certification
  • In-depth knowledge of handling multiple database
  • Able to design and automate fully functional dashboard
  • Able to Analyse complex data sets
  • Customize the report as per the requirement

About Trainer

  • Over 17+ years of experience in Data Analysis, reporting and customization
  • Microsoft VBA Expert Certified
  • Microsoft Office Specialist Certified
  • International Training exposure of more than 100 corporate trainings
  • Member of IFCA, AIMA
  • Contributed to several studies on financial and man-power management
  • Certifications of PMP, Six-Sigma, MS Project specialist

have a question?

PAY FEE ONLINE BY :

Schedule

25
Feb
Group Training on MIS
register
4
Mar
Data Analytics Training
register
1
Mar
Project Management Training
register
1
Mar
SAP-FICO
register
1
Mar
Salesforce Classes
register
4
Mar
VBA Workshop
register