INTRODUCTION TO
SPREADSHEET
NAME – JASHANDEEP KAUR CHEEMA
ROLL NO. – 23527049
SEC – BASIC IT TOOLS
WHAT IS A SPREADSHEET ?
• A spreadsheet is a digital tool used to organize,
calculate, and analyze data in a grid of rows
and columns, often for tasks like budgeting,
data management, and financial analysis.
Popular examples include:- MICROSOFT EXCEL
and GOOGLE SHEETS.
MICROSOFT EXCEL
• MICROSOFT EXCEL is a spreadsheet program
used for data organization, calculation, and
analysis. It offers tools for creating formulas,
charts, and pivot tables, along with features
for data visualization and automation using
macros.
CONCEPT OF WORKSHEETS AND
WORKBOOKS
WORKSHEETS WORKBOOKS
• A worksheet is a single page • A workbook is the entire file
within a workbook. It consists of that you create in a
a grid of rows and columns spreadsheet application.
where you can enter and • A workbook contain multiple
manipulate data. worksheets and stores all
• Each worksheet is essentially a data, formatting, charts, and
large table that you can use for calculations within it.
data entry, calculations, • When you save a file in excel,
graphing, and other data analysis you are saving the entire
tasks. workbook with all its included
• Worksheets are often labeled as worksheets.
Sheet1, Sheet2, etc., by default, • For example , you might have
but you can rename them to separate worksheets for each
something more descriptive month in a financial report
based on their content. workbook.
STARTING MICROSOFT EXCEL
TITLE BAR
• This area of the screen shows the name of the
file you are working on, and which of the
office applications you are working in.
FILE TAB
• With the introduction of Office 2010 Microsoft replaced the
office button with the file tab, and this has continued with
office 2013. Here is where you will find the backstage view
which is the place to access all the file related operations,
and printing options as well as a whole bunch of settings and
options.
QUICK ACCESS TOOLBAR
• As its name suggests, this is a toolbar which the
user can customize to provide access to some of
excels most frequently used commands.
RIBBON
• The Ribbon contains all the commands used
to manipulate your spreadsheet, and is
broken down into four areas:- TABS, GROUPS,
COMMANDS, DIALOG LAUNCHER.
TABS
Ribbon Tab contain multiple commands logically
sub-divided into groups. The standard excel
ribbon contains the following tabs, from left to
right:-
• FILE
• HOME
• INSERT
• DRAW
• PAGE LAYOUT
• FORMULAS
• DATA
• REVIEW
• VIEW
FILE:- HOME:-
• Allows you to jump into the • Contains the most
backstage view that frequently used
contains the essential file- commands such as copying
related commands and and pasting, sorting and
excel options. filtering, formatting, etc.
INSERT:- DRAW:-
• Is used for adding different • Depending on the device
objects in a worksheet such type you’re using, it lets
as images, charts, pivot you draw with digital pen,
table, hyperlinks, special mouse, or finger. This tab is
symbols, equations, available in excel 2013 and
headers and footers. later, but like the developer
tab it is not visible by
default.
PAGE LAYOUT:- FORMULAS:-
• Provides tools to manage • Contains tools for inserting
the worksheet appearance, functions, defining names
both onscreen and printed. and controlling the
These tools control theme calculation options.
settings, gridlines, page
margins, object aligning,
and print area.
DATA:- REVIEW:-
• Holds the commands for • Allows you to check
managing the worksheet spelling, track changes, add
data as well as connecting comments and notes,
to external data. protect worksheets and
workbooks.
VIEW:-
• Provides commands for switching between worksheet views,
freezing panes, viewing and arranging multiple windows.
CREATING A WORKBOOK
1. Select the File tab. Backstage view will appear.
2. Select New, then click Blank workbook.
3. A New blank Workbook will appear.
OPENING AN EXISTING WORKBOOK
1. Navigate to Backstage 2. The Open dialog box will
view, then click Open. appear. Locate and select
your workbook, then click
open.
CLOSE A WORKBOOK
STEP 1:- STEP 2:-
• Click the File tab. • Click the Close button.
SAVING A WORKBOOK
STEP 1:- STEP 2:-
• Click File > Save As. • Under Save As, pick the
place where you want to
save your workbook.
• STEP 3:-
In the File name box, enter a name for a new workbook. Enter a
different name if you’re creating a copy of an existing
workbook.
• STEP 4:-
To save your workbook in a different file format , in the save as type
List [under the file name box], pick the format you want.
INSERTING, RENAMING, MOVING,
COPYING, DELETING WORKSHEETS
INSERTING WORKSHEET :-
1. Select the New Sheet plus icon [+] at the bottom of the
workbook.
2. OR, select Home > Insert > Insert Sheet.
RENAMING WORKSHEET :-
1. Double click the sheet name on the sheet
tab to quickly rename it.
2. OR, right click on the sheet tab, click
Rename, and type a new name.
MOVING OR COPYING WORKSHEET :-
1. To move the tab to the end , right click the
sheet tab then Move or Copy > [move to
end] > OK.
2. OR, click and drag to tab to any spot.
DELETING WORKSHEET:-
1. Right click the sheet tab and select Delete Sheet.
2. OR, select the sheet, and then select Home >
Delete > Delete Sheet.
WORKING WITH MULTIPLE
WORKSHEETS
1. Select the first worksheet you want to
include in the worksheet group.
2. Press and hold the Ctrl key on your
keyboard. Select the next worksheet you
want in the group.
3. Continue to select worksheets until all of
the worksheets you want to group are
selected, then release the Ctrl key. The
worksheet are now grouped.
NAMING CELLS USING NAME BOX,
NAME CREATE AND NAME DEFINE
o NAME A CELL :-
1. Select a cell.
2. In the Name box, type a name.
3. Press enter.
o DEFINE NAMES FROM A SELECTED RANGE:-
1. Select the range you want to name,
including the row or column labels.
2. Select Formulas > Create from selection.
3. In the Create names from selection dialog
box, designate the location that contains the
labels by selecting the Top row, Left column,
Bottom row, or Right column check box.
4. Select OK.
THANK YOU….
