Microsoft Courses

Master essential Microsoft tools with DUS Microsoft Training. Learn Excel, Word, PowerPoint, and Outlook from beginner to advanced levels to boost productivity, streamline office tasks, and elevate your career in any field. Enroll now with DUS Skills!

IT Skill

Rs. 24,000

Microsoft Word

The Microsoft Word course teaches how to create, format, and edit professional documents for personal, academic, or business use.

Microsoft Excel

The Microsoft Excel course teaches how to organize data, use formulas, and create charts to analyze and manage information efficiently.

Microsoft Power Piont

The Microsoft PowerPoint course teaches how to design and deliver engaging presentations using slides, animations, and visual elements.

Typing Master

This course is designed to help you develop fast, accurate, and professional typing skills that can boost your productivity in any field. It focuses on practical training, allowing you to strengthen finger placement.

DUS AI – Details & Registration

Microsoft Courses

Module 1:Introduction to Microsoft Office
  • Microsoft Office kya hai?
  • Word, Excel, PowerPoint — overview & uses
  • Ribbon interface, backstage view
  • File formats (DOCX, XLSX, PPTX, PDF)
  • Saving, printing, sharing basics

2.1 Basics of MS Word

  • Interface introduction
  • Creating, opening & saving documents
  • Typing, selecting, deleting text
  • Copy, paste, cut, undo, redo
  • Fonts, colors, sizes
  • Paragraph alignment, line spacing

2.2 Page Setup & Formatting

  • Page size, margins
  • Header & footer
  • Page numbers
  • Columns & breaks
  • Borders & shading
  • Styles introduction

2.3 Working with Objects

  • Insert:
  • Pictures
  • Shapes
  • Icons
  • SmartArt
  • Charts
  • Tables
    • Wrap text options
    • Watermarks
    • Background colors

2.4 Tables & Data Handling

  • Insert + format tables
  • Table design tools
  • Table alignment & borders
  • Sorting data
  • Split & merge cells

2.5 Advanced Word Tools

  • Find & Replace
  • Spelling & Grammar
  • Track Changes & Comments
  • Table of Contents (Automatic)
  • References & citations
  • Mail Merge (letters, labels)
  • Protect document (password)

2.6 Final Projects

  • Resume / CV design
  • Company letterhead
  • Assignment formatting
  • Report design
  • Certificate design

3.1 Basics of Excel

  • Excel interface overview
  • Workbook vs Worksheet
  • Row, column, cell concepts
  • Data entry, selection, autofill
  • Formatting cells (borders, colors, alignment)
  • Freeze panes

3.2 Formulas & Functions

Basic Formulas

  • SUM
  • AVERAGE
  • MIN / MAX
  • COUNT / COUNTA
  • Percentage formulas
  • Basic arithmetic

Intermediate Functions

  • IF
  • SUMIF / COUNTIF
  • CONCAT
  • PROPER, LOWER, UPPER
  • DATE functions

Advanced Functions

  • VLOOKUP
  • HLOOKUP
  • XLOOKUP (latest)
  • INDEX + MATCH
  • IFERROR

3.3 Data Management

  • Sorting & filtering
  • Remove duplicates
  • Data validation (drop-down list)
  • Conditional Formatting
  • Flash Fill

3.4 Charts & Data Visualization

  • Column chart
  • Bar chart
  • Pie chart
  • Line chart
  • Combo chart
  • Custom chart formatting

3.5 Pivot Tables

  • Pivot table creation
  • Rows, columns, values
  • Pivot chart
  • Slicers

3.6 Excel Tools for Business

  • Budget sheet
  • Attendance sheet
  • Salary sheet
  • Cashbook
  • Invoices
  • Dashboard basics

3.7 Excel Security

  • Protect sheet
  • Lock cells
  • Workbook protection

4.1 Basics of PowerPoint

  • Interface introduction
  • Themes & templates
  • Slide layouts
  • Creating new slides
  • Typography rules

4.2 Designing Slides

  • Insert text, images, shapes
  • Alignment & grouping
  • Icons & SmartArt
  • Using animations & transitions
  • Slide master (brand-level design)

4.3 Multimedia in Presentations

  • Insert videos
  • Insert audio
  • Hyperlinks & action buttons

4.4 Professional Presentation Skills

  • Corporate presentation structure
  • Infographics
  • Data charts
  • Designing pitch decks
  • Export to PDF / video

4.5 Final Projects

  • Company profile presentation
  • Marketing pitch deck
  • Educational presentation
  • Portfolio presentation

FAQ's

1. What is Microsoft Office?
Microsoft Office is a suite of productivity software developed by Microsoft. It includes popular programs like Word, Excel, PowerPoint, Outlook, and more.
You don't need an internet connection to use the desktop versions, but internet is required for downloading updates, using cloud features (OneDrive), or using Office Online.
Microsoft 365 is a subscription-based version of Microsoft Office that includes cloud storage (OneDrive), regular updates, and access to Office apps across devices.
Yes, Microsoft Office apps are available for Android and iOS. You can use Word, Excel, and PowerPoint with basic features for free, or sign in with a Microsoft account for more functionality.
Microsoft Office is not free, but you can use Office Online for free with limited features, or subscribe to Microsoft 365 for full access.