1.     Fundamental of Computers

·        Introduction to Computer

·        Types of Computer

·        Characteristics of Computer

·        Hardware & Software

·        Input Devices

·        Output Device

·        CPU

·        RAM & ROM

·        Storage Devices (HDD, SSD, Pen Drive)

·        Operating System

·        Windows Desktop

·        Start Menu, Taskbar & Icons

·        Files & Folders

·        Create, Copy, Move, Rename & Delete

·        Computer Ports

·        Booting Process

·        Shortcut Keys

·        Internet Basics

·        Browser

·        Search Engine

·        Email Introduction

2.     Paint

·        Paint Interface

·        New, Open & Save

·        Pencil, Brush, Erase, Fill Color, Shapes, Text Tool, Selection Tool

·        Resize, Rotate, Crop, Image Editing

3.     Notepad

·        Introduction

·        Create & Save File

·        Typing Practice

·        Cut, Copy, Paste

·        Undo & Redo

·        Find & Replace

·        Word Wrap

4.     WordPad

·        Interface

·        Create & Save Document

·        Font Formatting

·        Bold, Italic & Underline

·        Font Color

·        Paragraph Formatting, Alignment, Line Spacing

·        Insert Picture

·        Date & Time

·        Bullets

·        Page Setup, Print Preview, Print

5.     MS Word

·        MS Word Basics

·        Creating, saving, editing documents

·        Text formatting, paragraph alignment, bullets and numbering

·        MS Word Intermediate Features

·        Tables, headers/footers, page background

·        Page layout, margins, and styles

·        MS Word Advanced Tools

·        Mail merge, references, table of contents

·        Templates, collaboration, printing options

6.     MS Excel

·        Introduction to MS Excel

·        Spreadsheet basics, cell referencing, formulas

·        Data entry, formatting cells

·        Working with Formulas and Functions

·        SUM, AVERAGE, IF, COUNTIF, VLOOKUP, etc.

·        Absolute vs. relative referencing

·        Data Visualization & Charts

·        Creating and formatting charts

·        Sorting, filtering, and conditional formatting

·        Excel Advanced Tools

·        PivotTables, Data Validation, What-if analysis

·        Protection, exporting to PDF

7.     MS PowerPoint

·        Introduction to power point

·        PowerPoint Basics Creating slides, themes, and

·        Layouts Adding and formatting text and images.

·        Design and Multimedia

·        Animations, transitions, audio/video

·        Slide Master and templates.

·        Presenting and Sharing

·        Presenter view, printing handouts

·        Exporting presentations, sharing tips

8.     MS Outlook & Integration

·        Introduction to MS Outlook

·        Email setup, composing, folders

·        Calendar, tasks, and scheduling meetings

·        Outlook Productivity Tips

·        Rules, quick steps, search folders

·        Integration with Word and Excel

9.     Basic Excel Formulas

·         Introduction to Common Functions (SUM, AVERAGE, COUNT)

·         Deep Dive into More Functions (MIN, MAX, IF Statements)

10. Understanding Cell References

·         Absolute vs. Relative References in Excel Formulas

11. Conditional Formatting

·         Learn How to Highlight Key Data Points with Conditional Formatting

12. Sorting and Filtering Data

·         Efficiently Organize and Analyze Large Datasets

13. Using Excel Templates

·         How to Leverage Pre-built Templates for Quick Tasks

14. Introduction to Charts in Excel

·         Visualizing Data with Basic Charts (Bar, Pie, Line)

15. Customizing Charts

·         How to Modify and Format Charts for Better Presentation

16. Data Validation and Protection

·         Preventing Errors and Protecting Your Excel Sheets

17. Working with Multiple Sheets

·         Learn How to Link and Navigate Between Multiple Sheets

18. PivotTables The Basics

·         Introduction to PivotTables for Summarizing and Analyzing Data

19. Basic Formula

·         Formulae that Add / Subtract / Multiply / Divide

·         BODMAS / Formula Error Checking

·         The Sum Function

20. Absolute Referencing

·         Problems with Absolute / Relative Cell Referencing

·         Creating Absolute / Mixed References

21. LOOKUP Functions

·         The VLOOKUP/ HLOOKUP Functions

·         PivotTables

·         Creating, Formatting Simple PivotTables

·         Page Field in a PivotTable

·         Formatting a PivotTable

·         Creating / Modifying a PivotChart

22. Logical Functions 

·         IFs and Nested IF Functions

·         Using AND / OR / NOT Functions

·         Statistical Functions 

·         Using The SUMIF / COUNTIF Functions

·         Using The AVERAGE / COUNT / LARGER / SMALLER Functions

·         Pivot Tables – Advance

·         Adding new calculated Fields / Items

·         Changing the Summary Function

·         Consolidate Pivot table

23. LOOKUP Functions – Advance 

·         MATCH with VLOOKUP Functions

·         INDEX & MATCH Functions

·         OFFSET / INDIRECT functions

24. Logical Functions – Advance

·         If Loop and Nested IF Loop Functions

·         Using IF / ISERROR Functions

25. Chart Data Techniques 

·         The Chart Wizard

·         Chart Types

·         Adding Title / Legends / Labels

·         Printing Charts

·         Adding Data to a Chart

·         Formatting / Renaming / Deleting Data Series

·         Changing the Order of Data Series

26. Date / Time Functions

·         Using The To

·         Now & Date Functions

·         Using The Datedif / Networks / Eomonth Functions 

·         Using The Weeknum Functions

·         · Using The  Edate / Networks Intl / Weeks Intl Functions

27. Text Functions Using

·         The Mid / Search / Left / Right Functions

·         Using The Trim / Clean / Upper/ Lower Functions

·         Using The Substitute / Text Functions

·         Using The Trim / Clean / Proper / Dollar Function

28. Validations

·         Input Messages / Error Alerts / Drop-Down Lists

·         Conditional Formatting

29. Advanced Filters 

·         Extracting Records with Advanced Filter

·         Using Formulas in Criteria

30. Advanced Sorting

·         Sorting by Top to Bottom / Left to Right

·         Creating / Deleting Custom List

·         Sort by using Custom List

31. Hyper / Data Linking

·         Hyper linking data, within sheet / workbook

·         Linking & Updating links between workbooks & application

32. Math & Trigonometry Functions

·         Using SUMPRODUCT Functions

·         Using FLOOR / CEILING/ MROUND / MOD / QUOTIENT Functions

33. Summarizing Data

·         Creating Subtotals / Nested Subtotals

·         SUBTOTALS Formula

34. Outlining

·         Creating / Working with an Automatic / Manual Outline

·         Grouping / Ungrouping

35. Consolidation

·         Consolidating Data with Identical / Different Layout

·         Using Auditing Tools

·         Displaying / Removing Dependent & Precedent Arrows

·         Evaluate Formula – Step IN / Step Out

36. Custom Views

·         Creating Custom Views

·         Displaying Custom Views

·         Deleting Custom Views

37. Sharing and Protecting Workbooks

·         Sharing Workbooks & Tracking Changes

·         Protecting sheets/workbooks / Files

38. Importing & Exporting Data

·         Importing Data from Database / Text Files / Web

·         Exporting Data

·         Changing External Data Range

Practical Projects & Assessment

·        Real-World Project

·        Quiz + Practical Assignment

·        Final Assessment & Certification