HDI

₹3,500 ₹4,500

Course Includes

Duration60 Days
Enrolled0
Lectures40
Videos0
Notes0
CertificateYes

What you'll learn

Microsoft Office (now primarily rebranded as Microsoft 365) is a comprehensive suite of productivity applications used for creating documents, analyzing data, and managing communications.

Core Applications

Word: Word processor for text documents.
Excel: Spreadsheet tool for data analysis and calculations.
PowerPoint: Presentation tool for multimedia slideshows.
Outlook: Email, calendar, and contact management.
OneNote: Digital note-taking and organization.

Additional & Cloud Tools

Access & Publisher: Tools for database management and desktop publishing.
Teams & OneDrive: Collaboration, communication, and cloud storage solutions

Course Syllabus

A standard MS Office course syllabus is designed to take you from basic computer literacy to advanced professional productivity across its core applications.

1. Microsoft Word (Document Mastery)

Basics: Interface navigation, creating/saving documents, and basic text formatting (fonts, alignment, bullets).
Intermediate: Inserting tables, graphics, and SmartArt; using headers, footers, and page numbering.
Advanced: Mail Merge, Table of Contents, Citations/Bibliography, and tracking changes for collaboration.

2. Microsoft Excel (Data Analysis)

Basics: Understanding rows, columns, and cells; basic math operators (+, -, *, /).
Intermediate: Data sorting/filtering, conditional formatting, and essential functions like SUM, AVERAGE, MIN, MAX.
Advanced: Pivot Tables, VLOOKUP/HLOOKUP, Macros, and complex financial formulas

3. Microsoft PowerPoint (Presentations)

Basics: Creating slides, layouts, and themes.
Intermediate: Using Transitions and Animations; inserting audio/video.
Advanced: Slide Master for uniform design and creating interactive, self-running presentations

4. Microsoft Outlook (Communication)

Email Management: Composing, phishing awareness, and organizing with folders.
Scheduling: Managing Calendars, Tasks, and meetings.

5. Specialized Modules

MS Access: Introduction to database tables, queries, and forms.
Cloud Tools: File sharing via OneDrive and team collaboration in Microsoft Teams