MS - Excel 2007

 INTRODUCTION TO EXCEL 2007

Microsoft Excel 2007 is a powerful spreadsheet application developed by Microsoft as part of the Microsoft Office 2007 suite.

It is mainly used to store, organize, calculate, analyze, and present data in the form of rows and columns.

Excel 2007 introduced a new Ribbon interface, which made working with spreadsheets easier and more efficient.

What is Microsoft Excel 2007?

Microsoft Excel 2007 is software that allows users to work with numerical data, text, formulas, and charts.

It is widely used in offices, schools, businesses, banks, and homes.

Excel files are called workbooks, and each workbook contains one or more worksheets.

Features of Excel 2007

Excel 2007 provides many useful features, such as:

Large worksheets (more rows and columns)

Powerful formulas and functions

Easy data editing and formatting

Chart and graph creation

Sorting and filtering data

Data validation and protection

Components of Excel 2007 Window

1. Title Bar

Displays the name of the workbook and the Excel program.

2. Office Button

Provides options like New, Open, Save, Print, and Close.

3. Ribbon

The Ribbon replaces old menus and toolbars.

It contains tabs like Home, Insert, Page Layout, Formulas, Data, Review, and View.

4. Worksheet Area

The main working area where data is entered into cells.

5. Rows and Columns

Rows are horizontal (1, 2, 3, …)

Columns are vertical (A, B, C, …)

6. Cell

A cell is the intersection of a row and a column.

Each cell has a unique address, such as A1, B2, C5.

7. Formula Bar

Displays and allows editing of data or formulas in the active cell.

8. Status Bar

Shows information like sum, average, and mode of selected cells.

Uses of Microsoft Excel 2007

Excel 2007 is used for:

Data entry and management

Mathematical calculations

Creating budgets and accounts

Preparing reports

Making charts and graphs

Analyzing large data sets

Advantages of Excel 2007

Easy to use interface

Fast calculations

Accurate data analysis

Supports charts and graphics

Saves time and effort

Limitations of Excel 2007

Requires computer knowledge

Large files may slow performance

Not suitable for very large databases

Needs Microsoft Office installation

Importance of Excel 2007

Excel 2007 plays a vital role in:

Business decision-making

Financial management

Education and research

Office automation

Data analysis and reporting

 STARTING WITH EXCEL 2007

To start the Excel 2007 application window, click the Start → All Programs → Microsoft Office Microsoft Office Excel 2007.

The first screen that you will see is a new blank worksheet that contains grid of cells. This grid is the most important part of the Excel window. It's where you'll perform all your work, such as entering data, writing formulas, and reviewing the results.

 OPENING A NEW WORKBOOK

A workbook in Microsoft Excel is a file that contains one or more worksheets used to store and organize data.

Opening a new workbook means creating a blank Excel file so that new data, formulas, and charts can be entered.

What is a Workbook?

A workbook is the main Excel file, usually saved with the extension .xlsx.

Each workbook can contain multiple worksheets, and each worksheet is made up of rows, columns, and cells.

Why Do We Open a New Workbook?

We open a new workbook to:

Enter fresh data

Create new calculations

Prepare reports and records

Make charts and tables

Start a new Excel project

Methods of Opening a New Workbook in Excel 2007

Method 1: Using the Office Button

This is the most common method.

Steps:

Open Microsoft Excel 2007

Click on the Office Button (top-left corner)

Click New

Select Blank Workbook

Click Create

A new blank workbook will open.

Method 2: Using Keyboard Shortcut

This is the fastest method.

Steps:

Press Ctrl + N

A new workbook opens instantly.

Method 3: When Excel Starts

By default, when you open Excel 2007, a new blank workbook opens automatically.

Components of a New Workbook

A new workbook includes:

One or more worksheets (Sheet1, Sheet2, Sheet3)

Rows and columns

Cells with unique addresses

Formula Bar

