About 'Becoming An Email Exemplar'

Is email getting you down or reducing productivity in your organisation? Email Exemplar is here to help! We'll show you how to deal with the modern deluge of email efficiently and without being overwhelmed. Becoming An Email Exemplar has been produced in partnership with the people at Expert Messaging, who have helped thousands of people with their email woes.

Close

About 'Office Sense'

Many of us suffer from aches and pains caused by regularly working at a computer. Such strains can be avoided by following the simple pointers in Office Sense - a quick and easy course that can make a real difference to the health of your staff. Office Sense has been produced in association with AbilityNet, the leading national charity that supports anyone with a health problem or disability which might make IT use difficult.

Close

What you will learn

By the end of this online course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae, using multiple sheets, linking them to create formulae across sheets, using common functions such as Average and If statements and manage data in an Excel database.

The following subjects are covered on our Beginners Excel courses:

Getting Started with Excel - Starting and Closing Excel; Opening and Closing Spreadsheets; What is a Spreadsheet?; Moving Around a Spreadsheet; Selecting Cells; Adding Text, Numbers and Dates; Editing Cell Contents; Saving Spreadsheets; Saving Into Another File Format; Switching Between Worksheets; Using Undo and Redo; Using Help.

Changing the Way Excel Works - Using the Zoom Control; Showing and Hiding Toolbars; Freezing Rows and Columns; Customising Excel.

Changing the Way Cells Look - Changing the Number Format; Changing Font and Font Size; Applying Bold, Italic and Underline; Applying Shading; Using the Format Painter; Changing Text Alignment; Changing Text Wrapping and Orientation; Applying Borders.

Editing a Spreadsheet -Inserting and Deleting Rows and Columns; Resizing Rows and Columns; Copying and Moving Data; Using AutoFill to Copy Data; Find and Replace Data on a Spreadsheet; Adding, Renaming and Deleting Worksheets; Moving and Copying Worksheets; Sorting Cells; Checking the Spelling

Creating & Copying Formulae -Adding Numbers up with AutoSum; Using the Sum Function to Add Up Lists; Creating Simple Formulae; Recognising Why a Formula Goes Wrong, Using AutoFill to Copy Formulae; Using Absolute Cell References; Using Mixed Cell References.

Using Functions -Using the Average Function; Using the Maximum and Minimum Functions; Using the Count and If Functions.

Charts -Creating a Chart; Changing the Colours in a Chart; Adding Titles and Labels to a Chart; Changing the Chart Type; Moving, Resizing and Deleting a Chart.

Printing -Print Preview and Printing a Worksheet; Printing Ranges and More Than One Copy; Printing Charts; Using Page Break Preview; Printing Gridlines and Headers.

Changing the Layout -Changing the Margins; Page Setup; Creating Headers and Footers.

Close

What you will learn

By the end of this online course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae, using multiple sheets, linking them to create formulae across sheets, using common functions such as Average and If statements and manage data in an Excel database.

The following subjects are covered on our Beginners Excel courses:

Getting Started with Excel - Starting and Closing Excel; Opening and Closing Spreadsheets; What is a Spreadsheet?; Moving Around a Spreadsheet; Selecting Cells; Adding Text, Numbers and Dates; Editing Cell Contents; Saving Spreadsheets; Saving Into Another File Format; Switching Between Worksheets; Using Undo and Redo; Using Help.

Changing the Way Excel Works - Using the Zoom Control; Showing and Hiding Toolbars; Freezing Rows and Columns; Customising Excel.

Changing the Way Cells Look - Changing the Number Format; Changing Font and Font Size; Applying Bold, Italic and Underline; Applying Shading; Using the Format Painter; Changing Text Alignment; Changing Text Wrapping and Orientation; Applying Borders.

Editing a Spreadsheet -Inserting and Deleting Rows and Columns; Resizing Rows and Columns; Copying and Moving Data; Using AutoFill to Copy Data; Find and Replace Data on a Spreadsheet; Adding, Renaming and Deleting Worksheets; Moving and Copying Worksheets; Sorting Cells; Checking the Spelling

Creating & Copying Formulae -Adding Numbers up with AutoSum; Using the Sum Function to Add Up Lists; Creating Simple Formulae; Recognising Why a Formula Goes Wrong, Using AutoFill to Copy Formulae; Using Absolute Cell References; Using Mixed Cell References.

Using Functions -Using the Average Function; Using the Maximum and Minimum Functions; Using the Count and If Functions.

Charts -Creating a Chart; Changing the Colours in a Chart; Adding Titles and Labels to a Chart; Changing the Chart Type; Moving, Resizing and Deleting a Chart.

Printing -Print Preview and Printing a Worksheet; Printing Ranges and More Than One Copy; Printing Charts; Using Page Break Preview; Printing Gridlines and Headers.

Changing the Layout -Changing the Margins; Page Setup; Creating Headers and Footers.

Close

What you will learn

By the end of this online course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae, using multiple sheets, linking them to create formulae across sheets, using common functions such as Average and If statements and manage data in an Excel database.

The following subjects are covered on our Beginners Excel courses:

Getting Started with Excel - Starting and Closing Excel; Opening and Closing Spreadsheets; What is a Spreadsheet?; Moving Around a Spreadsheet; Selecting Cells; Adding Text, Numbers and Dates; Editing Cell Contents; Saving Spreadsheets; Saving Into Another File Format; Switching Between Worksheets; Using Undo and Redo; Using Help.

Changing the Way Excel Works - Using the Zoom Control; Showing and Hiding Toolbars; Freezing Rows and Columns; Customising Excel.

Changing the Way Cells Look - Changing the Number Format; Changing Font and Font Size; Applying Bold, Italic and Underline; Applying Shading; Using the Format Painter; Changing Text Alignment; Changing Text Wrapping and Orientation; Applying Borders.

Editing a Spreadsheet -Inserting and Deleting Rows and Columns; Resizing Rows and Columns; Copying and Moving Data; Using AutoFill to Copy Data; Find and Replace Data on a Spreadsheet; Adding, Renaming and Deleting Worksheets; Moving and Copying Worksheets; Sorting Cells; Checking the Spelling

Creating & Copying Formulae -Adding Numbers up with AutoSum; Using the Sum Function to Add Up Lists; Creating Simple Formulae; Recognising Why a Formula Goes Wrong, Using AutoFill to Copy Formulae; Using Absolute Cell References; Using Mixed Cell References.

Using Functions -Using the Average Function; Using the Maximum and Minimum Functions; Using the Count and If Functions.

Charts -Creating a Chart; Changing the Colours in a Chart; Adding Titles and Labels to a Chart; Changing the Chart Type; Moving, Resizing and Deleting a Chart.

Printing -Print Preview and Printing a Worksheet; Printing Ranges and More Than One Copy; Printing Charts; Using Page Break Preview; Printing Gridlines and Headers.

Changing the Layout -Changing the Margins; Page Setup; Creating Headers and Footers.

Close