Low cost IT training in St Albans & Harpenden areas  

Book today: 01727 617359  or email courses@cfsta.org

© Copyright 2021 Computer Friendly

 Registered in England number 04398683                        Registered Charity number 1096433

Home Online Help What we do Timetables Courses News Hints & tips Get involved
Home

Computer Friendly

Further Excel

Further Excel

You will increase your confidence in using Microsoft Excel so that you can produce a wide range of spreadsheets, whether for personal or business purposes.

Course Objectives

The purpose of this course is to revise and reinforce the knowledge and experience you already have, and to introduce you to additional features of Microsoft Excel.  By the end of the course you should be able to produce and edit attractive, professional spreadsheets suitable for most occasions and uses.

You will revise:

You will learn about:

You will also sample the wide range of uses that spreadsheets can be used for.

A workbook is provided containing exercises to give hands-on experience and general information. This is yours to keep.

Prerequisites

You should have attended the Excel course or have a basic working knowledge of Microsoft Excel (i.e. the topics covered in the Excel course).

Course Structure

Five weeks x2 hours

Lesson 1   Time and Using $ sign and brackets in formulae

Lesson 2  Sorting and using more than one Worksheet

Lesson 3  Data validation and Conditionality

Lesson 4  Handling and avoiding mistakes

Lesson 5   Naming cells and Filtering