Ribbon and Status Bar

Saving a New Workbook

After opening a new workbook, it should be saved.

Steps to Save:

Click Office Button

Click Save

Choose location

Enter file name

Click Save

Advantages of Opening a New Workbook

Helps organize data properly

Prevents mixing old and new data

Allows clean and accurate work

Supports professional documentation

Common Mistakes to Avoid

Forgetting to save the workbook

Overwriting an existing file

Entering data in the wrong worksheet

Importance of New Workbooks in Excel

Opening a new workbook is essential for:

Data management

Accounting and finance

Reports and analysis

Office and business tasks

Academic projects

 SAVING THE WORKBOOK

Saving the Workbook is the process of storing an Excel workbook on the computer so that the data and changes made in the worksheet are not lost. A workbook should be saved regularly while working in Microsoft Excel.

If a workbook is not saved and the computer shuts down unexpectedly, all the entered data may be lost.

Need for Saving a Workbook

Saving a workbook is necessary for the following reasons:

To keep the data safe for future use

To avoid loss of data due to power failure or system crash

To reopen and modify the workbook later

To share the workbook with other users

Methods of Saving a Workbook

1. Saving a Workbook Using Save Command

The Save command is used to save a workbook for the first time or to save the latest changes made in the workbook.

Steps:

Click on the File tab

Select Save

Choose the desired location

Enter the file name

Click on Save

2. Saving a Workbook Using Save As Command

The Save As command is used to save a workbook with a new name, at a different location, or in a different file format.

Steps:

Click on the File tab

Select Save As

Choose the location

Enter a new file name

Select the file type

Click on Save

3. Saving a Workbook Using Keyboard Shortcut

A workbook can be saved quickly by using the keyboard shortcut:

Ctrl + S

This command saves all recent changes in the workbook.

File Format of Excel Workbook

By default, an Excel workbook is saved with the extension .xlsx. Other formats include:

.xls

.csv

.pdf

 ENTERING DATA IN A WORKSHEET

Entering data in a worksheet refers to the process of typing or inserting information into the cells of an Excel worksheet. A worksheet is made up of rows and columns, and the intersection of a row and a column is called a cell. Data is always entered in the active cell.

In Microsoft Excel, different types of data can be entered such as text, numbers, and formulas.

Types of Data Entered in a Worksheet

1. Text (Labels)

Text data includes words, names, headings, and descriptions.

Text is generally used to explain the data.

Example:

Name, Address, Month, Total

2. Numbers (Values)

Numeric data includes numbers used for calculations.

Example:

10, 2500, 45.6, 100%

3. Formulas

Formulas are used to perform calculations on data.

Every formula starts with an equal sign (=).

Example:

= A1 + A2

= SUM(A1:A5)

Steps to Enter Data in a Worksheet

Click on the cell where you want to enter data

Type the required data using the keyboard

Press Enter to move to the next cell

Press Tab to move to the next column

Editing Data in a Cell

Data entered in a worksheet can be edited in two ways:

By double-clicking the cell

By selecting the cell and editing the data in the Formula Bar

Deleting Data from a Cell

To delete data from a cell:

Select the cell

Press the Delete key

Only the data will be removed, not the cell itself.

Important Points to Remember

Data is always entered in the active cell

Excel automatically recognizes the type of data

Proper data entry helps in accurate calculations

 ENTERING TEXT

In an Excel worksheet, text is used to identify, explain, and emphasize numeric data. It comprises characters that cannot be used in calculations. You enter text by typing, just as you would in a word-processing program.

Text (and numbers) longer than one cell width will appear to cover the adjoining cells to the right of the active cell. The covered cells have not been "used" but their contents have just been hidden. To enter text on one line:

1. Click the cell where you want the text to start.

2. Type the text. The text displays in one or more cells. (We will learn to increase the width of the cell and wrap text at a later stage).

3. Complete the entry by pressing ENTER or TAB

