MICROSOFT OFFICE

This course is designed to provide students with a comprehensive understanding of key MS Office applications, focusing on Excel, Word, and PowerPoint. The first half of the course will delve into Excel, starting with an introduction to its uses and basic functionalities. Students will learn essential formulas and functions, progressing from simple calculations to advanced features like VLOOKUP, and advanced logic functions such as IF, SUMIF, SUMIFS, INDEX, and MATCH. These concepts will empower students to work efficiently with data and perform complex calculations. Additionally, students will master the use of PivotTables for data analysis, and the Goal Seek tool to help achieve targets and find optimal solutions within spreadsheets.

The second half of the course will shift focus to Word and PowerPoint. In the Word module, students will explore the fundamentals of word processing and learn how to create professional documents. Special attention will be given to building an effective resume using Microsoft Word, guiding students through formatting and content organization techniques. The course will conclude with an introduction to PowerPoint, covering the essentials of creating engaging presentations. By the end of the course, students will have a solid command of MS Office, allowing them to enhance their productivity and effectiveness in both academic and professional settings.

Format: On-campus
Day: Every Sunday
Time: 3:00 PM – 5:00 PM
Course Price: Rs. 2,000
Starting from: 05th October 2025

HERE IS THE DETAILED COURSE OUTLINE

October 5th, 2025

Session 01: Introduction to MS Office Suite

Overview of MS Office Suite. Introduction to Word, Excel, PowerPoint. File Management: Opening, Saving and Closing Documents. Understanding MS Office Interface (Ribbon, Quick Access toolbar, etc.). Navigating MS Office Programs
October 12th, 2025

Session 02: Microsoft Word - Basics

Creating, Saving, and Testing Documents Formatting Text: Fonts, Size, Bold, Italics, Underlines, etc. Using Paragraph Styles, Alignment, Indentation, and Line Spacing Inserting Bullets and Numbering Working with Text Links and Multimedia/Bulleted Points
October 19th, 2025

Session 03: Microsoft Word - Essential Skills

Using Tables for Organizing Content Entering Titles, Subheadings, and Remarks Page Layout: Margins, Orientation, and Size Working with Headers and Footers Making Page Numbers Check - Basics
October 26th, 2025

Session 04: Microsoft Excel - Basics

Introduction to Spreadsheets. Creating and Saving Excel Workbooks. Navigating Cells, Rows, and Columns. Basic Formulas: SUM, AVERAGE, COUNT. Formatting Cells (Text, Numbers, Date/Time).
November 2th, 2025

Session 05: Microsoft Excel - Advanced Features

Sorting and Filtering Data. Using Functions: IF, VLOOKUP, HLOOKUP. Introduction to Charts and Graphs. Working with Multiple Worksheets. Conditional Formatting.
November 9th, 2025

Session 06: Microsoft PowerPoint - Basics

Creating and Saving Presentations. Inserting Text, Images, and Shapes. Using Layouts and Themes. Basic Animation and Transitions. Presenting with PowerPoint.
November 16th, 2025

Session 07: Microsoft PowerPoint - Advanced Features

Inserting Multimedia (Audio/Video). Working with Master Slides. Custom Animations and Transitions. Creating Interactive Presentations. Adding Hyperlinks and Action Buttons.
November 23th, 2025

Session 08: Microsoft Outlook - Basics

Setting up Email Accounts in Outlook. Composing, Sending, and Receiving Emails. Organizing Emails into Folders. Managing Contacts and Calendars. Introduction to Tasks and Notes.
November 30th, 2025

Session 09: Microsoft Word - Advanced Skills

Mail Merge: Creating Personalized Documents. Using Styles and Themes for Consistency. Collaborating: Tracking Changes and Comments. Protecting Documents with Passwords. Advanced Formatting: Tables, Columns, and Section Breaks.
December 7th, 2025

Session 10: Microsoft Excel - Data Analysis and Reporting

Using PivotTables and Pivot Charts. Advanced Functions: INDEX, MATCH, COUNTIF. Data Validation and Protection. Creating Dynamic Dashboards. Sharing and Protecting Excel Workbooks.
December 14th, 2025

Session 11: Microsoft PowerPoint - Mastering Presentations

Designing Professional Presentations. Creating Infographics and Visuals. Using Data from Excel in PowerPoint. Final Project: Creating a Full Presentation with Content and Animations.
December 21th, 2025

Session 12: Integration & Final Exam/Project

Recap and Integration of Skills from All Applications. Final Project: Combining Word, Excel, and PowerPoint Skills. Practical Exam or Assignment Submission. Review and Feedback.