What is the course about?
You will learn the basics of Excel 2016 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.
This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
We will contact you with joining instructions before your course starts.
What will we cover?
• recognising the key features of the Excel window
• Entering data and text
• Enhancing the appearance of data by changing font, colour, size and style.
• using basic formulae to perform calculations such as sum, average, count, min and max
• Creating charts, graphs and enhancing their appearance.
What will I achieve?
By the end of this course you should be able to...
• describe the key feature of an excel spreadsheet
• enter data and text into worksheets
• enhance the appearance of the data by changing font, colour, size and style
• perform calculations in Excel using formulae and functions – such as sum, average, count, min and max
• convert numerical data into charts/graphs and make changes to them.
• create your own 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?
This will be a practical hands-on course.You have your own computer and you will be encouraged to practise as much as possible. An interactive whiteboard will help make demonstrations easy to understand. It will be a relaxed learning environment and step by step learning will help you become more skilled. You will have lots of opportunities to ask questions and address areas you need help in.
Are there any other costs? Is there anything I need to bring?
There are no additional costs attached to this course.
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. If you want to become fully confident in a range of digital skills, we recommend our Complete Course for Beginners series including:
a) Becoming confident on your computer
b) Becoming confident on the Internet: setting up, searching, security, safety
c) Becoming confident on Facebook, Twitter and Instagram: for complete beginners
d) Becoming confident in file management on your PC
e) Becoming confident with mobile data: managing and syncing your files across your laptop, smartphone and tablet
f) Becoming confident on the cloud: a new way of sharing and collaborating
Other follow-on courses include:
Excel 2016: essentials.
Excel 2016 for the workplace (intermediate)
Introduction to Word 2016
Word 2016 for the workplace (intermediate)
Introdution to PowerPoint 2016
Digital Skills to find a better job
IT skills for the office: an introduction
There are also courses with a qualification including: Essential Digital Skills for Work Level 1, ECDL Level 1 and ECDL Level 2. You will need to complete an assessment before doing these courses to make sure you are in the right class. You can also call our administrator on 0207 492 2511 / 2726 or email: firstname.lastname@example.org to arrange an assessment with one of our course advisors.