Becoming confident on Excel 365 (beginner)
Time: 10:00 - 17:30
Location: Keeley Street
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
Course Code: CEXI03
Duration: 2 sessions (over 2 weeks)
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?
You will learn the basics of Excel so you can create and design your own spreadsheets – for example to make your own monthly budgets. You will learn how to input and manage data, perform calculations and create charts and graphs. You will also learn the basics of formatting to enhance the visual impact of your spreadsheets. The course includes a general overview of the concepts, terms and functions of spreadsheets.
What will we cover?
• recognising the key features of the Excel window and what you use Excel for
• entering data and text
•presenting data effectively in table form and changing font, colour, size and style
• performing calculations using basic formulae such as sum, average, count, min and max
•presenting data effectively by converting numerical data into visually appealing charts and graphs
•creating a weekly budget calculator.
What will I achieve?
By the end of this course you should be able to...
• recognise the key features of the Excel window and what you use Excel for
• enter data and text accurately into a cells
•present data effectively in table form and change font, colour, size and style
• perform calculations using basic formulae such as sum, average, count, min and max
•present data effectively by converting numerical data into visually appealing charts and graphs
•create a weekly budget calculator.
What level is the course and do I need any particular skills?
Though this is an introductory course, you should be able to use a keyboard and mouse and understand the principles of file management. You should be able to follow spoken and written instructions and add, subtract, multiply and divide.
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 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 365 (beginner)
• Becoming confident on Outlook 365 (beginner)
• Becoming confident on PowerPoint 365 (beginner)
• Digital skills for the workplace: using Excel (foundation)
• 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)
• Business administration: how to be an administrator for beginners (with digital skills)
• Business Administration: Word, Excel, PowerPoint and Access (intermediate-level 2)
• Touch typing and keyboard skills
We have a number of courses with qualifications including:
• Essential digital skills for work (Level 1)
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (intermediate-level 2)
Before this course, you need to do a pre-course assessment.
There also many maths, English, employability and communication skills courses you can do. Ask your tutor or contact universal.skills@citylit.ac.uk / (telephone temporarily unavailable) for more detail. These include:
• Maths for life and work (foundation)
• Maths for life and work (level 1)
• Becoming confident in algebra: problem-solving with equations (level 1-2)
• Becoming confident in numbers: mental maths (level 1-2)
• Business administration: maths for administrators (level 1-2)
• Becoming data literate: how to understand the data all around you (level 1-2)
• Finance planning: taking back control - how to budget successfully
• Business Administration (with digital skills): English communication skills for administrators and office workers (level 1-2)
• Professional communication skills: reading, analysing, and comparing data and text (level 2).