Microsoft Office & Office 365

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. Becoming confident in digital skills: Word, Excel and PowerPoint
    Evening
    Course start date:  Mon 24 Jan 2022

    Location on this date:  KS - Keeley Street

    Do you know the basics of emailing and internet use? Are you ready to work with Word, Excel and PowerPoint? 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. By the end of the course you will be able to create well-presented short texts such as letters, design simple budgets and tables and produce effective and attractive presentations. 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 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
  2. Becoming confident on Word 365
    Weekend
    Course start date:  Sun 30 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
  3. Excel 365's Dynamic Array Functions
    ONLINE
    Course start date:  Mon 31 Jan 2022

    Location on this date:  Online

    Tutors:  Abbott Katz
    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
  4. 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
  5. Workplace skills: how to collaborate, coordinate and build relationships through the Cloud using One Drive and SharePoint (intermediate)
    ONLINE, Weekend
    Course start date:  Sun 6 Feb 2022

    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
  6. Excel: advanced
    Course start date:  Tue 8 Feb 2022 (and 4 other dates)

    Location on this date:  KS - Keeley Street (other locations are available)

    Tutors:  Aurica Jalba
    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 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 £189.00 Senior fee £151.00 Concession £95.00
    Rating:
    98% of 100
  7. Pivot tables: intermediate
    ONLINE
    Course start date:  Wed 9 Feb 2022

    Location on this date:  Online

    Tutors:  Abbott Katz
    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
  8. 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
  9. Excel for financial modelling
    Weekend
    Course start date:  Sun 13 Feb 2022

    Location on this date:  KS - Keeley Street

    Tutors:  Anis Mokadem
    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
  10. Essential digital skills for the workplace: Word, Excel and PowerPoint (foundation)
    Evening
    Course start date:  Mon 28 Feb 2022

    Location on this date:  KS - Keeley Street

    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 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
  11. 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
  12. Excel: applying formulae and functions
    ONLINE
    Course start date:  Thu 3 Mar 2022

    Location on this date:  Online

    Tutors:  Aurica Jalba
    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
  13. Excel: sorting, filtering and subtotalling
    ONLINE
    Course start date:  Wed 9 Mar 2022

    Location on this date:  Online

    Tutors:  Aurica Jalba
    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
  14. Digital Skills for the virtual and face-to-face office: how to work across and combine different MS Office programs (advanced)
    Evening, ONLINE
    Course start date:  Thu 10 Mar 2022

    Location on this date:  Online

    Are you already competent in the key uses of MS Office programs? Are you already confident in essential administration work? If so, the next step for you is how you can work across Word, Excel, Outlook and OneNote to ensure your office runs smoothly, efficiently and avoids duplications. On this course, you will work on how to combine Outlook and OneNote so you can organise files, emails and meetings effectively as well as share important information with colleagues. You will learn how to combine Word and Excel so you avoid duplications and can work with files from both programs simultaneously. You will also focus on how to link different Excel worksheets within and between different workbooks so you can handle and analyse data effectively.







    The virtual world has changed how we interact in both the workplace and our personal lives. Successful collaboration is an important skill for today's working professionals. There are a variety of programs and tools that can be used to achieve the ultimate goal: getting work done in virtual settings, while still maintaining clear communication with your colleagues.



    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
  15. Excel: tricks and tips for productivity
    Course start date:  Wed 16 Mar 2022

    Location on this date:  KS - Keeley Street

    Tutors:  Jill Rein
    Do you have some familiarity with Excel? Would you like to learn methods that will make your use of the software easier and more efficient? The focus of the day will be to look at different features of Excel as well as adjusting settings and other shortcuts to improve your experience and productivity.



    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

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