"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
Post a Comment