MIS Training – Advance Excel + Macro + Access + SQL

MIS Reporting and Analysis Training - Complete Data Management with Basic to Expert level Excel and Automation Macro

Created by: Himanshu Dhar
MIS Trainer

What Will I Learn?

• Advance Level Excel
• Expertise in Using Text Function
• Expertise in Using Logical Function
• Expertise in Using Math Function
• Expertise in Using Lookup & Reference Function
• Expertise in Using Date and Time Function
• Expertise in Using Pivot Table and Chart
• Expertise in Power Pivot and Power Map
• Expertise in Using What If Analysis Tools
• Many Others Excel Tools
• MS Access Knowledge on Table, Form, Queries and Reports
• SQL Queries
• Macro Recording
• Excel VBA Object Handling with practical Project
• Excel VBA Variable with practical Project
• Excel VBA IF & Case with practical Project
• 3 Types of Loop with practical Project
• Create your own Function
• Events in VBA
• FSO in Excel VBA
• Userform in Excel VBA
• Automate Pivot and Outlook in Macro
• Many More Macro Topics and Projects

Requirements

• Basic Computer Knowledge is must

Target audience

• MIS Aspirants
• Management Graduates
• Want Data Management Expertise
• Want a career in MIS, Data Analytics & Data Management