Microsoft Office

Excel & Office 365 - Courses Online & In London

Learn how to use Microsoft Office software whether you have Office 365 or an earlier version of Microsoft Office. Our courses include beginner, intermediate, and advanced classes that cover many of the powerful features in Excel, Word, PowerPoint and Outlook.

You will learn directly from our highly qualified tutors with a wealth of real-world experience. They have designed our interactive courses to help you reach your goals, whether personal or professional.

Having advanced MS Office skills is invaluable to the modern worker. We will teach you how to use key features of Microsoft Office so that you can analyse data with Excel, create captivating presentations with Powerpoint, and manage your email with Outlook. Whatever you want to learn, we have a course to suit you, no matter your role or industry.

Learning on our Microsoft Office courses is flexible. Classes are either live online or in class, on weekdays, evenings and weekends so you can choose a time that suits you. For more information about our tutor-led interactive online courses please see our guide to online learning.

Our courses are FREE to most learners if you earn less than £21,157.50 a year, or you are on JSA/ESA (WRAG). Browse our Microsoft Office courses below and enrol today!

Some of our courses take place in the classroom — learn more about Staying COVID-19 secure at City Lit.

Items 1-15 of 23

Page
per page
Set Descending Direction
  1. Excel: tables and charts
    Evening, ONLINE
    Course start date:  Wed 12 Jan 2022

    Location on this date:  Online

    Learn essential skills in how to create effective tables in Excel, the benefit of formatting as table and to chart your data on this short course.



    This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £39.00 Senior fee £31.00 Concession £20.00
  2. Digital skills for the workplace: using Excel (foundation)
    Evening
    Course start date:  Wed 12 Jan 2022 (and 1 other date)

    Location on this date:  KS - Keeley Street

    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 receive other state benefits (including Universal Credit). For more information click here



    This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
    Full fee £179.00 Senior fee £143.00 Concession £90.00
  3. Excel: advanced
    Course start date:  Thu 13 Jan 2022 (and 5 other dates)

    Location on this date:  Online (other locations are available)

    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 will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £189.00 Senior fee £151.00 Concession £95.00
    Rating:
    98% of 100
  4. Becoming confident on Word 365
    Weekend
    Course start date:  Sat 15 Jan 2022 (and 1 other date)

    Location on this date:  KS - Keeley Street

    Are you new to Word and word processing? Do you want to learn how to create and organise letters and short documents? Then this course is ideal for you. Learn all of the basic functions of creating documents: adding, copying, moving and formatting text, practise inserting pictures and creating tables, Spelling and grammar checking, changing the page layout and printing different documents accurately. All you need is enthusiasm, and confidence using a mouse and basic keyboard functions.



    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 receive other state benefits (including Universal Credit). For more information click here



    This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
    Full fee £89.00 Senior fee £71.00 Concession £45.00
  5. Pivot tables: introduction
    Evening, ONLINE
    Course start date:  Tue 18 Jan 2022

    Location on this date:  Online

    Learn how to apply one of Excel’s most powerful features, Pivot Tables, to a wide range of data.



    This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £49.00 Senior fee £39.00 Concession £25.00
  6. Becoming confident on Outlook 365
    Course start date:  Wed 19 Jan 2022

    Location on this date:  KS - Keeley Street

    Are you new to Outlook? Have you started using it at work but needing to know more about it? Working with emails and tasks is an essential feature of almost any job and it can be easy to become overwhelmed by messages and information. This course will enable you to use the key features of Outlook including the do's and don'ts of sending and receiving emails, sending and receiving emails with attachments, safe downloading of attachments, adding signatures, creating folders to manage your emails, organising and using your calendar to keep on top of appointments, setting up reminders and creating task lists, with staying within the digitally safe and secure and within GDPR.



    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 receive other state benefits (including Universal Credit). For more information click here



    This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
    Full fee £99.00 Senior fee £79.00 Concession £50.00
  7. Workplace skills: how to collaborate, coordinate and build relationships through the Cloud using One Drive and SharePoint (intermediate)
    ONLINE, Weekend
    Course start date:  Sun 23 Jan 2022 (and 1 other date)

    Location on this date:  Online

    Collaborating skills within the workplace are more in demand than ever. Being able to coordinate work and build relationships within and across teams is essential to being efficient and coping with complexity. On this course you will develop and practise these skills not only by learning more about the features of One Drive and SharePoint but also identifying why, when and how you should use them. You will learn about the differences between One Drive and SharePoint, what they are used for, when to use one rather than the other and how to combine their use. You will focus on how to share and collaborate on documents while keeping track of files, who has worked on what when, and how to sync your files across different devices. You will also look at how to combine your work on SharePoint and One Drive with Teams and Outlook.



    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 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.
    Full fee £119.00 Senior fee £95.00 Concession £60.00
  8. Excel 365's Dynamic Array Functions
    ONLINE
    Course start date:  Mon 31 Jan 2022

    Location on this date:  Online

    Learn how to use Excel 365's Dynamic Array Functions - powerful techniques that work on an array (series) of data in an Excel Workbook.



    Students should have a PC or laptop with Excel 365 App installed, please note that an early version of Excel will not be compatible for the course to complete the tasks, you can have a pen and paper to take notes. Please note, certain commands do not work in Office 365 online and thus the installed Microsoft Office is required. Should you wish to install the desktop version of Office 365 on your computer, you can request a temporary licence from us by emailing at computing@citylit.ac.uk at least 3 days before the start of the course.



    This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £39.00 Senior fee £31.00 Concession £20.00
  9. Digital skills for the workplace: using Word (intermediate)
    Course start date:  Thu 3 Feb 2022 (and 1 other date)

    Location on this date:  KS - Keeley Street

    Are you using Microsoft Word in an office or in administrative job? Or are you preparing for this line of work? This course will develop all the skills you need to perform your workplace Word work to a high level. Become confident in creating long, consistently formatted, well-presented documents such as reports and performing the tasks most commonly associated with Word in the office. Such tasks will include developing your use of Styles, modifying pictures in documents, using templates, controlling text flow and using mail merge. This a course for those who already have some experience of using Word. For beginners, please see our Becoming confident in Word 365 course.



    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 receive other state benefits (including Universal Credit). For more information click here



    This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
    Full fee £159.00 Senior fee £127.00 Concession £80.00
  10. Pivot tables: intermediate
    Evening, ONLINE
    Course start date:  Wed 9 Feb 2022

    Location on this date:  Online

    Have you always wanted to enhance your understanding of Excel pivot tables in order to gain new insights on your



    data? Learn how in this short course.



    This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £49.00 Senior fee £39.00 Concession £25.00
  11. Digital Skills for the workplace: using Excel (intermediate)
    ONLINE
    Course start date:  Thu 10 Feb 2022

    Location on this date:  Online

    Do you want to learn some of Excel more sophisticated functions? Are you an administrator or manager who needs to use it for more complex tasks? With realistic workplace assignments, you will focus on how to use Excel as a tool to complete key work-based tasks such as presenting data in an easily readable form and using functions such as average, minimum and maximum to make quick and accurate calculations. You will work on how to use Excel to solve problems based on certain conditions such as if interests rates go up by 1% what the effect will be on borrowing. You will also work on how to manipulate and work with more complex data through advanced formatting, effective filtering and basic pivot tables as well working across worksheets and other MS programs.



    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 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.
    Full fee £179.00 Senior fee £143.00 Concession £90.00
  12. Excel for financial modelling
    Weekend
    Course start date:  Sun 13 Feb 2022

    Location on this date:  KS - Keeley Street

    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 takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
    Full fee £229.00 Senior fee £183.00 Concession £115.00
  13. Workplace skills: how to collaborate, coordinate and build relationships with Microsoft Teams (intermediate)
    Evening, ONLINE
    Course start date:  Tue 1 Mar 2022 (and 1 other date)

    Location on this date:  Online

    Collaborating skills within the workplace are more in demand than ever. Being able to coordinate work and build relationships within and across your workplace is essential to your being efficient and coping with complexity. This course you will help you develop and practise these skills by learning in detail how to use Microsoft Teams as a coordinating and collaborating tool. You will learn not only about its features but also why, when and how you should use them: what problems does Teams enable you to solve. 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 files in Teams, how Teams relates to SharePoint and One Drive, how to keep track of collaboration, and how to sync your files across different devices. You will also focus on how to use the calendar efficiently, 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 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.
    Full fee £119.00 Senior fee £95.00 Concession £60.00
  14. Excel: applying formulae and functions
    Evening, ONLINE
    Course start date:  Thu 3 Mar 2022

    Location on this date:  Online

    Move beyond basic arithmetic in Excel and learn to use the power of formulae and functions to save time and to extract new information from your data.



    This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £39.00 Senior fee £31.00 Concession £20.00
  15. Excel: sorting, filtering and subtotalling
    ONLINE
    Course start date:  Wed 9 Mar 2022

    Location on this date:  Online

    Build on your basic knowledge of Excel with the skills to allow you to select and organise data by sorting, filtering and subtotalling.



    This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
    Full fee £39.00 Senior fee £31.00 Concession £20.00

Items 1-15 of 23

Page
per page
Set Descending Direction

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 to your waiting list