|
After taking this course, the learner will be able to work with a spreadsheet application to insert and manipulate data. The learner will also be able to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts.
Objectives:
- Open, revise, close, and print a spreadsheet
- Insert, select, copy, move, and delete data
- Search, replace, sort, and format data
- Use, create, and copy both formulas and functions (e.g., SUM, AVERAGE, and IF)
- 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 alignments 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 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
|
|
