Module – 1
Microsoft Office Computer Applications
- Documentation with MS-Word
- Presentation with MS-Power Point
- Database Management with MS-Access
- MS-Outlook – An Introduction
Office Management & Office Procedures
- Office vs. Organization
- Need of Effective Office Management
- Skills, Roles & Responsibilities of an Office Administrator
- Need for Effective Filing
- Coordination, Planning & Organizing Meetings, Travels & In-House Events
- Connecting through Skype & Team Viewer
- Using Data Back-up Technology on Pen Drives, Hard Disks, CD/DVD, One Drive
- How to connect to Printer & Printing/Scanning Information
- Procuring Office Supplies
Effective Functional Communication Skills
- Importance of Effective Communication
- Verbal Communication – Smart Talk
- Communicate Effectively – Over Telephone
- Office & Business Correspondence
- Write Right
- Read Right
Module – 2
Microsoft Excel
- MS Excel – An Introduction
VBA – an Introduction
- What are VBA Macros
- Need of VBA Macros
- Benefit & Limitations of VBA Macro
- Display of Developers Tab & VB Editor
- Macro Recordings
- Introduction to the Writing of Basic VBA codes
- Working in the Visual Basic Editor
- Saving Off Your Macro
VBA Macro Programming
- Use of Decision Making Statements in Macro by using: If & Else Conditions, And /OR Conditions, Select-Case & Not Statements
- Working with Loops & Range Objects: Introduction of Programming Concepts to write Excel Formulas in Programs
Types of Errors & How to Debug Errors VBA Macro Programming: Form Vs. Active X Controls & Advanced User Forms
- Data Analysis
- Charts from Multiple Data Sheets
- Dashboard Reporting
- MIS Reporting
