Microcomputer Applications

1
Microcomputer Applications
CIT 1503 -- Fall 2005 www.clt.astate.edu/jseydel/m
is1503

• Working with Charts in Excel

Instructor John Seydel, Ph.D.
2
Student Objectives

• Use Excel features to
• Identify common chart types and features
• Use Chart Wizard to create embedded charts
• Pie charts
• Column charts
• Combination charts
• Change chart types and modify chart formats
• Chart nonadjacent data series
• Modify chart data series
• Add
• Delete
• Reorder
• Print charts
• Complete Project 7 exercises
• Tutorials
• Challenges 1, 3, 5

3
Upcoming Events

• Exam 2 Tuesday
• Excel concepts, features, and techniques
• Same format as Exam 1
• Job Fair Wednesday
• Try to attend
• Represent ASU and yourself
• Extra benefit / extra credit!
• Today Quiz 4

4
A Quick Demonstration

• Nested IF() functions
• Sometimes necessary
• Can be messy
• Opt instead for lookup functions
• Consider VLOOKUP()
• When choosing from multiple categories
• Alternatively, HLOOKUP()
• Syntax VLOOKUP(Value,LookupTable,Column)
• Example Project 5 Challenge 6

5
Appendix
6
File Management

• Mirror your files use the same folder structure
  for
• Local machine (My Documents folder)
• SuSE1 server
• Portable disk (e.g., jump drive) serves as a
  portfolio of your work
• Structure
• Misc
• index.html
• index.txt
• . . .
• Access
• Excel
• Proj1Solutions
• Music_Mania.xls
• EE1_P1challenge.xls
• . . .
• Proj2Solutions
• . . .
• PowerPoint
• Word