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 want to gain a qualification and develop the key digital skills needed in the modern workplace, but don't feel quite ready? This short course will prepare you for the level 2 Award in Digital Skills. You will focus on using Word, PowerPoint and Excel to produce attractive documents and presentations and analyse data. These skills will ensure you are equipped for most jobs including those requiring extensive administration as well as ready to achieve your level 2 qualification.



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.

SharePoint is an increasingly common collaboration tool across workplaces, vital for keeping staff informed as well as enabling them to work together across projects. On this course, you will focus on the purpose of SharePoint, when to use it and how it fits into your business communications. You will learn how to create a Team Site, lay out the site effectively, manage your files within the Document Library, work on and share your files, plus customise your site effectively. This course will prioritise what you use SharePoint for so you can situate its functions within work-based tasks and fully grasp why you are using it.



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

Knowing how to handle large amounts of data, analyse it effectively and then present the findings are essential workplace skills. A recent study found 88% of employers want employees with data analysis skills. This intermediate Excel course will help you develop these skills by focusing on common workplace tasks and problems that require some of the more complex Excel functions. You will focus on how to handle large amounts of data and convert it into usable, valuable information. You will develop your skills so you can work with different formulae and functions to create for example automated budgets that take into account variable conditions. You will learn how to link data across spreadsheets and also calculate and present trends. You will work with pivot tables and learn why you use them. By the end of the course you will be confident you have the skills and insight to handle, analyse and present data for a range of circumstances.



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.

Learn how to create effective Excel tables and to chart your data on this short course.



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 wanting to complete the Level 3 Certificate in IT User Skills (ICDL Advanced)? If so, it is an important commitment. You are strongly advised to complete this short course to get you ready for the qualification and to make sure Level 3 is the right one for you. This course will ensure you make the most of your ICDL Level 3 course and have the skills to achieve the qualification once you start.



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.

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.

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.

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.

Data visualization in Excel is an essential skill, used by business, researchers, statisticians, journalists and many more to make information interesting and accessible. On this course you will focus on the key ways of presenting and interpreting data so you can describe patterns, trends and relationships as well find anomalies and inconsistencies. You will work on when, why and how to use the different visualisations including bar charts, line graphs, scatter plots, pie charts and tables. You will also examine different ways of formatting the data. By the end of the course you can be confident you can present and visualise data in a way that enhances what you want to say and engages others.



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.

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.