Spreadsheets (Excel) Level 3 Course
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…
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
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.