Spread sheet tools presentation

Spread Sheet Tools Presentation that will help you understand the main tools in Microsoft Excel

1. Spreadsheet
Tools
Done by: Shamsa Alfalasi
ID:200922245
Course: COL 270-541

2. Objectives
What is Spreadsheet
What is tool in Microsoft Excel
What is it used for
Who uses Microsoft Excel
What are the basic tools:
Why is it important
Conclusion

3. What is spreadsheet
Definition
Excel or
spreadsheet is used
to represent the
data in more
understandable,
recognizable and
organized form
Example

4. A tool in Microsoft excel
Definition
The "Tools" section
in Microsoft Excel is
a function that will
allow the user to
manipulate or
format the cell that
has been selected
Example

5. What it is used for
Microsoft Excel is
used to organize
numeric data

6. Who Uses Microsoft excel
Accountants
Marketing
professionals
Financial analysts
Students
Teachers

7. Basic Tools
Format
Orientation
Wrap text
Formulas and functions:
-Sum
-Average
Charts:
-Columns
-Pie

8. Basic tools

9. Example
Select the row
containing the
headers and right
click on it and
select Format Cells
option

10. Example
Select the cells you
want to format
Click on the
orientation in the
home tab

11. Example
Select the cells you
want to wrap
Click on the home
tap and then
choose wrap text

12. Formulas and functions
How to write a
formula
The formula
starts with a
= in the front
Example

13. Sum Function
Adds the values in
the function
argument or the
values in the cell
references in the
argument.

14. Average
Provides the
average of the
range of
references in the
argument

15. Charts
Pie
The 3-D pie chart is
a simple chart style
that is useful for
illustrating the parts
of a whole.
Found in the insert
tool
Columns
Columns are the
vertical divisions of
a worksheet that
are identified by
letters.
They are found in
the insert tool

16. Resources
Desk, G. (2008, n/d n/d). How To Use Excel.
Retrieved Nov 7, 2011, from Geeks Desk:
http://www.geeksdesk.com/how-to-use-excel/
oeHowTech. (2009 , March 10). Computer Tech
Support : Definition of Tools in Microsoft Excel .
United States.
Intelligentedu. (n/d, n/d n/d). Microsoft Excel
Glossary. Retrieved Nov 7, 2011, from
Intelligentedu:
http://www.intelligentedu.com/microsoft_excel_gl
ossary.html

17. Winter, J. D. (n/d). How to use a
spreadsheet. How to use excel, 10.