INTRODUCTION TO MICROSOFT OFFICE EXCEL 2007

Excel 2007 enables us to effectively manage much larger worksheets, and it provides significant improvement in calculation speed. The new results-oriented user interface makes it easy to work in Microsoft Office Excel. This module covers the features of Excel 2007, printing and charting, excel table. Microsoft Excel is a mathematical formula functions (+,-,X,/,%,grades etc). It has inbuilt Rows and Columns in Excel 2007

How many Rows are there in One Column?

1048576 Rows

How many Columns are there in One Row?

16384 Columns

Active Cell:- A1(A column and 1 Row) is the active or Reference Cell

How many by default Worksheets are there in one Workbook?

3 Worksheet

Worksheet:- Worksheet is also known as Spreadsheet. To entire Rows and Columns are there in One Worksheet.

Cell Address: To Intersection of the Rows and Columns are called Cell Address

Move and Drag

Shape	Context	It Does
Default pointer shapes	The default pointer shapes; appears in most excel workspace context	Move cell pointer or selects a range of cells
border of a windows	Appear when the pointer is on the border of a windows	Adjust Windows size
editing cellcontents	Appears when we are editing cell contents	Provides a text insertion points
appers when the pointer	Appears when the pointer is on a columns or row heading	Select columns or rows
cell border graphics charts or picture	Appears when the pointer is moving placed over a cell border, graphics charts or pictures	Moving cells, graphics or objects
fill corner	When the pointer is on the “fill corner” of  a cell or cell range	Auto Fills other cells with similar formulas
mouse is place over the ribbon	Appears when mouse is placed over the Ribbon	The standard MS Windows pointer; selects Ribbon and menu options

INTRODUCTION TO MICROSOFT WINDOWS 7

Use the Shut down button on the Start menu

To turn off your computer using the Start menu, click the Start button, and then, in the lower-right corner of the Start menu, click Shut down. When you click Shut down, your computer closes all open programs, along with Windows itself, and then completely turns off your computer and display.

DESKTOP

Desktop is just like a background. When you open programs or folders, they appear on the desktop. You can also put things on the desktop, such as files and folders. The taskbar sits at the bottom of your screen. It shows you which programs are running and allows you to switch between them. It also contains the Start button, which you can use to access programs, folders, and computer settings.

Working with desktop icons

Icons are small pictures that represent files, folders, programs, and other items. When you first start Windows, you'll see at least one icon on your desktop: The Recycle Bin (more on that later). Your computer manufacturer might have added other icons to the desktop.

Adding and removing icons from the desktop

You can choose which icons appear on the desktop—you can add or remove an icon at any time.

To add a shortcut to the desktop

1.       Locate the item that you want to create a shortcut for. (For help with finding a file or folder, see Find a file or folder. For help with finding a program, see The Start menu (overview).)

2.       Right-click the item, click Send to, and then click Desktop (create shortcut). The shortcut icon appears on your desktop.

 To move a file from a folder to the desktop

1.       Open the folder that contains the file.

2.       Drag the file to the desktop.

To remove an icon from the desktop

·         Right-click the icon, and then click Delete. If the icon is a shortcut, only the shortcut is removed; the original item is not deleted.

The Recycle Bin

When you delete a file or folder, it doesn't actually get deleted right away—it goes to the Recycle Bin. That's a good thing, because if you ever change your mind and decide you need a deleted file, you can get it back.

The Start menu (overview)

The Start menu is the main gateway to your computer's programs, folders, and settings. And as "start" implies, it's often the place that you'll go to start or open things.

Use the Start menu to do these common activities:

·         Start programs

·         Open commonly used folders

·         Search for files, folders, and programs

·         Adjust computer settings

·         Get help with the Windows operating system

·         Turn off the computer

·         Log off from Windows or switch to a different user account

Opening programs from the Start menu

One of the most common uses of the Start menu is opening programs installed on your computer. To open a program shown in the left pane of the Start menu, click it. The program opens and the Start menu closes.

How to create the folder

Syntax

If you want to open the my documents, my computer, desktop

First click right hand click

New--- Folder

Type the Folder Name

Press enter                                                                       Desktop

                           Almirah(main folder)

                                                               Box1(Sub folder)       Box 2(sub folder)

                                                                                             

                                                             File 1      File 2                  File 1      File 2

Icons: It is used for shortcut program icons in desktop. There are three types of icons

1.       File
2.       Folder
3.       Programs

How many five Desktop Icons

My Computer:- is a personal computer and show the harddisk drives. C:\(installing of the programs) d:\,e:\f:\ is create the folders, files, pictures and software dump copy

