microsoft excel tutorial: a process manual for beginners presented by: garth, paul, kat, stephen

MICROSOFT EXCEL TUTORIAL:

A PROCESS MANUAL FOR BEGINNERS

Presented by:Garth, Paul, Kat, Stephen

Overview• Introduction• System Requirements• Getting Started with Excel• Formatting Numbers• Creating a Chart / Graph• Conclusion and Summary• Questions?

ENGL 393

Introduction

Microsoft Excel is one of the most prevalent and effective data management applications on the market.

+create and format spreadsheets

+analyze and share information

ENGL 393

System RequirementsComponent Requirement

Computer & 500 MHz processor

Memory 256 MB RAMHard Disk 1.5 GB

Drive CD-ROM or DVD Display 1024x768Operating System Microsoft

Windows XP w/ SP 2

ENGL 393

**Requirements Listed for newest version: Microsoft Office Excel 2007

Getting Started with Excel

o Open Excel from the Windows Start Menu, or launch the program from a short-cut on the desk-top.

ENGL 393

Double Click on the desk-top icon to launch the Microsoft Office Excel

ENGL 393

Formatting Numbers

o Add commas to show thousands, millions, etc

o Add $ to show monetary value

ENGL 393

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 Charto Introduction

o Charts are easy to read

o Visual representation of data is often better than plain text

o Charts appeal to a larger audience

ENGL 393

Creating a Chart1. Highlight

cells including labels

2. Choose Insert, then Chart

3. Choose your chart sub-type

ENGL 393

Creating a Chart1. Press next

2. Preview the data

3. Press next

4. Create titles for chart and x & y axis

ENGL 393

Creating a Chart1. Press Finish2. Move chart to

appropriate section of sheet

Conclusiono Effective

o Efficient

o User-friendly

o Intuitive Design

o Flexible

ENGL 393

Getting Microsoft Excelo Download a Free Trial http://office.microsoft.com/en-us/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.

ENGL 393

Questions?