Excel & Microsoft 365 Courses

Learn how to create and edit pivot tables to analyse large lists of data with multiple views and calculated fields using drag and drop. You should have a good understanding of Excel.

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 you are employed and on a low wage or you are claiming benefits. For more information Click here

Would you like to gain the most essential digital skills needed for today's workplace? Do you need to develop the foundational digital skills for today's job market? Then this is the course for you. Suitable for those who already have some knowledge of Microsoft Office programs, this course will give you the confidence to use Word, Excel and PowerPoint within the workplace so you can create documents, spreadsheets and presentations. You will learn the key skills needed to word process, handle data and produce clear digital. 53% of UK employees do not have the digital skills needed for work. You don't need to be one of them.

This course is FREE if you are employed and on a low wage or you are claiming benefits. For more information Click here

Does the amount of data coming into your inbox and folders threaten to overwhelm you? Do you need to develop a system for managing information, tasks and meetings? MS Outlook and OneNote can be part of this system but for many people they feel part of the problem rather than the solution. This course will enable them to work for you not the other way round. You will focus on how to think about problems, solve them and what you are trying to achieve. You will work on developing an email routine that allows you to concentrate on tasks at hand and not be distracted by incoming messages. You will focus on how to create a folder system on Outlook and process using quick steps, rules, categories and colour-coding so you can keep a trace of emails, tasks and appointments. You will learn simple and efficient ways to schedule your work and use notes and task and the flagging system to keep track of your priorities. In addition you will focus on how you can integrate OneNote and Outlook to save you time.

This course is FREE if you are employed and on a low wage or you are claiming benefits. For more information Click here

Do tables in Word seem to move of their own accord? Do you need to produce newsletters for work or for volunteer groups but are frustrated by shifting text and images? Are you unsure how to maintain consistent formatting across a report? If so, then this is the course for you. On this course you will learn how to produce a newsletter, insert tables, and create simple reports while maintaining consistent formatting and ensuring the layout and presentation is effective and impacting. You will focus on how to produce attractive documents fit for purpose in an efficient and timely manner, vital skills both inside and outside work.

This course is FREE if you are employed and on a low wage or you are claiming benefits. For more information Click here