COMPUTER BASICS WITH MS OFFICE

MS Office

Computer Bsics

The course “Computer Basics with MS Office” will help learners understand how to use a computer in a simple way. First, it covers what a computer is, how it works, and how to use it safely. It also explains the main parts of a computer, how to save files, and how to use the internet.

Next, the course teaches about MS Office programs. Learners will practice:

MS Word to type and edit documents.
MS Excel to work with numbers and make tables.
MS PowerPoint to create slides and presentations.

By the end of the course, learners will be able to:

Use a computer for basic tasks.
Create documents, calculations, and presentations using MS Office.
Use the computer for study, work, and daily activities in a smart way.

This course is a simple and useful starting point for anyone who wants to become confident with computers.

Syllabus

Module 1: Windows Basics – Everyday Tools

Notepad – Simple Text Editing Tool
WordPad – Basic Word Processing Tool
Paint – Simple Drawing and Image Editing Tool
Picture Manager –Simple Photo Viewing and Editing Tool
Calculator
Sticky Notes
On-Screen Keyboard
Touch Keyboard

Module 2: Windows Desktop & File Management

How to Enable and Disable Icons On Desktop
Taskbar Management
How to Set Desktop Background, Set Pictures, Solid Colors & Slides?
How to Create Files and Folders?
Delete Functions – Temporary & Permanent
Create A Batch File to Make Folders

Module 3: Windows Security & System Management

Check System Properties
Task Manager Uses and Access Methods
Enable and Disable Devices of a Computer
Enable and Disable Security
Windows Cleanup and Maintenance Tools
Default Programs
Customize Mouse
Disk Defragmentation
Disk Management

Module 4: Microsoft Word – Introduction & Basics

Introduction to
Microsoft Word
Word Interface Overview
Font Groups
Bullets and Numbering
Multi List Level
Alignments
Paragraph and Line
Spacing

Module 5: Microsoft Word – Formatting & Page Setup

Shading & Borders
Sort Ascending & Descending
Paragraph Control
Text Style and Table of Contents
Find and Replace
Format Painter
Insert Cover Page
Page Break Options

Module 6: Microsoft Word – Tables, Objects & Design

Insert Table
Table Design All Functionalities
Table Layout All Functionalities
Insert Picture and Edit Options
Insert Shapes, SmartArt, Chart, Screenshot
Bookmarks and Hyperlink
Links to Webpages
Links to Existing Files
Comments-New, Delete, Previous, Next
Header, Footer & Page Number
How to Insert Textbox
How to Insert Objects
How to Use Signature, Date & Time?
How to Merge Two Documents
Introduction to Equations & Symbols
Watermark- Text and Picture
Page Color & Border
Page Setup – Margins, Orientation, Size, Columns and Hyphenation
Indent Spacing – Front & Backward

Module 7: Microsoft Word – Review & Viewing Tools

Spelling & Grammar
Thesaurus & Word Count
MS Word – Track Changes – Accept, Reject
View Reading Options
Rules & Gridlines
Navigation Pane
Zoom Options in MS Word
Window – Split & Arrange

Module 8: Microsoft Excel – Getting Started

Introduction to Microsoft Excel
Excel Interface Overview
Working with Sheets- Rename, Color, Copy, Move, Group
Working with Cells- Rows, Columns, Size, Auto Fit
Important Shortcuts
Copy and Paste –Using Multiple Tools in MS- Excel
Paste Special
Text to Columns – Multiple Methods
Data Reading Tool
Comments – Add, Edit, Delete, Copy Paste, Background Change

Module 9: Microsoft Excel – Data Tools & Views

Filters in MS –Excel
Freeze Panes & Split Window
Fill Series – Basics
Fill Series – Advanced
Flash Fill
Conditional Formatting
Hyperlinks
Header & Footer
Print & Page Setup
Import Data from Web
Import Objects into Excel
Characteristics of A Cell
Custom View
Workbook Protection
Cell Protection
View Sheets Side by Side
View Multiple Workbooks in Excel

Module 10: Microsoft Excel – Data Validation & Charts

Data Validation – Whole number, Decimal, Date, Time, Text length
Data Validation – List
Excel Charts – Basics
Chart – Insert, Data Control, Improve Chart, Change Series
Pie Chart
Doughnut Charts
Bar Charts
Bubble Charts
3D Containers or Cylinders or Stacked Column

Module 11: Microsoft Excel – Formulas & Functions

Formulas – Points to Remember
Cell Reference – Relative, Absolute, Mixed
SUM, SUMIF, SUMIFS
SUBTOTAL, AGGREGATE, SUMPRODUCT
Math’s Algebra & Trigonometry – SUMX2MY2, SUMX2PY2, SUMXMY2
DSUM, IMSUM, IMSUB
AVERAGE, AVERAGEA
AVERAGEIF, AVERAGEIFS
COUNT, COUNTA, COUNTBLANK
COUNTIF, COUNTIFS
LOGICAL TEST WITH COMPARITIVE OPERATORS
IF FUNCTION
IF AND, IF OR
NESTTED IFS
IFERROR
UPPER, LOWER, LEN
LEFT, RIGHT, MID
PROPER, TRIM
TODAY, NOW
FIND, SEARCH
REPLACE, SUBSTITUTE
CONCATENATE
TEXT
DATE, TIME,
TIMEVALUE

Module 12: Microsoft Excel – Lookup & Pivot Tables

VLOOKUP
HLOOKUP
Match & Index Function
VLOOKUP Advance
VLOOKUP – Apply Across Multiple Cells at A Time.
VLOOKUP – Applying Across Multiple Sheets.
Introduction to PIVOT Table
Pivot Table – Common Mistakes
Usage of Recommended Pivot Table
How to Use Recommended Pivot tables
Create Multiple Report
Add Data Bars to Pivot Table

Module 13: Microsoft PowerPoint

Introduction to Microsoft PowerPoint
PowerPoint Interface Overview
Creating A Basic Presentation – Step-By-Step
Design Slide Background
Transitions Basics
Animations
Text Gradient Effects
Hyperlink (Ctrl +K) In PowerPoint

Module 14: Projects & Practical Applications

Projects (Windows, Word, Excel, PowerPoint combined)
Real-Time Practice Tasks
Project Submission & Review