ENTERING NUMERIC DATA

Numbers are numerical data. Excel provides several features to help you more easily work with numbers used to represent values.

Enter numbers by simply selecting a cell and typing the numbers.

1. Click the cell where you want the numbers to be entered.

2. Type the number. Use decimal places if you wish to have in the number.

3. Complete the entry.

 Entering Dates

If you can think of a way to enter a date, Excel can probably recognize it as such. For example, following table shows how Excel handles different ways to make the date entry using the date of January 26, 2011 (assuming you entered the date sometime in 2011) in a worksheet.

In case you omit the year in a date, Excel assumes the current year.

Typing this

Displays after completing the entry

4-Feb

42 OR 4-2 OR 4-Feb OR 4-leb

4/2/2011

4/2/11 OR 4-2-11 OR 4/2/2011 OR 4-2-2011 OR 4-2/11 OR 4-2/2011 OR 2011/4/2 OR 2011-4-2

Feb 4. 11 OR February 4, 2011 OR 4-feb-11 OR 4-Feb-2011

4-Feb-11

                                    (REVIEW EXECRISE)

1. Click Start → All Programs Microsoft Office Microsoft Office Excel 2007 to start Excel 2007.

2. In the new blank workbook, make the cell B3 active by clicking the cell with the mouse. The activated cell B3 will look like as given below. You can also see the respective cell address in the Name Box on the left side below the Ribbon.

3. Type Roll No. in this cell and press TAB. You will see that cell C3 becomes active. This can be seen in the following figure.

4. Similarly, type Hindi in cell C3, English in D3, Maths in E3 and Science in cell F3 and press ENTER. This is demonstrated in the figure given below:

5. In a similar manner, enter the following data into this worksheet.

(Press TAB to move into the next column and ENTER to move into the next row)

                      101        57         62          75         74

                      102        66        74          85          76

                      104        62        45          75          85

                      105        75        88          95          78

6. After entering the above data, your worksheet will look like the following figure. Please note that in the Roll No. column, 103 is intentionally left out.

7. Save this file and specify the filename as Class Test as shown in the following dialog box. You will see the file's name on the Title Bar of the window.

8. Close this file by clicking Office Button → Close.

9. Exit Excel 2007 application window. You can press ALT+F4 to do this.

SELECTION TECHNIQUES

Selection techniques refer to the different methods used to select text, cells, rows, columns, or objects in a document or spreadsheet.

Selection is an important step because most computer operations such as copying, moving, deleting, formatting, or editing require selecting data first.

What is Selection?

Selection means choosing a specific part of data before performing any action on it.

The selected area is usually shown with a highlighted background.

Why are Selection Techniques Important?

Selection techniques are important because they:

Save time while working

Improve accuracy

Make editing easy

Help avoid unwanted changes

Increase work efficiency

Selection Techniques in MS Word (Text Selection)

1. Selecting a Word

Double-click on the word

2. Selecting a Line

Move the mouse to the left margin and single-click

3. Selecting a Sentence

Hold Ctrl and click anywhere in the sentence

4. Selecting a Paragraph

Triple-click inside the paragraph

5. Selecting Multiple Lines

Click and drag the mouse over the text

6. Selecting the Entire Document

Press Ctrl + A

Selection Techniques in MS Excel (Cell Selection)

1. Selecting a Single Cell

Click on the required cell

2. Selecting Multiple Cells

Click and drag across cells

3. Selecting a Row

Click the row number

4. Selecting a Column

Click the column letter

5. Selecting the Entire Worksheet

Click the Select All button (top-left corner)

Or press Ctrl + A

6. Selecting Non-Adjacent Cells

Hold Ctrl and click on each cell

Selection Using Keyboard

Shortcut Key

Function

Ctrl + A

Select all

Shift + Arrow Keys

Select step by step

Shift + Home

Select to beginning of line

Shift + End

Select to end of line

