Digital skills for the workplace: using Excel (foundation)

Course Dates: 12/01/22 - 09/02/22
Time: 18:00 - 21:00
Location: KS - 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 receive other state benefits (including Universal Credit). For more information click here
This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
Download
Book your place
In stock
SKU
181679
Full fee £179.00 Senior fee £143.00 Concession £90.00

Course Code: CEX02

Please choose a course date 

Wed, eve, 12 Jan - 09 Feb '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 are likely to have used Excel a little bit and have some familiarity with what you use Excel for. If you are a complete beginner, it is best to 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, some lined 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 etc. 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:
• Digital Skills for the workplace: using Excel (intermediate)
• Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for the workplace: using Word (intermediate)
• Digital skills for the workplace: using Word (advanced)
• Digital Skills for the virtual and face-to-face office (intermediate)
• How to be a skilled administrator in the virtual and face-to-face office: the essentials
• How to be administrator in the virtual and face-to-face office: how to be organised, efficient, precise and service-focused
• How to be an administrator: the online paperless office
• Touch typing and keyboard skills

You can also do courses with a qualification
• Essential digital skills for work (level 1)
• Level 2 Certificate in IT User Skills (ECDL Extra)

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.