SECTION 1 - WINDOWS
Chapter 1 THE COMPUTER & ITS PARTS
1.0 What is a Computer?......................................................................................................
3
1.1 Parts of a Computer ........................................................................................................3
1.1 Input Device....................................................................................................................3
1.1.1 The Keyboard..............................................................................................................3
1.1.2 The Mouse ..................................................................................................................4
1.2 Output Device................................................................................................................
5
Chapter 2 USING THE COMPUTER
2.0 Understanding Your Computer........................................................................................11
2.4.1 How to open an item in the Computer...........................................................................12
2.5 Windows Explorer...........................................................................................................13
2.6 Creating a Folder............................................................................................................
14
2.6.1 Renaming a Folder/File.
.....
.. 15
2.6.2 Deleting a Folder
..............
.
. 15
2.7.2 Using the Shift key.......................................................................................................
16
2.7.3 Using the Delete and Backspace keys...........................................................................16
Chapter 4 COMPUTER VIRUSES
4.0 Computer Virus
...........
.
.
... 27
4.1 Types of Viruses
...........
................ 27
4.2 E-mail Viruses
.........
...
27
4.5 How to Protect Your Computer from Virus Attack
...
............
.....
28
Chapter 5 COMPUTER NETWORK
5.1 Types of Network
................
..
31
5.2 Requirements For a Network
.
..................
...
31
5.3 Sharing Files/Folders
.
...............
32
5.4 How to Access Files on the Network
.
......................
34
5.5 Security on the Network
.
.................
34
5.6 Windows Firewall
.
...............
35
SECTION 2 - MICROSOFT WORD
Chapter 8 FORMATTING YOUR DOCUMENT
8.0 Changing Font Type, Size and Style
.........
......
53
8.1 Correcting Spelling Errors and Changing Case
...
........
55
8.2 Using Find, Replace and Go To
............
56
8.3 Using More Formatting Tools (Alignment, Subscript, etc)
.........
. 57
Chapter 9 USING THE INSERT MENU
9.0 Moving and Resizing Objects
...
..........
....
.
63
9.1 Inserting a Picture
..........
.
..
.
..
....
..63
9.2 Inserting a Text Box
..............
.
...
..67
9.3 Inserting Date, Time, and Page Numbers
...........
..
...
.68
9.4 Inserting Objects
.........
..
..70
Chapter 10 WORKING WITH TABLES
10.0 Creating Tables..............................................................................................................73
10.2 Formatting cells..............................................................................................................76
10.3 Deleting Rows and Columns...........................................................................................77
10.4 Merging Cells.................................................................................................................78
10.5 Inserting Rows and Columns...........................................................................................80
Chapter 11 PRINTING IN WORD
11.0 Adjusting the Margins of Your Document........................................................................85
11.1 Using Page Setup.............................................................................................................85
11.2 Printing on a Letter-Headed Paper...................................................................................86
11.4 Sending Your Job to the Printer........................................................................................88
SECTION 3 - MICROSOFT EXCEL
Chapter 12 USING MICROSOFT EXCEL
12.0 What is Microsoft Excel?..............................................................................................93
12.2 Starting a New Worksheet............................................................................................94
12.3 Opening an Existing Worksheet.....................................................................................95
12.4 Navigating Your Worksheet..........................................................................................95
12.6 Copying and Moving Cells Within a Worksheet.............................................................96
12.7 Inserting Pictures, Text Boxes, etc.................................................................................97
Chapter 14 USING FORMULAS
14.1 Using the SUM and PRODUCT Functions...................................................................109
14.3 Using the MAX, MIN, AVERAGE and STDEV Functions...........................................112
14.4 Using the IF Function...................................................................................................
114
14.5 Showing Sub Totals in Excel........................................................................................
117
Chapter 15 USING CHARTS
15 .0 Presenting Data with Charts ........................................................................................123
15.1 The Column Chart ......................................................................................................
123
15.2 The Pie Chart ..............................................................................................................126
Chapter 16 DATA ANALYSIS
16.0 The PivotTable............................................................................................................
131
16.2 PivotTable Wizard........................................................................................................131
16.3 Sample Customer Report.............................................................................................
132
SECTION 4 - MS POWERPOINT
Chapter 18 USING MICROSOFT POWERPOINT
18.1 Choose a Topic............................................................................................................152
18.2 Choose and Arrange the Sub Topics ............................................................................152
18.3 PowerPoint User Interface ...........................................................................................153
18.4 Create Your Slides .....................................................................................................
154
Chapter 20 SLIDE ANIMATION
20.0 Animating Your Slides..................................................................................................
169
20.1 Slide Transition.............................................................................................................
170
20.2 Slide Show...................................................................................................................
172
21.3 Slide Transition..............................................................................................................185
21.4 Slide Show...................................................................................................................
185
SECTION 5 - INTERNET GUIDE
Chapter 22 INTRODUCTION TO THE INTERNET
22.3 How to Know Your Internet Speed................................................................................193
22.4 How to Search the Internet.............................................................................................193
22.5 How to Create an Email Account...................................................................................
194
22.9 How to Send More Than One Mail at a Time (CC, BCC)...............................................198
22.11 Blocking Unwanted Mails.............................................................................................198
22.12 Spam Mails.................................................................................................................
198
22.13 Phishing.......................................................................................................................
198
Chapter 24 HOW TO OWN A WEB SITE
23.1 Things to Consider Before Owning a Web Site..............................................................
.205
23.2 Advertising Your Company with Your Web Site.............................................................
205
List of Short Cuts....................................................................................................................209
|