Providing Computer & IT Support To The Midlands & Worcestershire
Summary:
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
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