Becoming confident on Excel 365

Course Dates: 07/12/21 - 14/12/21
Time: 10:00 - 17:30
Location: KS - Keeley Street
Are you new to Excel? Have you used Excel a little but lack confidence you are doing the right thing? Are you unsure about what you use Excel for? On this course, you will learn the key basic functions of Excel so you can begin your journey in how to handle, analyse and present data. You will learn the main functions of Excel and associated terminology. You will focus on how to create simple worksheets, enter data, present it in a logical and functioning way with formatting that makes it easy to read. You will work on using Excel in place of your calculator to make basic calculations and you will practise turning this data into simple charts and graphs. By the end of this course, you will confident enough to create your own weekly budget calculator. To do this course you'll need to be able to use a mouse, keyboard and basic computer functions.
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) and your monthly take home pay is less than £343. 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
180784
Full fee £129.00 Senior fee £103.00 Concession £65.00

Course Code: CEXI01

Please choose a course date 

Tue, day, 07 Dec - 14 Dec '21

Duration: 2 sessions (over 2 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?

You will learn the basics of Excel 365 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:
• Digital skills for the workplace: using Excel (foundation)
• Digital Skills for the workplace: using Excel (intermediate)
• Becoming confident in digital security: how to protect your data and privacy on your PC, Internet and smartphone
• Becoming confident in file management on your PC
• Becoming confident on Office 365 and its most important apps: an introduction
• Becoming confident on PowerPoint 365
• Becoming confident on the cloud: a new way of sharing and collaborating (Google or One Drive)
• Becoming confident on Word 365
• Becoming confident with digital skills: on your computer and online
• Becoming confident with mobile data: managing and syncing your files across your laptop, smartphone and tablet
• Becoming confident with online communication: Zoom
• Making sense of Windows 10
• Touch typing and keyboard skills

We have a number of courses with qualifications including:
Essential Digital Skills for Work Level 1
Before this course, you need to do a pre-course assessment.

There also many English, maths and office 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.