Spreadsheets: Microsoft Excel 

2 x 2-hour lessons     $14   For Windows or Mac users.

Overview

Microsoft Windows Excel is used for Spreadsheet and Database lessons.

Prerequisites

• You need to be familiar with common computer techniques typically used through web browsing, emailing, word processing.
• You need a basic understanding of arithmetic functions, addition, subtraction, multiplication, and division.

Learning Objectives

You will learn about:

• Screen basics
• Data entry into a spreadsheet
• Editing and formatting
• Using standard toolbars
• Calculations, formulas and functions
• Saving files
• Copying and printing sheets
• Recording financial transactions
• Constructing a database
• Managing, sorting and filtering data
• Using the drawing toolbar
• Creating charts
• Other practical uses.

On completion of the course you should be able to:

• Prepare a spreadsheet, edit and format it
• Apply formulas and functions to a spreadsheet
• Use the standard and drawing toolbars
• Create charts from spreadsheet data
• Set up a database, manage, sort and filter it
• Save an Excel file
• Print and copy spreadsheets or database information
• Select from a range of other practical uses of Excel.

Click Timetable to see if there is currently a course scheduled

If no course is scheduled you may email This email address is being protected from spambots. You need JavaScript enabled to view it. to ask to be put on a waiting list.