My document: is a personal documents. It is used for storing files, create folders.

Internet explorer:- is a web browser

Recycle bin:- It is used for deleting files, folders and pictures to Desktop, My Documents, My Computer    etc and show the Recycle bin(delete files). It is the temporary files delete to Recycle Bin. If you want to not deleting files, folders to Recycle bin. You can restore file or folders to Recycle Bin to Desktop, My Documents, My Computer.

Network place:- Connect to Internet  

How you can use the PenDrive

We can copy the pictures, files, folders from the harddisk (Desktop, My Documents, My Computer ) to copy, send to  or cut to Pendrive.

DIPLOMA IN COMPUTER APPLICATION DURATION:- 6 Months

1. Basics of Computer Fundamental
2. Operating System (Microsoft Windows-7 & 8)
3. Hardware Assembling & Troubleshooting
4. MS Office 2007/2010
      MS Word 
      MS Excel
      MS PowerPoint
      MS Access 
      MS Outlook
5. Introduction to Internet
6. Introduction to C Programming
7. Introduction to Visual Basic

DIPLOMA IN COMPUTER APPLICATION Duration: 1 Year

1. Basics of Computer Fundamental
2. Hardware Assembling & Troubleshooting 
3. Operating System (Microsoft Windows-7 & 8)
4. M.S. Office 2007/2010
     MS Word
     MS Excel
     MS PowerPoint
     MS Access  
     MS Outlook and Mozilla Thunderbird
5. Introduction to Internet
6. Introduction to C Programming
7. Introduction to Visual Basic
8. Oracle
      SQL
      PLSQL
9. Project

       

BASICS OF COMPUTER COURSE Duration: 3 Months

1. Basics of Computer Fundamental
2. Operating System (Microsoft Windows-7 & 8)
3. Hardware Assembling & Troubleshooting
4. M.S. Office 2007/2010

         MS Word
         MS Excel 
         MS PowerPoint
         MS Access
         MS Outlook and Mozilla Thunderbird

     5.  Introduction to Internet

BASICS OF COMPUTER FUNDAMENTAL

Define Computer

Computer is an electronic device which we can process raw data under the control to generate useful information.`

Electronic:- is also known as digital device. Digital is the short form of digits. There are two digits:- 0 & 1. 0 is off and 1 is on.

Device:- is also known as machine. These are two types of devices:-    Input      Process     Output

     Input Devices                               Process                                                Output
Keyboard, Mouse, Scanner              C.P.U (C.U and A.L.U)                     Monitor, Printer
    
Types of Computer

Desktop Computers:- Desktop computers are designed for use at a desk or table. They are typically larger and more powerful than other types of personal computers. The main component, called the system unit, is usually a rectangular case that sits on or underneath a desk.

Laptop computers:- Laptop computers are lightweight mobile PCs with a thin screen. Laptops can operate on batteries, so you can take them anywhere. Unlike desktops, laptops combine the CPU, screen, and keyboard in a single case. The screen folds down onto the keyboard when not in use.

Smartphones:-Smartphones are mobile phones that have some of the same capabilites as a computer. You can use a smartphone to make telephone calls, access the Internet, organize contact information, send e‑mail and text messages, play games, and take pictures. Smartphones usually have a keyboard and a large screen.
Handheld computers:-Handheld computers, also called personal digital assistants (PDAs), are battery-powered computers small enough to carry almost anywhere.
Uses of Computer:
1.      Storing:- It is used for store the files, if you want to add or change the matter in old file. Click Save. Otherwise if you want store the new file name now click Save as.
2.      Searching:- It is used for searching the words, files, folders, programs and pictures.
3.      Calculator: With the help of computer it is used for calculate the mathematical functions. Ex.

4.      Entertainment: - It is used for playing games, listening music, movies, songs etc.

5.      Communicate:- It is used for chatting, send the messages, file attachments through internet

Full Form of Computer:- C – Common    O – Oriented   M – Machine   P – Particularly  U- Used for Under T- Technical E- Education &  R- Research

Master of Computer

Charles Babbage

Fields of Computer

1.      Hospital

2.      Banks

3.      Schools

4.      Electricity Board

Methods of Computer

1.      Information:- it is the full form of data is called information. i.e. One person to give the information to other person.

2.      Data:- Data is used to unorganised facts or figures which are recorded in computer is called data. Three types of data:- Alphabetic:- A-Z, Numeric:-0-9, Symbols:- +,-,x,/,% etc.

3.      File:- It is the further collection of data is called file. Account List, Student List etc.