|
European Computer Driving
Licence Version 4.5 Series: Spreadsheets
Product Code: ec4504 Time:
10.0 hour(s) CEUs: Available
|
|
|
This course shows you how to work with a
spreadsheet application to insert and manipulate data. It also shows how
to create formulas and functions, format and print a spreadsheet, import
objects, and create and adjust charts.
Objectives:
- Create and save a spreadsheet
- Open, revise, and close a spreadsheet
- Use application help
- Change display settings
- Insert, select, copy, move, and delete data
- Undo and redo actions
- Search and replace data
- Sort data
- Create and copy a formula
- Use functions such as SUM, AVERAGE, and IF
- Format data
- Preview and prepare a spreadsheet for printing
- Import an object and text file into a
spreadsheet
- Create, adjust, move, and delete a chart
Topics:
- Opening and closing spreadsheets
- Creating and saving spreadsheets
- Using help
- Adjusting settings
- Cells
- Rows and columns
- Editing data
- Copying data
- Moving and deleting data
- Find and replace
- Sorting data
- Handling worksheets
- Working with formulas
- Cell referencing
- Working with functions
- The IF function
- Formatting numbers and dates
- Formatting cell contents
- Working with alignment and border effects
- Creating charts and graphs
- Editing charts and graphs
- Worksheet setup
- Printing worksheets
|
|
P500+ Processor, 128MB of RAM; Windows
2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5
or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K
minimum connection; broadband (256 kpbs or higher) connection recommended;
Javascript, DHTML and cookies enabled; Sound card with speakers or
headphones strongly recommended. |
|
Product names mentioned in this catalog may
be trademarks/servicemarks or registered trademarks/servicemarks of their
respective companies and are hereby acknowledged. All product names that
are known to be trademarks or service marks have been appropriately
capitalized. Use of a name in this catalog is for identification purposes
only, and should not be regarded as affecting the validity of any
trademark or service mark, or as suggesting any affiliation between
MindLeaders, Inc. and the trademark/servicemark
proprietor. | |
|
 |
|
|
