Description

 

🟦 MS Word – Main Topics

Introduction to MS Word Interface

Creating, Saving & Opening Documents

Typing, Editing, Copy, Cut, Paste, Undo, Redo

Font Formatting (Bold, Italic, Underline, Color, Size, etc.)

Paragraph Formatting (Alignment, Line Spacing, Indentation)

Bullets and Numbering

Page Setup (Margins, Orientation, Paper Size)

Headers, Footers, and Page Numbering

Insert Tab:

Pictures, Shapes, Icons, WordArt, Tables, Charts, Symbols

Table Creation and Formatting

Convert Text to Table & Table to Text

Mail Merge (Letters, Labels, Envelopes)

Proofing Tools (Spelling, Grammar, Thesaurus)

Find and Replace

Watermark, Page Border, and Background

Shortcuts & Customization

Printing and PDF Export

🟧 MS PowerPoint – Main Topics

Introduction to PowerPoint Interface

Creating & Managing Slides

Slide Layouts and Design Themes

Adding Text, Images, Shapes, and Icons

SmartArt and Charts

Slide Master and Templates

Transitions and Animations

Adding Audio and Video

Hyperlinks and Action Buttons

Custom Slide Shows

Slide Timing and Rehearsal

Printing Handouts

Presenting Slide Show (F5, Presenter View)

Design Tips for Professional Presentations

🟩 MS Excel – Main Topics

Excel Interface and Navigation

Workbook, Worksheet, Row, Column, Cell

Data Entry and Editing

Formatting Cells (Number, Font, Borders, Color)

Formulas and Functions (SUM, AVERAGE, COUNT, MIN, MAX)

Cell Referencing (Relative, Absolute, Mixed)

Sorting and Filtering Data

Conditional Formatting

Charts and Graphs

Page Layout and Printing Options

Data Validation

Protecting Worksheets and Workbooks

Excel Shortcuts

🟨 Advanced Excel – Main Topics

Logical Functions: IF, AND, OR, IFERROR

Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP

Text Functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXTJOIN

Date & Time Functions: TODAY, NOW, DATEDIF, NETWORKDAYS

Statistical Functions: COUNTIF, SUMIF, AVERAGEIF, SUMIFS

Data Analysis Tools:

Pivot Table & Pivot Chart

Data Consolidation

What-If Analysis (Goal Seek, Scenario Manager)

Data Cleaning Techniques (TRIM, CLEAN, SUBSTITUTE)

Dashboard Creation Basics

Named Ranges and Dynamic Ranges

Conditional Formatting (Advanced Rules)

Power Query Introduction

Macro Recording and Basic VBA Introduction