skip to navigation skip to content
Providers & themes
Find theme:
Select provider / theme

Theme: Spreadsheets

Show:
Show only:

18 matching courses


Excel 2016: Analysing and Summarising Data Thu 20 Jun 2019   09:30 Finished

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

Excel 2016: Functions Thu 27 Jun 2019   09:30 Finished

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.

Excel 2016: Introduction Tue 9 Jul 2019   09:30 Finished

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.

Excel 2016: Introduction (Self-paced) Tue 11 Jun 2019   09:30 Finished

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 .

Excel 2016: Managing Data & Lists Thu 13 Jun 2019   09:30 Finished
Excel 2016: Recorded Macros Thu 4 Jul 2019   09:30 Finished

This course covers recording macros which provides automated steps to produce outcomes. This course does not teach VBA programming, if you want to learn VBA 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.

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 aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

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

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 - 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.

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 - 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.

Confused between Office 365 and OneDrive and Office Online? Want a clear explanation of these and help getting started? Then this course is for you.

After a short presentation there will be the opportunity to set up your Office 365 account and use Office Online. You can try the new online applications such as Sway, Yammer or Forms and collaborate with others using online documents. Also bring your own device if you would like to get support installing the applications or working online away from your desk.

To participate in the course activities, if you have not already done so, you will need enable your account by synchronising your UIS Password with your University Microsoft account. Please do this at least one day before the class.

[Back to top]