Microsoft Excel Training near Nashville Tennessee
MS Excel 2003, 2002, 2000 Level 2
1 Day Training Class
Performance-based objectives of this MS Excel 2003 training class:
- 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.
- Very useful functions: Sumif, Countif, IF, Concatenate
- Conditionally format data
Training Course 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
- Importing Data
- Design Considerations
Lesson 6: Filtering Data
- Filtering a List
- Custom Criteria
- Multiple-condition Criteria
- Managing a Filtered List
Useful functions and Tools
- IF
- Sumif
- Countif
- Concatenate
- Conditional formatting
- Text to columns
|
Please Consider our Schedule for Microsoft Excel Training near Nashville Tennessee
Training Schedule
(DSOC0262)
Training for this course is not presently scheduled, but give us a call...
We may be able to schedule a training class for you |
