Microsoft Excel

Excel is a spreadsheet application that allows you to organise interrelated numerical information. Data is entered electronically, so numerical figures can be updated without time-consuming recalculations or corrections.

Excel can also create charts to present your data visually. The Chart Wizard enables you to transform data into chart presentations quickly and easily. Your data can appear as a bar, line, area, XY or pie chart.

The advanced tools of Excel allow you to manage data stored in a spreadsheet as if it were a database. You can sort and extract information and view it else in the workbook.

What can I learn from this programme?

The programme covers topics including the following:

Create a Spreadsheet

Additions using AutoSum

Using AutoFit

Use a Template

Create a Formula

Create Absolute References

Format values

Use Format Painter

Format Heading

Use AutoFormat and Conditional Formatting

Check Spelling

Orient the Document

Create Headers and Footers

Print Gridlines, Row and Column Headers

Setting Margins

Use Chart Wizard

Organising Databases with Information

Using AutoFilter

Finding & Extracting Records

| back |