spreadsheets

  • event | Oxford only

    At this hands-on session, graduate researchers in Medical Science are invited to try out some IT and library skills and services to support their work.

  • event | Oxford only

    At this hands-on session, graduate researchers in Maths, Physical and Life Sciences are invited to try out some IT and library skills and services to support their work.

  • event | Oxford only

    At this hands-on session, graduate researchers in Social Science are invited to try out some IT and library skills and services to support their work.

  • event | Oxford only

    Hands-on sessions where graduate researchers are invited to try out some tools and services to support their work.

  • course pack | Publicly viewable | v. 2013

    This is an advanced course in using Excel's analytical tools

  • course pack | Publicly viewable | v. 2010

    This is an advanced course in using Excel's analytical tools

  • course pack | Publicly viewable | v. 2010

    This introductory course covers some basic statistical concepts and is intended for staff who need to use statisitical information in their work but may also be useful for research staff who want to refresh their knowledge of simple statistics

  • course pack | Publicly viewable | v. 2013

    Learn to create spreadsheets that are efficient, easy to understand and reliable (old version of this course)

  • playlist | Oxford only | v. 2013

    Essential Excel skills to be comfortable with before attending this course.

  • course pack | Oxford only | v. 2013

    This session provides an introduction to effective tools and techniques for planning, creating and maintaining spreadsheets. It shows you how to find and solve existing errors as well as introducing procedures that prevent new errors arising. The session also explains how to evaluate and “tame” a spreadsheet that you inherit so that you can deploy it effectively.

  • software | Publicly viewable

    Excel is a well-known spreadsheet application. Use it to collate and organise data, to carry out calculations and analysis, and to create graphs.

  • playlist | Oxford only | v. 2013

    Watch these videos to prepare for the workshop: learn to create spreadsheets that are efficient, easy to understand and reliable.

  • course pack | Publicly viewable | v. 2013

    Learn to create spreadsheets that are efficient, easy to understand and reliable.

  • playlist | Oxford only | v. 2013

    This session provides guidance on which charts to use in both administrative and research situations and how to use them to convey messages clearly and effectively.

  • playlist | Oxford only | v. 2013

    Essential Excel skills to be comfortable with before attending this course.

  • course pack | Oxford only | v. 2013

    This session shows you how to use Excel’s lookup functions to retrieve only the results that you need from spreadsheet tables of any size.

  • playlist | Oxford only | v. 2013

    Watch these videos to prepare for the workshop: you will work with different types of large data sets to produce pivot tables to summarise data.

  • course pack | Publicly viewable | v. 2013

    Working with different types of large data sets producing PivotTables to summarise data. Using the features in PivotTables to enable you to create Reports, Slicers, Calculated Fields as well as Grouping and Sorting data.

  • course pack | Publicly viewable | v. 2013

    The course covers a number of techniques for analysing data using filters to narrow down the data and sorting to arrange it. The course provides and opportunity to learn about presenting data visually using charts

  • video | Oxford only | v. 2007

    Watch videos to learn about pivot tables and see how they are made

Pages

Subscribe to spreadsheets