Spreadsheets (Excel) Level 3 Course

Product type
Level

Spreadsheets (Excel) Level 3 Course

UK Open College
Logo UK Open College

Need more information? Get more details on the site of the provider.

Description

This home study level 3 course will show students how to create spreadsheets using Excel software. An ideal course to follow on from our excel level 2 course or for those with previous knowledge. 

Covering elements at an advanced level from statistical functions and linking data to encryption and lots more. Excel, just like maths and English is commonly seen as a basic requirement for numerous job roles advertised by employers. So don't get left behind!

This course comes crammed with exercises and data allowing you to practice as you work your way through your training manual. Students can complete at their own leisure to a maximum of six months 

Level 3 Syllabus

Before You Start

Text t…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

This home study level 3 course will show students how to create spreadsheets using Excel software. An ideal course to follow on from our excel level 2 course or for those with previous knowledge. 

Covering elements at an advanced level from statistical functions and linking data to encryption and lots more. Excel, just like maths and English is commonly seen as a basic requirement for numerous job roles advertised by employers. So don't get left behind!

This course comes crammed with exercises and data allowing you to practice as you work your way through your training manual. Students can complete at their own leisure to a maximum of six months 

Level 3 Syllabus

Before You Start

Text to Columns

Paste Special Data

Validation

Subtotals and Grouping

Consolidate Data

What-if Analysis – Data Tables

What-if Analysis – Scenarios

What-if Analysis – Goal Seek

Text Functions

Lookup

Functions

Maths and Trig Functions

Statistical Functions

Database Functions

Formula Auditing and Error Tracing

Linking Data Hyperlinks

Getting External Data

Pivot Tables and Pivot Charts

Protecting and Sharing

Worksheets and Workbooks

Workbook Properties and Inspection

Encrypting and Finalising Workbooks

An Introduction to Macros Illustrations,

Text Boxes and WordArt

Custom Number Formats

Custom Lists

Working with Templates

Tracking Changes

Compare and Merge Workbooks

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.