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.
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. You will need to bring a USB flash drive, your own pens to make your notes.
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 with emails and internet communication
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: 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. Call 020 492 2511 or email firstname.lastname@example.org to make an appointment.Your tutor will also advise you on the best course.