Advanced MIS Training designed for working professionals having basic knowledge on MS-Excel along with knowledge on Database Management System.
The course majorly covers Advanced Excel, VBA, Python, Pandas, XLRD, SQL with Tableau
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
Advanced MIS Training - Whenever you think about data representation, reporting, customization and automation on large complex data, you'll always get confuse with multiple tools available in the market.
At ACLM, you'll learn to handle the complex data set with the help of Excel, VBA, Python, SQL & most demanding Tableau Business Intelligence Tool.
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.
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)
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
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
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
Advanced MIS Training 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
SQL Queries, Reports and Data Management, VBA Programming and Data Management Forms, Reports & Application Design
Advanced MIS Training 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
Setting Data Source, Getting Charts / Graphs using Referential fields, Getting ACCESS Data Getting Other Data
Setting Data Source, Getting XML Data, Getting ACCESS Data, Getting Other Data
Integration of Database, Connecting to a DBMS Using the SQL Procedure
Connecting to a excel Using the SQL Procedure, Connecting to a access Using the SQL Procedure, Connecting to a DBMS Using the DSN
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
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
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
Advanced MIS Training 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
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
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
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
Advanced mis training 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
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
Data Type and Relationship, Views, One Click Report, Formalize the Relationship between Tables
Open a Table, Form and Record, Run a Query, Print a Report, Running a Macro, Creating Simple Macros
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
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, Creating Story and Dashboard using Tableau
Notepads, Laptop, Pen / Pencil
