MS EXCEL
PRESENTED BY :
HIBA AJAZ, AYESHA, FATIMA, ZIMAL,
INTRODUCTION
• What is MS Excel?
• A spreadsheet software developed by Microsoft.
• Part of the Microsoft Office Suite.
• Used for data analysis, storage, and visualization.
WHAT IS USES OF MS EXCEL
•Business: Budgeting, financial analysis, sales tracking, reporting.
•Education: Organizing grades, student performance tracking.
•Personal: Expense tracking, personal finance management.
COMPATIBILITY
•Works on both Windows and macOS platforms.
•Supports collaboration via cloud services (OneDrive, SharePoint).
USER-FRIENDLY INTERFACE
•Intuitive ribbon for easy access to tools.
•Customizable to suit specific tasks.
Absolute
Relative
Cell
Mixed
Referenc
Referenc
Referenc
Referenc
eee
e
Types Of
Cell
References
Cell Relative Absolute Mixed
Referenc Referenc Referenc Referenc
e e e e
• In Excel a reference identifies the
location of a cell or group of cells in
Absolute
Relative
Cell
Mixed the spreadsheet . A cell reference is
Referenc
Referenc
Referenc
Referenc also known as a cell address . A cell
reference consist of the column letter
eeee and row number that meet to form a
cell. These references are used in
formulas, functions, charts etc.
A relative cell reference in a location where it is copied.
formula is based on the relative position of the cell
Absolute
Relative
Mixed contained in the formula. By default, a spreadsheet cell
Referenc
Referenc reference is relative. This means, when the formula or
Referenc function is copied and pasted to other cells, the cell
eee references in the formula or function change relative to
the.
e Absolute
Mixed
c Referenc
e
An absolute cell reference in a formula always refers to
a cell in a specific location. This is done by fixing the cell
by using the dollar sign ($) in front of a row and a
column. Here even if the position of the cell that
contains the formula changes, the reference of the cell
will remain the same.
A mixed reference has an
te Mixed
e absolute column and a relative
nc
c Referenc row, or an absolute row and a
relative column. An absolute
e column reference takes the
from $A1, $B1, and so on. An
absolute row reference takes
the form A$1, B$1, and so on. If
the position of the cell that
contains the formula changes,
the relative reference is
changed, but the absolute
reference dose not change.
SORTING DATA
• In a spreadsheet, it is easy to maintain data as the
sheet is divided into rows and columns. Data when
entered in a sheet may not be arranged in an order.
However, you can arrange it in either ascending or
descending order. This physical rearrangement of
data in ascending order is called sorting. In Excel,
sorting data is one of the most useful features.
SORTING DATA
1st type of sorting data
Ascending Order
Ascending Order
Arranging the data in an increasing order.
For example, letters from A to Z and
numbers from lowest to highest.
SORTING DATA
1st type of sorting data
Ascending Order
Descending Order
2nd type of sorting data
Descending Order
Arranging the data in a descending order. For
Example, letters from Z to A and numbers from
highest to lowest.
Descending Order
2nd type of sorting data
Sorting on
one column
Sorting ion one column
Here data is arranged in ascending or
descending order for only one column. For
example, a list of students in a class with the
‘Name’ of all the students arranged in
ascending order.
Sorting on
one column
Sorting on more than
one column
Sorting on more
than one column
When data is arranged in ascending or
descending order in one column, it can
again be stored within another column.
For example, the student list sorted in the
‘Name’ column within one class.
Sorting on more than
one column
FILTERING DATA
• You may have to scan through rows in an Excel worksheet to find
data. It may be the name of a person or contact information. Going
through all of the data takes time, especially if the worksheet
contains hundreds or even thousands of entries. MS Excel has the
answer to this problem in the form of filtering.
• Filtering shows the data you wish to see while
temporarily hiding the rest. By defining
different filters, you can compare data in
multiple ways. Filtering is a facility in Excel that
allows a user to shift items in a list according to
a set criteria. You can filter text, numbers or
dates.
TYPES OF
FILTERING DATA
Filter Advance
Filter
When you apply filter
to worksheet, grey
color drop-down
controls (Filter
Filter
switches) appear to
the right of the
column headings of a
list. Using these
switches, you can
filter any of the data.
When you apply
Advance Filter to a
Advanced
worksheet , it helps
Filter
to filter the list
based on a specific
criteria or to copy
the filtered data to
a different location.
CREATING CHARTS
• A chart is a graphical representation of
information. A chart often makes it easier
to understand the data in a worksheet
because it can clearly show patterns and
trends that are otherwise difficult to see.
TYPES
TYPESOF
OFCHARTS
CHARTS
Column Chart Line chart Pie Chart
Use Use Use
Shows the size of
Shows data
Shows trends in items that makes
changes over a up a data series
period of time data at equal proportional to the
or illustrates intervals. sum of the items,
comparison of the items, and
containing only one
among items.
data series.
Bar Chart Area Chart XY(sheet)
Chart
Use Use Use
Shows the
Illustrates relationships
comparisons Emphasises the among the numeric
among magnitude of values in several
change over data series, or plots
individuals two groups of
items time numbers as one
series of xy
coordinates.
Stock Chart Surface Chart Bubble Charts
Use Use Use
Shows highs and Find optimum Shows three
lows in stock combination sets of data in a
data. between two graphical way.
sets of data.
Doughnut
Radar Chart
Chart
Use Use
Shows the Compares the
relationship of aggregate value
parts of several of a number of
sets of data. data series.
THANKYOU
