Online Course
Online MIS Course

Online MIS Course

Online MIS Course by ACLM Institute is being provided with full duplex high end technology. Since the inception, ACLM meets the requirements of state of art and functionality. Our Online MIS Course, makes you feel like an instructor led training.

For the online mis course, aclm invites Senior and Middle Level Manager, Team Leaders, Director ans senior staffs to understand the entire technology and make it useful in their organization. Our training has settled lot of examples on MIS and Project Management.

ACLM also invites those candidate(s) who wish to make career as MIS and data management. The training provide In-depth Knowledge in MS-Excel, VBA with the combination of MS-ACCESS & SQL along with various techniques to prepare MIS Dashboard including Graphs, Charts and Power BI Tools.

Prerequisites

Windows 7 or later version, Ram:  2GB, Internet Speed : 512 Kbps, Browser Compatibility: Google Crome, Hangout installed/activated or Zoom Live Hardware Device: Speaker, Mouse, Headphone properly working.

Online MIS Course Modules:

advanced mis training
  • Complete Tabs in Excel
  • 100+ Excel Short cut 
  • 50+ Tricks for Data Handling
  • Advanced Dashboard Formatting
  • Protection Methodologies
  • Data Handling, Data Analysis
  • Formulation of own Formulas 
  • Array Formulas Tricks
  • Connectivity, Dynamic Chart
  • MACRO, VBA, & SQL
  • Automated Email Linkers
  • Assignments, Test, Notes & E-Books

Advanced Online MIS Course along with VBA

  • Advanced MIS Training Topics
  • Basic Concept of VBA Macros Programming
  • Use Data Type in Macros, Create a New VBA Formulas with Function
  • Make a User-Interface with User Form
  • Setting Data Source, Getting XML Data, Getting ACCESS Data, Getting Other Data
  • Connect the Excel with SQL Procedure, Access, Using the SQL Procedure, Connecting to a DBMS Using the DSN
  • ODBC
  • Assignments
  • E-Books

Assessments & Certifications

On completion of the training you’ll also be eligible for MOS (Microsoft Office Specialist Exams Level 1, Level 2, Level 3 & Level 4) comprising of Beginner to Expert Level.

vba training

Welcome to ACLM. Registration open for Advanced Excel, VBA, SQL & MIS + FREE Tableau. Register now.

X