Digital Skills & Other Computer Skills

Learn advanced features of Excel: linking, advanced sorting, filtering, advanced formulae, scenarios, data validation and audit spreadsheet, pivot tables and macros to create and work with complex spreadsheets. This course is suitable for anyone who is involved in Data Analysis using Excel.



This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.

Do you know the basics of emailing and internet use? Are you ready to work with Word, Excel, PowerPoint and Outlook? Then this course is for you. You will start learning how to word process, use spreadsheets and create presentations, vital skills in today’s world inside and outside the workplace. You will also learn the most essential aspects of Outlook so you can send and receive emails and organise them. You will develop these skills by working on key tasks such as letter-writing, budgeting, presenting and contacting work colleagues. By the end of the course you will be able to create well-presented short texts such as letters, design simple budgets and tables, produce effective and attractive presentations and email them to friends and work colleagues. Start your journey today!



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

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 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

Collaborating within the workplace is more important than ever. In almost all jobs you need to coordinate work, build relationships and cope with complexity this entails. Microsoft Teams is an essential digital tool to enable this. This course you will help you develop your collaborating skills by learning how to use Teams' key features, and why, when and how you should use them. You will practise how to set up Teams and channels and what you use these for. You will learn how to use files in Teams, how to collaborate and co-author them, how you can keep track of collaborations and sync your files across different devices You will also focus on how Teams relates to SharePoint and OneDrive, and how manage your files efficiently. You will also focus on how to use the calendar effectively, how to conduct meetings and use the some key meeting features. You will also look at how to integrate other apps into Teams such as planner to help you coordinate work and create efficient working relationships. Teams is a fantastic means of collaboration but maintaining control across your working relationships can seem daunting. By the end of this course you will be clear and confident in how to coordinate these relationships so you are productive and efficient.



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



This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.

Learn how to troubleshoot and solve common computer hardware problems. Discover what is inside a computer, how it works and how to upgrade computer components.

Financial modelling refers to the development of mathematical tools to simulate business scenarios as an aid to decision-making. Knowing lots of functions helps, but it is the application of these skills whilst also understanding the financial concepts that turns a glorified calculator into a valuable financial model.



This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.

Are you new to computers and the Internet? Do you need to increase your confidence with digital skills? This course will ensure you have a solid foundation in using computers and being online. You will learn the essential features of creating, saving, storing different types of files and documents, including photos and letters in Word. You will develop your internet skills to find information quickly and efficiently, and learn how to transfer this information to different documents and people. You will also learn the basics of how of how to use Zoom to host meetings and communicate effectively online. Finally, you do all of this while learning how to remain safe online and to keep your files secure.



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

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 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



This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.

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 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

Are you already a competent administrator ready to develop more advanced digital skills so you can become more efficient and productive and advance in your career? This course will help you learn how to use more complex functions in Excel so you can handle and analyse data precisely as well as provide bigger picture analyses. You will also focus on how to use the more sophisticated elements of PowerPoint to produce high quality presentations which meet the demands of the modern workplace. In addition, you will become familiar with key aspects of financial software so you can handle and process sales and purchases. By the end of the course you will have the skills to set you apart from other administrators and become an invaluable member of any team.



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



This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.

Do you want to gain a qualification which will develop the most essential general digital skills needed in the modern workplace and prepare you for the most important office tasks? On this course, you will develop key word-processing, presentation and data analysis skills so you are equipped for most jobs particularly those requiring extensive administration. You will work on a range of word-processing skills so you can create well-presented and informative documents. You will develop your skills on PowerPoint so you can create well-pitched, effective presentations for a variety of audiences. And you will improve your data manipulation and handling skills by practising key advanced features on Excel including use of formulae and pivot tables as well as learning the basic principles of the Access database. You will achieve a Level 2 qualification by completing units in word-processing and presentation skills.



You need to do a pre-course assessment. Contact universal.skills@citylit.ac.uk / 020 8078 0489 for a face-to-face assessment or click the Start Assessment button on this page. Log on with your email address (not name).



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



This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.

In this course you will learn the essentials of pivot table construction and all additional features that will enhance the user’s pivot table competence.



This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.

Do you have to give presentations at work, for business, to future clients that need to be professional and impacting? Do you want to know how to create a PowerPoint presentation that tells a story and engages the audience? On this course, you will learn how to structure a presentation using data effectively in which the PowerPoint enhances the message. You will focus on both your communication and digital skills so you develop your professional presence and how you relate to the listeners and you learn how to create impacting slides to create your storyline, present data and other information appropriate to your audience and purpose.



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



This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.

Does your smartphone confuse you? Are you unsure how to make the most of its many features? Understanding and navigating your way round a smartphone is now as important as being able to use a regular computer. This short course will help you understand your Android smartphone, troubleshoot problems and use some of the most popular apps. By the end of the course you will be confident you can use or find out how to use the key features of your phone.



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