Technology, Science & Business Courses in London and Online

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 advanced features of Excel: linking, advanced sorting, filtering, formulae associated with logical, statistical, financial and mathematical operations, scenarios, data validation and audit spreadsheet, pivot tables and macros to create and work with complex spreadsheets.



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 troubleshoot and solve common computer hardware problems. Discover what is inside a computer, how it works and how to upgrade computer components.

Learn advanced features of Access databases to manage and analyse large amounts of data. Create a relational database using advanced table creation features and complex relationships between tables, data validation, advanced form design, sub-forms, multiple queries for data analysis, advanced reports, macros and switchboard. Knowledge required: Access essentials course or equivalent knowledge and experience.



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