"Mastering Basic Computer Skills: A Comprehensive Guide to Word, Excel, and PowerPoint"

 **MS Paint**

- Definition of MS Paint

- How to open MS Paint

- Introduction to the Mouse

- Mouse Actions

- Drawing a Hut

**Day 2**

- Drawing Shapes

- Working with Text

**Day 3**

- Introduction to the Keyboard

- MS Notepad

- Typing Sentences

**Day 4**

- Find, Replace & Time, Date, Font

- MS Word

- Unit 1: HOME

  - Definition of MS Word

  - How to open MS Word

  - Window Introduction of MS Word

  - File Tab

  - Creating a Document

  - 1. Home Tab

  - Typing Sentences

  - How to Save a Document

**Day 5**

- Typing a Paragraph

**Day 6**

- Superscript (Ctrl + Shift + +)

- Subscript (Ctrl + =)

**Day 7**

- Formatting

- Change Case

**Day 8**

- Bullets

- Numbering

- Multilevel List

**Day 9**

- Sorting

- Shading & Borders

**Day 10**

- Lesson 1: A GOD letter

- Lesson 2: Environment

- Lesson 3: Benefits of computers

**Day 11**

- Unit 2: INSERT

- Cover Page

**Day 12**

- Fruits Table

- Study Schedule

**Day 13**

- Insert Picture

- Clip Art

- Shapes

**Day 14**

- Smart Art

- Chart

**Day 15**

- Hyperlink

- Header & Footer

- Page Number

- Text Box

**Day 16**

- Word Art

- Date & Time

- Equation & Symbol

**Unit 3: PAGE LAYOUT**

- Watermarks

- Page Color

- Page Borders & Horizontal Line

Unit 4: References

Day 17:

- References Tab

- Computer

- Characteristics of Computer

  - SPEED

  - Accuracy

  - Reliability

  - Versatility

  - Storage Capacity

- Software

  - System Software

  - Application Software

Day 18:

- Insert Footnote & Endnote

Day 19:

- Insert Citation & Bibliography

- Bibliography

Day 20:

- Insert Caption

Unit 5: Mailings

Day 21:

- Mailings Tab

- Letter

- Recipients List

Unit 6: Review

Day 22:

- Review Tab

- Spelling Grammar & Research

Day 23:

- Word Count

Unit 7: View

Day 24:

- View Tab

MS Excel

Unit 1: Home Tab

Day 1:

- Definition of MS Excel

- How to open MS Excel

- Window Introduction of MS Excel

- Creating a Workbook

- Excel Arithmetic Operators

- How to Save Workbook

Day 2:

- Addition

- Subtraction

Day 3:

- Multiplication

- Division

Day 4:

- Sum

- Max

- Min

Day 5:

- Wrap Text

- Merge & Center

Day 6:

- Orientation

Day 7:

- Greater Than

- Less Than

- Between

Day 8:

- Equal

- Text That Contains

Day 9:

- Date Occurring

- Duplicate & Unique

Day 10:

- Top/Bottom Rules

- Data Bars

Unit 2: Insert Tab

Day 11:

- Pivot Table

Day 12:

- Charts

Unit 3: Page Layout Tab

Day 13:

- Page Layout Tab

Unit 4: Formulas

Day 14:

- Upper

- Lower

- Proper

Day 15:

- Trim

- Left

Day 16:

- Mid

- Right

- Length

Day 17:

- Concatenate

- Exact

Day 18:

- Is Number

- Is Text

- Is Even

- Is Odd

- Abs

Day 19:

- Round

- Average

Day 20:

- Count

- Counta

- Countblank

Day 21:

- Vlookup

Day 22:

- IF

Day 23:

- Nested IF

Day 24:

- OR

- AND

Day 25:

- Format Cells

Unit 5: Data Tab

Day 26:

- Remove Duplicates

- Drop Down List

- Text Length

Unit 6: Review Tab

Day 26:

- Comment

Unit 7: View Tab

Day 27:

- Workbook Views

- Show

- Zoom

- Window

Formulas Solutions


MS PowerPoint

- Definition of MS PowerPoint

- How to open MS PowerPoint

- Window Introduction of MS PowerPoint.


Comments