Ctrl + Shift + Arrow

Select large data range

Selection Using Mouse

Mouse selection allows:

Click to select one item

Drag to select multiple items

Right-click for options after selection

Uses of Selection Techniques

Selection techniques are used for:

Copying and pasting data

Editing text or numbers

Formatting content

Deleting unwanted data

Applying formulas or styles

Advantages of Proper Selection

Prevents accidental data loss

Speeds up work

Improves accuracy

Makes documents professional

Common Mistakes in Selection

Selecting extra data by mistake

Forgetting to select before applying commands

Overwriting important information

Importance of Selection Techniques

Selection techniques are a basic but essential computer skill.

Without proper selection, it is impossible to work efficiently in documents, spreadsheets, or software applications.

EDITING CELL DATA

You have several choices on how to edit data, depending on whether you want to replace all the contents of a cell or just part of the contents, and whether you want to do it in the cell or in the Formula bar.

To edit data in a cell, you have following three methods:

Double-click the text in the cell where you want to begin editing. An insertion point is placed in the cell.

Select the cell to edit, and then click the cell's contents in the Formula bar where you want to make changes.

 Select the cell to edit, and press F2.

After choosing any one of the above mentioned three options to edit data in a cell, make the desired changes in the cell and complete the entry by pressing ENTER or TAB.

 COPYING THE DATA

Copying the data means creating a duplicate (exact copy) of information and placing it in another location without removing the original data.

This process is widely used in computers to save time, avoid re-typing, and ensure accuracy.

What is Copying the Data?

Copying data is the process of selecting data such as text, numbers, images, files, or folders, and copying it so that the same data can be used in the same place or a different location.

The original data remains unchanged, while a copy is created.

Why is Copying the Data Important?

Copying data helps to:

Save time and effort

Avoid repeated typing

Reduce human errors

Use the same data in multiple places

Improve work efficiency

Types of Data That Can Be Copied

Text data (documents, notes)

Numeric data (tables, calculations)

Image data (photos, graphics)

Audio and video files

Files and folders

Methods of Copying the Data

1. Using Keyboard Shortcuts

This is the fastest and most commonly used method.

Steps:

Select the data

Press Ctrl + C (Copy)

Move the cursor to the destination

Press Ctrl + V (Paste)

2. Using Mouse (Right-Click Method)

Steps:

Select the data

Right-click and choose Copy

Go to the destination

Right-click and choose Paste

3. Using Menu Options

Many applications provide menu options:

Edit → Copy

Edit → Paste

4. Copying Files and Folders

To copy files or folders:

Select the file/folder

Right-click → Copy

Paste it into another location

Copying Data in Different Applications

Copying Data in MS Word

Used to duplicate text, images, or tables without deleting the original content.

Copying Data in MS Excel

Used to copy cells, formulas, rows, and columns.

Copying Data in Internet Browsers

Used to copy text, links, images, or web content.

Difference Between Copying and Moving Data

Copying Data

Moving Data

Original data remains

Original data is removed

Creates a duplicate

No duplicate created

Uses Ctrl + C

Uses Ctrl + X

Advantages of Copying the Data

Fast and easy process

Improves productivity

Maintains data accuracy

Useful for backup purposes

Reduces repetitive work

Common Shortcut Keys

Ctrl + C – Copy

Ctrl + V – Paste

Ctrl + A – Select All

Ctrl + Z – Undo

Importance of Copying Data in Daily Life

Copying data is used in:

Office work

Education and projects

Data entry jobs

Blogging and content creation

Software development

https://www.youtube.com/@KrishnaDubaiMotivation

https://www.facebook.com/share/1H9PPi8tMX/

https://www.instagram.com/officialkrishnadubai?igsh=MXY1eDJiY3owOGtiYQ==

https://wa.me/message/ONUZUUV4Q2YGO1

For corporate Inquiries:

Call Us: +91 9262835223