Class Outline

 

UNC Charlotte

Information & Technology Services
Faculty and Staff Tra
ining

 

Excel Lists and Charts

You can turn your Excel file into list form for easy data accessing.  You can also create charts for easy visual analysis. 

Length
2 hours
Book:
Quick Reference Card
Optional Reference Book
Microsoft Excel 2002 Illustrated Complete
0-6190-4505-1
Prerequisite Class or Equivalent Knowledge:
Get to Know Your Computer
Understand the Windows (or Macintosh) Desktop Create Spreadsheets in Excel

Download Module

Course Content

Working with Lists
  • Planning and designing a List
  • Creating a list range
  • Using Auto sort functions
  • Find and replace

Working with Charts
  • Planning and designing a chart
  • Creating a chart
  • Moving and resizing a chart
  • Editing a chart
  • Changing the appearance of a chart

 


 

 

Top of Page