What level is the course and do I need any particular skills? 

 This is an intermediate level course and it is for those who have completed the Introduction to Microsoft Excel course or have some experience of using spreadsheets and want to further develop their skills 

This course is suitable if you already speak and write everyday English at L1. 

You will need to sit an initial assessment before enrolling on the course to check you current skills. 

What is the course about? 

On this course, you will extend your knowledge and experience of spreadsheets, working on more complex tasks with the help of your tutor. Improving your Excel skills will help you be more effective at work and in your day-to-day life. 

You will work on how to link different sets of data across worksheets. You will work on how to track and identify trends and present them effectively. You will also learn about pivot charts and what to use them for.  

Course content: 

What topics will we cover? 

• the importance of data analysis in the workplace  

• identifying key features of well-designed and well-presented data so it is easy to identify and read  

• planning and creating automated budget sheets involving profit, loss, total and subtotal expenditures using conditional formatting, functions and formulae 

• calculating trends and identifying the best ways of presenting this data  

• linking data across worksheets  

• summarising data using pivot tables  

• presenting data effectively using charts. 

Learning objectives 

 By the end of the course you should be able to:  

• identify the importance of data analysis in the workplace  

• identify key features of well-designed and well-presented data  

• plan and create automated budget sheets involving profit, loss, total and subtotal expenditures using conditional formatting, functions and formulae  

• calculate trends and present them effectively  

• link data across worksheets  

• summarise data using pivot tables  

• present data effectively using charts 

How will I be taught, and will there be any work outside the class?  

What kind of activities will I be doing? 

You will learn in a supportive and welcoming environment with an emphasis on your discovering how to do and complete tasks, with guidance from the tutor.  

There will be a mixture of class taught sessions, individual learning and small group work. The focus will be on developing your skills rather than covering topics you already know. 

You will have demonstrations and you will follow set exercises as practise to help you manipulate the data and explore the features that Excel has to offer.  

Your work will be continually assessed in class. This is a non-accredited course but a certificate of completion can be provided by the College on request. 

In addition to the classes you will be expected to do some homework to practise your skills 

Are there any other costs? Is there anything I will I need to bring? Where can I get this? What do we provide? 

Notepad and pen – you will need to take notes during the sessions and a folder to store hand-outs and completed exercises 

This course requires study/completion of homework, reflection and personal studies outside of class time, you must set time aside for these activities, at least 3 hours per week recommended.  

It is important that you have access to a computer connected to the Internet outside of class in order to complete your homework 

You will need the following programs installed on your device: 

• Internet Explorer or Google 

• Microsoft Excel  

What could I do next? 

Following successful completion of this course, you may choose to enrol onto the Essential Digital Skills Qualification Level 1 at Westway Trust or onto the Level 2 Certificate in Digital IT Skills at Morley College.