Certificate in Microsoft Office

The Certificate in MS Office is a comprehensive program designed to provide participants with the skills and knowledge necessary to effectively use Microsoft Office applications, including Word, Excel, PowerPoint, and Outlook.

Request a Callback

Program Highlights

  • Course Module : Certificate Programs
  • Duration :
  • Format :Hybrid (Online/ In- person)
  • Center : All centers

Introduction

Any business with offices use Microsoft Office. The knowledge gained through Microsoft Office may be applied to almost any piece of software you'll need to master for your career, and it is regarded as fundamental computer literacy.

Microsoft Office is a suite of desktop productivity applications that is designed specifically to be used for office or business use. It is a collection of office-related applications. Each application serves a unique purpose and offers a specific service to its users.

The course introduces IT fundamentals and four different Microsoft Office applications, with a primary focus on using Excel to analyze and explore real world data. After completing the course, students will be competent users of the Microsoft Office suite and will have data analysis skills that will be useful in future classes and careers.

Program Summary

  • Create spreadsheets to perform calculations, display data, analyze it, and investigate what-if scenarios.
  • Create technical and Business oriented presentations that share data through charts and visual aids with power point and excel.
  • Develop varieties and proposals and reports with Ms word
  • Organize your email to focus on the messages that are most important.
  • Schedule meetings and appointments using your calendar.

Career Opportunities

  • Junior data analyst
  • Office assistant
  • Administrative assistants
  • Office clerks
  • Information staff

Course Content

Module 1

IT fundamentals

  • Introduction to computers , hardware and software ,peripherals, operating systems, computer viruses, system maintainance , Basic Networking and Security

Microsoft Office - Word, Powerpoint , Excel and Outlook

  • Word Fundamentals
    • Inserting and Editing Text -Format Text and Paragraphs - Formatting Page- Working with Tables - Graphics In word - Applying Styles, Themes, and Templates - Documentation - Teaming in Word - Working with long Documents - Mailing Documents
  • PowerPoint Fundamentals
    • Work with Presentations -Organize a Presentation -Deliver a Slideshow- Formatting and Themes - Graphics In PowerPoint - Applying Styles, Themes, and Templates - Transitions and Animations - Working with Slide Masters- Implementing Self-Run Presentations
  • Excel Fundamentals
    • Edit a Workbook - Basic Formulas- Basic Formatting - Insert Objects - Manage Worksheets - Charts - Intermediate Functions - Tables - Manage Data - PivotTables - Analyze Data
  • Outlook Fundamentals
    • Mailing - People and Contact - Working with Calendar - Tasks and Notes - Advanced Mailing - Advanced Calendar -Manage Information
Module 2

Advanced Excel

  • Introduction to Information Analysis - Organizing Data - Data Manipulation and Visualization Summarizing Data ,pivot table, Power pivot. Look up functions, Date functions
  • Data formatting - conditional formatting , what if analysis, solver , data validation . - decision making functions.
  • Loading Data from Various Sources using power query - Analyzing Complex Data - Advanced - Dashboard and Automation with Macros VBA Programming

Eligibility Requirements

  • Candidate having basic knowledge to operate a computer.