Requirements

• No previous knowledge required
• Excel, Word, PowerPoint, Teams and Outlook are installed on your machine. Preferably Office 365
• You will learn faster and be more confident when you try it yourself!

Course Content

Course Introduction (FREE SESSION)

• What is Computer? Difference Between Hardware and Software?
• Window's Overview
• Typing Speed Improvement Process
• Microsoft 2019 vs 365 difference
• MS Office Introduction
• Market Opportunities

Office Setup

• Install Office365 for Windows
  

Microsoft Word Essentials

• Document creation and formatting
• Styles and templates
• Collaboration tools and version control
• Mail merge for mass communications
• Advanced formatting features

Microsoft PowerPoint Mastery

• Creating effective presentations
• Custom themes and templates
• Advanced slide transitions and animations
• Designing interactive presentations
• Mastering the use of multimedia

Microsoft Excel Fundamentals

• Spreadsheet basics and navigation
• Cell formatting and data entry tips
• Formulas and functions (basic to advanced)
• Data validation and error checking
• Sorting and filtering techniques

Visual Basic for Applications (VBA)

• Introduction to VBA programming
• Writing and executing basic macros
• Automating repetitive tasks
• Creating user-defined functions
• Intermediate VBA concepts

Advanced Data Analysis in Excel

• Data cleaning and preparation
• PivotTables and PivotCharts
• Advanced charting techniques
• Dashboard creation for data visualization
• Using Power Query for data transformation

Outlook for Efficient Communication and Organization

• Email organization and management
• Automating email tasks and rules
• Scheduling and managing appointments
• Flags, reminders, and follow-up automation
• Integrating Outlook with other Microsoft Office applications

Assessment

Participants will be evaluated through a combination of practical assignments, quizzes, and a final project that involves applying the learned skills in a simulated office scenario.

Project 1: Write a Book/Research Paper/Design Forms or Templates

Project 2: Make dashboards for Analysis

Project 3: Make an Animated Infographic Presentation and Convert it into a Video

By the end of this course, participants will have gained the necessary skills to streamline office processes, enhance productivity, and effectively manage day-to-day tasks using a variety of tools and techniques.