Filters
- Excel: advancedCourse start date: Wed 22 May 2024 (and 5 other dates)
Location on this date: Hybrid (choose either online or in-person)
Tutors: Aurica JalbaLearn 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.Full fee £199.00 Senior fee £159.00 Concession £129.00 - Digital skills for business: how to present and communicate data integrating Word, PowerPoint and Excel - a project-based approach (advanced)Course start date: Sun 2 Jun 2024
Location on this date: Online
Are you already an experienced and skilful user of Word, Excel and PowerPoint? Are you working as a lead administrator? Do you want to extend your skills so you can integrate these three programs to produce high quality and sophisticated documents? This course will help you combine your Microsoft 365 skills by working on business projects that enable you to analyse data at a high level and also present your findings in a clear and dynamic way. You will learn how to link and embed data across the programs, how to integrate Excel data and charts with PowerPoint and Word, how, how to use Word to create a new PowerPoint presentation and how to use Word to create customizable PowerPoint speaker notes and handouts.
This course is FREE if you are employed and on a low wage or you are claiming benefits. 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.Full fee £159.00 Senior fee £127.00 Concession £80.00 - Excel: tables and chartsCourse start date: Thu 13 Jun 2024 (and 1 other date)
Location on this date: Hybrid (choose either online or in-person)
Tutors: Aurica JalbaLearn 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.Full fee £49.00 Senior fee £39.00 Concession £32.00 - Digital skills for business: how to use SharePoint for collaboration (intermediate)Course start date: Mon 17 Jun 2024
Location on this date: Online
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 you are employed and on a low wage or you are claiming benefits. 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.Full fee £119.00 Senior fee £95.00 Concession £60.00 - Excel: analysing your spreadsheet with pivot tablesCourse start date: Thu 20 Jun 2024
Location on this date: Hybrid (choose either online or in-person)
Tutors: Aurica JalbaLearn 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.
This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.Full fee £49.00 Senior fee £39.00 Concession £32.00 - Excel: expertCourse start date: Wed 26 Jun 2024 (and 1 other date)
Location on this date: Hybrid (choose either online or in-person)
Tutors: Abbott KatzThis course is ideal if you want to master you Excel skills for data analysis. You will learn how to create dialogue boxes,combo boxes,spinners,drop down lists,user forms and macros.You should have attended our 'Excel: advanced' course, or have equivalent knowledge or experience.
This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.Full fee £199.00 Senior fee £159.00 Concession £129.00 - Excel: applying formulae and functionsCourse start date: Mon 8 Jul 2024
Location on this date: Hybrid (choose either online or in-person)
Tutors: Aurica JalbaMove beyond basic arithmetic in Excel and learn to use the power of formulas and functions to save time and extract new information from your data.
This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.Full fee £49.00 Senior fee £39.00 Concession £32.00 - Pivot Tables: the Basics and BeyondCourse start date: Tue 26 Nov 2024
Location on this date: Hybrid (choose either online or in-person)
Tutors: Abbott KatzIn 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.Full fee £129.00 Senior fee £103.00 Concession £84.00 - Digital skills for business: presenting and managing professional-looking documents with Word and Excel - from reports to newsletters (intermediate)Course start date: Wed 17 Apr 2024
Location on this date: Online
Do you need to present well-organised complex documents at work that are easy to read and follow? Are you responsible for compiling reports or other long documents? On this course, you will develop all the skills you need to use Microsoft Word to create data rich documents which meet professional standards. You will learn time-saving techniques and become skilled in using outlines, templates, consistent formatting, headers, footers, tables, images as well as controlling text flow. You will also work on integrating Excel data into your Word document as well as using mail merge to distribute your documents. These are vital skills across a range of jobs that will not only save you time but also reduce the frustrations often associated with use of Word.
This course is FREE if you are employed and on a low wage or you are claiming benefits. 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.Full fee £149.00 Senior fee £119.00 Concession £75.00
Can't see a course you want?
Add this category to your waiting list to set up alerts and we will update you when new courses are released online.
Add me to waiting list