Microsoft Excel

Duration: 1 day
Next Course : TBA enquire here

Cost: £150 ex VAT
concessions available
Times: 10am - 5pm

At the end of this course you will have a good understanding of the basic features and functions of Excel. You will feel confident using Excel, and be able to create a spreadsheet from scratch. Understanding and using some of the built-in calculation and formula functionality will allow you to be more productive in your work and at home.

Suitable for:

Our Microsoft Excel introduction course is designed to accommodate complete beginners to Microsoft Excel.

Prerequisites:

A basic understanding of the windows environment.
A basic level of numeracy and literacy is required.

Book a course now by calling 0845 686 2888 or complete the online enquiries form

Course outline:

Getting Started

Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating
workbooks
Closing workbooks

Entering and Editing data

Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks

Modifying a Worksheet

Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges

Using Functions

Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX
Formatting Worksheets

Formatting text

Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Printing

Preparing to print
Page Setup options
Printing worksheets

Creating Charts

Chart basics
Modifying charts
Printing charts

List Management

Working with lists
Sorting and filtering lists
Advanced filtering

Using Templates

Built-in templates
Creating and managing templates

download course outline