Welcome to New Computer Upskill Academy
WELCOME TO NEW COMPUTER UPSKILL ACADEMY
CERTIFICATE IN DATA ENTRY AND MIS ( DEM )

BASIC INFORMATION

  • Course Fees : 7200.00 12000.00/-
  • Course Duration : 6 MONTHS
  • Minimum Amount To Pay : Rs.1000.00

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

Personality Plus

  • Personality Enhancement & Personal Effectiveness for Good Impression

This program is suitable for candidates who are looking for a professional program which can prepare them for employment opportunities in IT - ITES sector and all other sector where IT services or MIS work is needed. The program structure is designed in such a way that it gives in depth know how and skills to work on MS office. 6 months of duration for Basic Analytics & MIS skills through Advance Excel.