| |
 Microsoft Excel 2003 Training - Intermediate
Class Length: 1 Day
Prerequisites Excel 2003 Introduction, Windows XP:
Introduction or equivalent knowledge
Maximum Class Size: 10
Course Objectives
- Create and apply templates
- Create and modify charts
- Work with graphic objects
- Calculate with advanced formulas
- Sort and filter data
- Use Excel with the Web
Course Outline
- Creating And Applying Templates: create a workbook from a
template, create a custom template, working with comments, create
a hyperlink, use web-based research tools
- Creating And Modifying Charts: create a chart, format chart
items, change the chart type, create a diagram
- Working With Graphic Objects: insert graphics, create AutoShapes,
format graphic objects, change the order of graphic objects,
group graphic objects, move, copy, and resize graphic objects
- Calculating With Advanced Formulas: create and apply a name
for a range of cells, calculate across worksheets, calculate
with date and time functions, calculate with financial functions,
calculate with statistical functions, calculate with lookup
and reference functions, calculate with logical functions
- Sorting And Filtering Data: sort data lists, filter data
lists, create and apply advanced filets, calculate with database
functions, add subtotals to a worksheet
- Using Excel With The Web: export Excel data, publish a worksheet
to a web, import data from the web, create a web query
|
|
