Transcript MICROSOFT EXCEL TUTORIAL: A PROCESS MANUAL FOR

MICROSOFT EXCEL TUTORIAL:
A PROCESS MANUAL FOR
BEGINNERS
Presented by:
Garth, Paul, Kat, Stephen
Overview
ENGL 393
•
•
•
•
•
•
•
Introduction
System Requirements
Getting Started with Excel
Formatting Numbers
Creating a Chart / Graph
Conclusion and Summary
Questions?
Introduction
ENGL 393
Microsoft Excel is one of the most
prevalent and effective data
management applications on the
market.
+create and format spreadsheets
+analyze and share information
System Requirements
ENGL 393
Component
Requirement
Computer &
500 MHz
processor
Memory
256 MB RAM
Hard Disk
1.5 GB
Drive
CD-ROM or DVD
Display
1024x768
Operating System
Microsoft
Windows XP w/
SP 2
**Requirements Listed for newest
version: Microsoft Office Excel 2007
Getting Started with Excel
ENGL 393
o Open Excel from the Windows Start
Menu, or launch the program from a
short-cut on the desk-top.
Double Click on
the desk-top icon
to launch the
Microsoft Office
Excel
ENGL 393
Formatting Numbers
ENGL 393
o Add commas to
show thousands,
millions, etc
o Add $ to show
monetary value
Formatting Numbers Cont’d…
o Enter the data
ENGL 393
Formatting Numbers Cont’d…
o Select a Cell
ENGL 393
Formatting Numbers Cont’d…
o Go to Format at the top menu
o Select Cells
Formatting Numbers Cont’d…
o Click the Number tab
o Select Currency
Formatting Numbers Cont’d…
o Check to see if a “$” is listed
under Symbol
o Click OK
Formatting Numbers Cont’d…
oDollar Sign should appear
o Repeat the steps
Creating a Chart
o Introduction
ENGL 393
o Charts are easy to read
o Visual representation of data is
often better than plain text
o Charts appeal to a larger
audience
Creating a Chart
1. Highlight cells
including labels
ENGL 393
2. Choose Insert,
then Chart
3. Choose your
chart sub-type
Creating a Chart
1. Press next
ENGL 393
2. Preview the
data
3. Press next
4. Create titles for
chart and x & y
axis
Creating a Chart
1. Press Finish
2. Move chart to
appropriate
section of sheet
Conclusion
o Effective
ENGL 393
o Efficient
o User-friendly
o Intuitive Design
o Flexible
Getting Microsoft Excel
ENGL 393
o Download a Free Trial
http://office.microsoft.com/enus/excel/FX100487621033.aspx
The free trial is good for the first 60
days. After that you will have to
upgrade or lose the license for the
product.
Questions?