GCRC Computer Skills

1
GCRC Computer Skills

• Excel Advanced Topic
• F\info\training\april01--tng.ppt

2
(No Transcript)
3
Next Time
4
Three Rules of GCRC Computing

• ? ? ? ? ?

Well see if repetition really helps.
5
Rules of GCRC Computing

• Save it to the network always and often.
• Play with the software
• Dream!!!

6
Why use excel?

• Simple lists
• Storing, Formatting, and Using Data
• Reading Other Data Sets
• Charting Trends
• Data calculation/manipulation
• What if analysis

7
Excel limitations
8
(No Transcript)
9
Excel- some review

• Formatting
• Normal MS formatting
• Cell formatting - formatcellnumber
• dates,
• numbers, or
• general
• Word wrap - formatcellalignment
• Cell Height / Width - formatrow
• Borders / Lines

10
Excel- some review

• Autofeatures
• autosum, autofill, etc
• Searching
• Paste Special
• Sorting

11
New Stuff

• Fomulas
• basic and function wizard
• absolute vs mixed references
• Charting Basics
• Using the chart wizard
• Getting it to look like you want
• Finishing touches (titles, notes, and labels)

12
Tricky Stuff(maybe Excel Part iii)

• Pivot tables
• Database functions
• Forms wizard
• Searching
• Filtering data
• Other mechanisms

13
Create Charts

• Charting Basics
• Using the chart wizard
• Getting it to look like you want
• Finishing touches (titles, notes, and labels)
• Linking charts
• Updates automatically
• Web publishing
• Inserting links

14
Your Turn???

• WHAT DO YOU WANT TO KNOW??