Digital skills for the workplace: using Excel (foundation)

Course Dates: 20/09/22 - 18/10/22
Time: 10:00 - 13:00
Location: Keeley Street
Do you need to learn how to use Excel for the office or to keep track of your finances? Do you want to be able to handle, present data and make calculations inside and outside of work? This course is perfect for anyone who needs a good foundation on the basics of Microsoft's popular spreadsheet program. On this course, you will learn how to enter and present data and make it visually appealing, readable and usable through changes of font, style, use of tables and other formatting features. You will practise making calculations, using functions and formulae, modifying links between worksheets, as well as creating basic charts and graphs - a great way of visualizing data!
This course is FREE if a) you are on a Low Wage or b) you are either on Jobseekers' Allowance (JSA) or Employment & Support Allowance(ESA) or c) you want to get a job or progress into a better job and you receive other state benefits (including Universal Credit). For more information click here
Download
Book your place
In stock
SKU
193157
Full fee £179.00 Senior fee £143.00 Concession £90.00

Course Code: CEX12

Available start dates 

Tue, day, 20 Sep - 18 Oct '22

Duration: 5 sessions (over 5 weeks)

Or call to enrol:020 7831 7831

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

What is the course about?

This course will give you the skills and confidence in Excel to create a well-presented spreadsheet. You will learn important terms, concepts and functions of the Excel spreadsheets and be astonished at how powerful and useful Excel is. We will focus on how to create spreadsheets which are formatted with the right fonts, colour, text size and style including headers and footers. You will learn about entering data and using formulae and functions to make calculations. You will practise creating charts and graphs and enhancing their appearance so that data can be presented in an easy to read way. We will also practise using and creating templates, printing to maintain formatting and managing your files.

What will we cover?

• identifying key features of a worksheet to create attractive and accurate documents such as budget sheets
• how to enter and present data including making it more readable by changing its font, colour, size and style.
• how to present and change tables such as entering and deleting a column, row or sheet.
• adding and deleting headers and footers.
•how to make calculations by using common formulae and key functions such as Sum, Average, Maximum and Count.
• how to present data by creating charts, graphs and enhancing their appearance.
• using and creating templates.
• print preparation
• managing your files and maintaining security.

What will I achieve?
By the end of this course you should be able to...

•use all the main essential features of Excel to create attractive and accurate documents such as budget sheets
• identify the key features of an Excel window
• create, open and save files
•enter and present data including making it more readable by changing its font, colour, size and style.
• present and change tables such as entering and deleting a column, row or sheet.
• create well-presented and readable spreadsheets by using appropriate formatting including use of headers and footers, different page layouts and orientation
•make calculations by using common formulae and key functions such as Sum, Average, Maximum and Count.
• convert and present numerical data into visually appealing forms by creating charts, graphs and enhancing their appearance.
• use and creating templates.
• using spell check and grammar check so your documents are accurate
• print documents including headers and footers
• organise your files so they are easy to find and secure.

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

This is a course suitable for post-beginners. You need some familiarity with what you use Excel for. If you are a complete beginner, do our Becoming Confident on Excel course.

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

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. You will work on your own and with other students on different tasks so you are always practising important in-demand life and work skills such as problem-solving, decision-making, prioritising, negotiating, collaborating and independence. You will learn in a step by step manner so you can complete challenging tasks in enjoyable and relaxing ways. Your tutor will also work with you individually so you know how to improve and how to work in a way that improves your learning. You will need to do work outside the classroom and use Google Classroom to help you.

Are there any other costs? Is there anything I need to bring?

You will need a pen, A4 paper and a folder to keep your work in. Your tutor will provide handouts and a code for Google classroom so you can communicate with classmates and access materials, videos online.

When I've finished, what course can I do next?

There are many courses you can do before, at the same time or after this course. These include:
• Becoming confident in digital skills: Word, Excel, PowerPoint and Outlook (beginner)
• Becoming confident on Word / Outlook (beginner)
• Becoming confident in file management and Windows 10 on your PC (beginners)
• Essential digital skills for the workplace: Word, Excel and PowerPoint (foundation-level 1)
• Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for the workplace: how to present, organise and communicate with Word (intermediate)
• Digital skills for the workplace: creating newsletters, reports and tables with Word (intermediate)
• Business administration: how to be an administrator for beginners (with digital skills)
• Business Administration: Word, Excel, PowerPoint and Access (intermediate-level 2)
• Essential digital skills for work (Level 1)
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (intermediate-level 2)

We also have maths, English, employability and communication skills courses. Ask your tutor or contact universal.skills@citylit.ac.uk / 020 7492 2511 for more detail. These include:
• Business administration: maths for administrators (level 1-2)
• Becoming data literate: how to understand the data all around you (level 1-2)
• Business Administration (with digital skills): English communication skills for administrators and office workers (level 1-2)
• Professional communication skills: effective verbal communication in the workplace (level 2)
• Professional communication skills: effective written communication in the workplace (level 2)






• Becoming confident on PowerPoint 365 (beginner)
• Becoming confident on Excel 365 (beginner)


There also many English, maths and digital skills courses you can do. Ask your tutor or contact universal.skills@citylit.ac.uk / 020 7492 2511 for more details.

We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.