MS Office: Excel, Word & PowerPoint Complete Training at just ₹2996

Trained by working IT professionals from leading companies

31 HOUR MS Office: Excel, Word & PowerPoint SYLLABUS

Become fully productive with the complete Microsoft Office suite. This bundle combines four courses: Microsoft Excel Beginner, Microsoft Excel Advanced, Microsoft Word and Microsoft PowerPoint. You will learn to manage and analyse data with formulas, PivotTables, dashboards and macros, create polished professional documents, and design engaging presentations. These are essential skills for any academic, office, or business role.

Fee: ₹2996 Training Mode: Instructor-led live class Duration: 31 hours Next Batch: Loading...
Book the Course Talk to Us

What you will learn from this course?

  • Module 1: Microsoft Excel Beginner (7 hours)
  • Excel Interface & Basic Data Management
  • Introduction to Excel
    • What it is
    • Key uses in various professions
  • The Excel Interface
    • Ribbon
    • Tabs
    • Groups
    • Worksheets
    • Cells, Rows, Columns
    • Name Box
    • Formula Bar
  • Navigating Worksheets
    • Keyboard shortcuts
    • Using mouse
    • Go To function
  • Basic Data Entry
    • Text
    • Numbers
    • Dates
    • Times
    • Understanding data types
  • AutoFill Feature
    • Filling series (numbers, dates, custom lists)
    • Copying formulas
  • Selecting Cells, Ranges, Rows, Columns
    • Mouse methods
    • Keyboard shortcuts
  • Saving and Opening Workbooks
    • .xlsx
    • .csv
    • Other formats
    • Compatibility mode
  • Formatting & Organization
  • Cell Formatting
    • Font, size, color
    • Fill
    • Borders (styles, colors)
  • Number Formatting
    • General
    • Number
    • Currency
    • Accounting
    • Percentage
    • Date
    • Time
    • Custom formats
  • Alignment & Text Control
    • Horizontal/Vertical alignment
    • Wrap Text
    • Merge & Center
    • Shrink to Fit
  • Conditional Formatting
    • Highlight Cells Rules
    • Top/Bottom Rules
    • Data Bars
    • Color Scales
    • Icon Sets
  • Column Width & Row Height
    • Manual adjustment
    • AutoFit
  • Inserting/Deleting Rows, Columns, Cells
  • Working with Worksheets
    • Renaming
    • Moving
    • Copying
    • Hiding/Unhiding
  • Basic Formulas & Functions
  • Understanding Formulas
    • Structure
    • Arithmetic operations (+, -, *, /, ^)
    • Order of operations (PEMDAS/BODMAS)
  • Cell References
    • Relative
    • Absolute ($)
    • Mixed references
  • Basic Statistical Functions
    • SUM()
    • AVERAGE()
    • COUNT()
    • MAX()
    • MIN()
  • Data Management & Text/Date Functions
  • Sorting Data
    • Single-level (A-Z, Z-A)
    • Multi-level (adding levels, custom lists)
  • Filtering Data
    • AutoFilter
    • Text Filters
    • Number Filters
    • Date Filters
  • Find & Replace
    • Basic
    • Advanced (formatting, wildcards)
  • Freeze Panes
    • Top Row
    • First Column
    • Custom
  • Text Functions
    • CONCATENATE / &
    • LEFT(), RIGHT(), MID()
    • LEN(), TRIM()
    • UPPER(), LOWER(), PROPER()
  • Date & Time Functions
    • TODAY(), NOW()
    • DAY(), MONTH(), YEAR()
    • DATE(), TIME(), WEEKDAY()
    • Calculating differences between dates
  • Introduction to Data Validation
    • Restricting data entry
    • Creating drop-down lists
  • Module 2: Microsoft Excel Advanced (10 hours)
  • Advanced Formulas & Functions
    • IF(), Nested IF()
    • IFS()
    • VLOOKUP(), HLOOKUP()
    • XLOOKUP()
    • INDEX() & MATCH()
    • CHOOSE()
    • OFFSET()
    • INDIRECT()
    • TEXT(), VALUE()
    • Advanced logical functions (AND, OR, NOT)
    • ERROR handling functions (IFERROR, IFNA)
  • Pivot Tables & Pivot Charts
    • Creating Pivot Tables
    • Fields, Filters, Values, Rows, Columns
    • Grouping data
    • Calculated fields & items
    • Pivot Table formatting
    • Creating Pivot Charts
    • Using slicers & timelines
  • Data Analysis Tools
    • What-If Analysis (Scenario Manager, Data Tables, Goal Seek)
    • Solver
    • Descriptive Statistics (Data Analysis ToolPak)
    • Regression analysis
    • Forecasting
  • Data Cleaning & Preparation
    • Removing duplicates
    • Text-to-Columns
    • Flash Fill
    • TRIM, CLEAN, SUBSTITUTE
    • Find & Replace advanced use
    • Handling blank cells & errors
  • Data Validation & Protection
    • Restricting entries
    • Creating drop-down lists
    • Input messages & error alerts
    • Custom formulas for validation
    • Protecting worksheets
    • Password-protecting workbooks
  • Charts & Visualizations
    • Column, Bar, Line, Pie charts
    • Combo charts
    • Dynamic charts
    • Advanced chart formatting
    • Sparklines
    • Waterfall, Funnel, Histogram
  • Advanced Filtering & Sorting
    • Custom Sort
    • Advanced Filter
    • Unique values extraction
    • Extracting with criteria
  • Macros & Automation
    • Introduction to Macros
    • Recording Macros
    • Running Macros
    • Assigning Macros to buttons
    • Intro to VBA
  • Power Tools
    • Introduction to Power Query
    • Loading data from multiple sources
    • Transforming data
    • Introduction to Power Pivot
    • Creating Data Models
    • DAX basics
  • Collaboration & Security
    • Sharing workbooks
    • Tracking changes
    • Comments & Notes
    • Restricting permissions
  • Practical Case Studies
    • Business dashboards
    • Sales data analysis
    • Financial modeling
    • HR data management
  • Module 3: Microsoft Word (7 hours)
  • Getting Started with Word & Document Basics
    • Intro to Word & Interface
    • Creating, Opening, Saving Documents
    • Basic Text Entry, Selection & Editing
    • Hands-on: Write a simple letter
  • Basic Formatting & Styles
    • Character & Paragraph Formatting
    • Bulleted & Numbered Lists
    • Introduction to Styles
    • Clear All Formatting
    • Hands-on: Format a letter
  • Inserting Visuals & Page Layout
    • Inserting Pictures & Picture Formatting
    • Shapes & Tables
    • Page Setup, Headers & Footers
    • Hands-on: Insert visuals & set up page
  • Proofing & Finalizing Documents
    • Spelling & Grammar Check
    • Word Count
    • Track Changes (Basic)
    • Saving as PDF
    • Hands-on: Proofing & track changes
  • Module 4: Microsoft PowerPoint (7 hours)
  • Getting Started with PowerPoint & Presentation Basics
    • Intro to PowerPoint & Interface
    • Creating, Opening, Saving Presentations
    • Adding, Duplicating, Deleting, Rearranging Slides
    • Presentation Views
    • Hands-on: Create a basic outline
  • Adding & Formatting Content
    • Adding Text (Placeholders & Text Boxes)
    • Text Formatting
    • Inserting Pictures
    • Inserting Shapes
    • Inserting Tables and Charts
    • Hands-on: Populate slides with content
  • Slide Design & Themes
    • Applying Themes
    • Variant Options
    • Slide Master View (Basic Concept)
    • Background Formatting
    • Hands-on: Apply a theme & experiment
  • Transitions, Animations & Delivery
    • Slide Transitions
    • Basic Animation Effects
    • Slide Show View
    • Presenter View
    • Printing Handouts
    • Saving & Exporting Presentations
    • Hands-on: Add transitions/animations & practice presenting
TALK TO US FOR FREE