COURSE
DESCRIPTION FOR
MICROSOFT EXCEL - CHARTING
AND ORGANIZING DATA
This class description basically covers all versions of Excel.
To request the class description for your version of Excel, send e-mail
to the Office Wiz
Discover all of Excel's impressive charting and list-management
capabilities. The class is instructor-led with plenty of hands-on activities.
Learn to:
- Create charts that graphically represent worksheet data.
- Modify charts.
- Customize charts by applying formatting.
- Enhance worksheets and charts by using the drawing tools
to add graphic objects.
- Sort information in a list by using the Data, Sort command.
- Locate information quickly in a list that meets specified
conditions by using the Advanced filter feature.
LENGTH
Approximately eight hours. Recommend two four hour sessions.
PREREQUISITES
Excel 2000 - Introduction or
equivalent knowledge. Specifically, you should know how to work with worksheets,
write formulas and work with workbooks. You must have a good understanding
of basic Microsoft Windows, file management and personal computers.
SPECIFIC CLASS CONTENT
Lesson 1: Creating charts
Creating a chart sheet
Creating an embedded chart
Comparing chart sheets with embedded charts
Lesson 2: Modifying charts
Chart types
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items
Lesson 3: Formatting a chart
Formatting chart text
Formatting labels
Formatting the chart
Printing a chart sheet
Lesson 4: Using graphic objects
Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts
Lesson 5: Sorting data
Single-level sorting
Multiple-level sorting
Sorting options
Design considerations
Lesson 6: Filtering data
Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list
Appendix A: Querying data
Database functions
External databases and queries
Excel 2000 and the Internet
NECESSARY SOFTWARE AND HARDWARE
- A 486/66-compatible PC that meets minimum hardware requirements
for Windows 95 or later or Windows NT 4.0 or later. A Pentium 90 MHz processor
with 32 MB RAM or better is recommended. The minimum memory requirement
is 16 MB RAM. Check your reference manual for specific hardware considerations.
- Windows 95, 98 or Windows NT 4.0 with Service Pack 3
(or higher) installed.
- Microsoft mouse or compatible pointing device.
- A printer (optional). You must have an installed printer
driver to use Print Preview.
WHAT'S NEXT?
- Excel - Advanced. Master
advanced formulas and other advanced features including macros and pivot
tables.
- Mini Power Sessions:
--Create And Manage A Worksheet Database Using Excel
--Integrate Data And Graphs Into Your Word Document Using Excel And MS
Graph
--Make Sense Of Sales And Product Data With Pivot Tables Using Excel
--Save Time With Functions Using Excel
--Showcase Your Data With Charts Using Excel
--Track And Analyze Business Data Using Excel
| 
