skip to navigation skip to content

Reset

Filter by

Course type

Show only:



Dates available




Places available




Theme






Filter search

Browse or search for courses


Showing courses 1-25 of 29
Courses per page: 10 | 25 | 50 | 100
Clear search

Excel 2016: Analysing and Summarising Data Tue 3 Mar 2020   09:30   [More dates...] [Places]

This hands-on course is a follow up from the Excel: Introduction course.

3 other events...

Date Availability
Wed 5 Feb 2020 09:30 [Standby]
Thu 14 May 2020 09:30 [Places]
Thu 25 Jun 2020 09:30 [Places]
Excel 2016: Functions Thu 5 Mar 2020   09:30   [More dates...] [Places]

This course covers some of the more challenging functions such as IF, SUMIFS and VLOOKUP. Not all chapters will be taught in full due to time constraints but are included for self-study.

3 other events...

Date Availability
Fri 7 Feb 2020 09:30 [Standby]
Wed 20 May 2020 09:30 [Places]
Tue 30 Jun 2020 09:30 [Places]
Excel 2016: Introduction Thu 7 May 2020   09:30   [More dates...] [Places]

Microsoft Excel is the chosen spreadsheet package as it is a popular choice, both on Apple Mac and PC. This is an instructor-led course for absolute beginners. There is a self-paced Excel Beginners course for those who prefer to learn at their own pace.

2 other events...

Date Availability
Tue 14 Jan 2020 09:30 [Standby]
Wed 10 Jun 2020 09:30 [Places]
Excel 2016: Introduction (Self-paced) Wed 22 Jan 2020   09:30   [More dates...] [Places]

Microsoft Excel is the chosen spreadsheet package as it is a popular choice, both on Macintosh and PC. This is a self-paced Excel Beginners course for those who prefer to learn at their own pace, there is an instructor present to support you if you have questions. The same course is taught as instructor-led for those who prefer this approach to learning Excel Introduction .

1 other event...

Date Availability
Tue 16 Jun 2020 09:30 Not bookable
Excel 2016: Managing Data & Lists Tue 12 May 2020   09:30   [More dates...] [Places]

3 other events...

Date Availability
Tue 28 Jan 2020 09:30 [Full]
Tue 25 Feb 2020 09:30 [Standby]
Thu 18 Jun 2020 09:30 [Places]
Excel 2016: Recorded Macros Fri 14 Feb 2020   09:30   [More dates...] [Places]

This course covers recording macros which provides automated steps to produce outcomes. This course does not teach VBA programming in full though you will gain an insight into what VBA is and how it relates to macros. if you want to learn VBA as a programming language then please see the self-taught course Programming in VBA - Using Microsoft Excel 2013. Not all chapters will be taught in full due to time constraints but are included for self-study.

3 other events...

Date Availability
Tue 10 Mar 2020 09:30 [Places]
Thu 28 May 2020 09:30 [Places]
Wed 1 Jul 2020 09:30 [Places]

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2013. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like PivotTables and goal seeking.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 3 (with Challenge Exercises) are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

Microsoft Excel 2016 - Data Analysis Add-Ins will show you how to use the data analyis add-ins of Microsoft Excel 2016, including using Power View to create interactive data visualisations, using Power Pivot to create a data model for use with Excel tools such as pivot tables and pivot charts, using Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic data.

Microsoft Excel 2016 Functions new Self-taught Not bookable

Microsoft Excel 2016 - Functions will show you how to use a variety of Excel functions, including logical functions, math functions, date and time and financial functions. It is a reference manual and is designed to be used by someone already familiar with how functions are used in Excel.

Microsoft Excel 2016 - Level 1 is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Microsoft Excel 2016 - Level 2 enables users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

Microsoft Excel 2016 - Level 3 enables users to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

  • The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Excel.
  • Please note: The majority of the training available is also applicable to Microsoft Excel 2016.

Haven't had the time to fully explore all that Excel, Word and PowerPoint has to offer? If so, now's your chance to pick up a few handy tips that you may not have discovered yet. You can save a lot of time and effort working with Excel, Word and PowerPoint if you know a few tricks and shortcuts.

1 other event...

Date Availability
Thu 4 Jun 2020 09:30 [Places]

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

Introduction to Personal Computers - Using Windows 10 and Microsoft Office 2016 is designed for users who are keen to extend their understanding of how to use computers. The skills acquired are sufficient to use the software to perform tasks including starting applications, creating folders, copying and moving files, and personalising Windows.

Introduction to Personal Computers - Using Windows 8.1 and Microsoft Office 2013 is designed for users who are keen to extend their understanding of how to use computers. The skills acquired are sufficient to use the software to perform tasks including starting applications, creating folders, copying and moving files, and personalising Windows.

The skills and knowledge acquired in Microsoft Access 2013 - Level 1 (with Challenge Exercises) are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

The skills and knowledge acquired in Microsoft Access 2016 - Level 1 (with Challenge Exercises) are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

The skills and knowledge acquired in Microsoft Access 2016 - Level 3 (with Challenge Exercises) are sufficient to design and create a multitable database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

Microsoft Office 2013 - Upgrading new Self-taught Not bookable

Microsoft Office 2013 - Upgrading provides skills and knowledge in a wide range of new features, enhancements and changes found in Microsoft Office 2013.

The skills and knowledge acquired in Microsoft Office 365 - For Business - Level 2 are sufficient to be able to use and operate the software effectively.

[Back to top]