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


15 matching courses
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 Wed 20 May 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]
Thu 5 Mar 2020 09:30 [Standby]
Tue 30 Jun 2020 09:30 [Places]
Excel 2016: Introduction Tue 14 Jan 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
Thu 7 May 2020 09:30 [Places]
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 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.

[Back to top]