Microsoft Office & Office 365

Microsoft Excel & Office 365 Courses

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.

We offer a range of courses allowing you to choose between online and in-person learning. All our courses are live, interactive, and taught by expert tutors. No matter how you prefer to learn, you’ll receive the same great City Lit experience. See our guide to online learning for more information about accessing our live online courses.

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!

Items 1-15 of 22

Page
per page
Set Descending Direction
  1. Becoming confident on PowerPoint 365 (beginner)
    Last Few Places
    Course start date:  Thu 8 Dec 2022 (and 1 other date)

    Location on this date:  Keeley Street

    Do you want to learn how to create presentations? Are you completely new to PowerPoint? Can you use some PowerPoint features but want to expand your skills? On this course you will learn the essential elements of how to create an effective and appealing presentation from creating slides and slideshows from scratch, to using templates, to appropriate use of images and text. You will focus not only on the specific functions of PowerPoint but also what makes a presentation successful.



    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
    Full fee £59.00 Senior fee £47.00 Concession £30.00
  2. Excel: advanced
    Course start date:  Tue 10 Jan 2023 (and 3 other dates)

    Location on this date:  Hybrid (choose either online or in-person)

    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 will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.
    Full fee £189.00 Senior fee £151.00 Concession £123.00
    Rating:
    98% of 100
  3. Becoming confident in digital skills: Word, Excel, PowerPoint and Outlook (beginner)
    Evening
    Course start date:  Mon 16 Jan 2023

    Location on this date:  Keeley Street

    Do you know the basics of emailing and internet use? Are you ready to work with Word, Excel, PowerPoint and Outlook? 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. You will also learn the most essential aspects of Outlook so you can send and receive emails and organise them,. By the end of the course you will be able to create well-presented short texts such as letters, design simple budgets and tables,produce effective and attractive presentations and email them to friends and work colleagues. 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 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
    Full fee £99.00 Senior fee £79.00 Concession £50.00
  4. Digital skills for the workplace: using Excel (foundation)
    Evening
    Course start date:  Wed 18 Jan 2023 (and 1 other date)

    Location on this date:  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 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
    Full fee £179.00 Senior fee £143.00 Concession £90.00
  5. Business skills: how to collaborate with Microsoft Teams (intermediate)
    Evening, ONLINE
    Course start date:  Mon 23 Jan 2023 (and 1 other date)

    Location on this date:  Online

    Collaborating skills within the workplace are in demand. Almost all jobs now require you to coordinate work, build relationships and cope with complexity. Microsoft Teams is an essential digital tool to enable this. This course you will help you develop and practise these skills by learning in detail how to use Teams' key features, including 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 files in Teams, how Teams relates to SharePoint and One Drive, how you can keep track of collaborations, 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 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.
    Full fee £109.00 Senior fee £87.00 Concession £55.00
    Rating:
    100% of 100
  6. Digital skills for the workplace: creating newsletters, reports and tables with Word (intermediate)
    Course start date:  Wed 8 Feb 2023

    Location on this date:  Keeley Street

    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.



    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
    Full fee £149.00 Senior fee £119.00 Concession £75.00
  7. Excel for financial modelling
    Evening
    Course start date:  Tue 14 Feb 2023

    Location on this date:  Hybrid (choose either online or in-person)

    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 will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.
    Full fee £279.00 Senior fee £223.00 Concession £181.00
    Rating:
    100% of 100
  8. Business skills: how to collaborate using OneDrive and SharePoint (intermediate)
    Evening, ONLINE
    Course start date:  Tue 14 Feb 2023 (and 1 other date)

    Location on this date:  Online

    Collaborating across the workplace is more necessary than ever. And digital skills are essential to this ability to build relationships and cope 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 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.
    Full fee £119.00 Senior fee £95.00 Concession £60.00
  9. Excel: tables and charts
    ONLINE
    Course start date:  Wed 15 Feb 2023

    Location on this date:  Online

    Tutors:  Aurica Jalba
    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 £49.00 Senior fee £39.00 Concession £32.00
  10. Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
    ONLINE
    Course start date:  Thu 23 Feb 2023 (and 2 other dates)

    Location on this date:  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. 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
  11. Essential digital skills for the workplace: Word, Excel and PowerPoint (foundation-level 1)
    Evening
    Course start date:  Mon 27 Feb 2023 (and 1 other date)

    Location on this date:  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 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
    Full fee £99.00 Senior fee £79.00 Concession £50.00
    Rating:
    100% of 100
  12. Business administration: how to organise with OneNote (intermediate)
    ONLINE
    Course start date:  Thu 2 Mar 2023

    Location on this date:  Online

    How do you keep on top of your notes, to do list, tasks, meetings and ideas? Are you still using paper notebooks and post-it notes? Is there too much in your head cluttering your mind? This course will show how to use the digital notebook, OneNote so you become a more organised administrator. You will learn how to take notes at any time and arrange them so you can always find what you are looking for. You will practise how to create sections, pages and sub-pages and organise them effectively. You will learn how to create tags so you can find notes across sections. In addition you will learn other useful tips on how to make the most of OneNote, for example to make calculations, translate text, edit text inside images and use digital sticky notes. By the end of the course you will have clear idea of how to be organised digitally and be on your way to a paperless office.



    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.
    Full fee £59.00 Senior fee £47.00 Concession £30.00
  13. Excel: applying formulae and functions
    Course start date:  Wed 8 Mar 2023

    Location on this date:  Keeley Street

    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.
    Full fee £49.00 Senior fee £39.00 Concession £32.00
  14. Excel: expert
    ONLINE
    Course start date:  Wed 8 Mar 2023

    Location on this date:  Online

    Tutors:  Abbott Katz
    Learn how to create dialogue boxes,combo boxes,spinners,drop down lists,user forms and macros.Ideal if you've undertaken our 'Excel: advanced' course, or if you have equivalent knowledge or experience.



    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 £123.00
    Rating:
    100% of 100
  15. Excel 365's Dynamic Array Functions
    ONLINE
    Course start date:  Mon 27 Mar 2023

    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 £49.00 Senior fee £39.00 Concession £32.00

Items 1-15 of 22

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