This course shows users 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.This course describes how to meet European Computer Driving Licence (ECDL) objectives using Microsoft Word on a personal computer that uses a Windows operating system. The ECDL test can be taken with any word processing application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.
Objectives:
After completing this course, students will be able to:
- Using the Application – Working with Spreadsheets, Enhancing Productivity.
- Cells - Insert, Select, Edit, Sort, Copy, Move, Delete.
- Managing Worksheets – Rows and Columns, Worksheets
- Formulas and Functions – Arithmetic Formulas, Functions.
- Formatting – Numbers/Dates, Contents, Alignment, Border effects.
- Charts - Create, Edit.
- Prepare Outputs - Setup, Check and Print.
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
|
