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

Theme: Spreadsheets

Show:
Show only:

25 matching courses


Access 2016: Further Use Tue 23 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

This course is intended for those already using Microsoft Access 2016 who wish to explore more advanced queries and forms. Those who have attended the Access 2016: Creating a Simple Database course will find this follows on seamlessly from where that course left off - but be prepared for a harder challenge. Part of the course explores relational database design concepts for simple databases. The remainder focuses on more advanced queries and forms. The second session is optional for you to either work through and consolidate the course material, or to receive support on your own project.

Adobe InDesign CC: Introduction to Desktop Publishing Wed 3 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

Adobe InDesign CC is the industry leading page design and layout application. You will build up a publication from ready-prepared text, images and graphics in the same way as QuarkXpress and PageMaker.

Please note: This course requires that you use your CRSid and Raven password to log into Adobe Creative Cloud. If you currently log in to use Microsoft Office, then the same login details are used, and you do not need to do anything except to know your Raven password.

Otherwise, if you do not know your password, or have not changed your Raven password in the last three years, you must do so before attending the course, please go here: https://password.csx.cam.ac.uk/ you can set the same password.

Please arrive to START THE COURSE PROMPTLY in order to set up the Adobe environment, if you don’t then you may find it more difficult to follow the instructor.

This instructor-led fee based course has been commissioned by the UIS through a third party company.

Learn how with Windows PowerShell 4.0, you can remotely manage multiple Windows based servers and automate day to day management and administration tasks.

The course is built on Windows Server 2012 R2 and Windows 8.1 and while it is specifically focused on Windows PowerShell v4.0, is also relevant in v2.0 and v3.0 Windows PowerShell environments.

This five day course provides students with the fundamental knowledge and skills, using hands-on instruction and practice, to use Windows PowerShell 4.0 for administering and automating administration of Windows based servers. It focuses on primary Windows PowerShell command-line features and techniques, and will provide pre-requisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Exchange Server, SharePoint Server, SQL Server, System Center, and more. In keeping with that goal, this course will not focus on any one of those products, although Windows Server (which is the common platform for all of those) will serve as the example for the techniques being taught.

In this five day course you will learn to execute and monitor scripts more efficiently through more robust session connectivity, workflow capabilities, enhanced job scheduling, and Windows PowerShell Web Access. Learn Windows PowerShell with greater ease through improved cmdlet discovery and simplified, consistent syntax across all cmdlets. Write Windows PowerShell scripts quicker and more intuitively through the new Integrated Scripting Environment (ISE) that enables script sharing, which connects IT pros to a larger Windows PowerShell user community. Learn all this and more in this five-day Microsoft Official Course in Windows PowerShell 4.0.

Excel 2016: Analysing and Summarising Data Thu 14 May 2020   09:30 CANCELLED

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

Excel 2016: Functions Tue 30 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

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 Wed 10 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

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 16 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

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 Tue 12 May 2020   09:30 CANCELLED
Excel 2016: Recorded Macros Thu 28 May 2020   09:30 CANCELLED

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.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Excel: Data Analysis (Online) Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Excel: Data Analysis: Forecasting (Online) Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Excel: Learning VBA (Online) Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Excel: Statistical Process Control (Online) Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Google Forms: Essential Training (Online) new Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Google Sheets Quick Tips (Online) Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

LiL: Office 365 - Learning Office 365 (Online) Self-taught Booking not required

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

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]