spreadsheets

  • course pack | Publicly viewable | v. 2013

    This is an advanced course in working with large data sets and producing pivot tables to summarise information. It provides a detailed look at the uses for pivot tables and producing graphs from them.

  • course pack | Publicly viewable | v. 2013

    An exploration of techniques that can be used to help identify and avoid errors in Excel worksheets. The course includes advice on the design of new Excel solutions. It is run in a workshop style and participants are encouraged to discuss their own work and raise issues.

  • playlist | Oxford only | v. 2013

    Watch these videos to prepare for the workshop: grow your confidence in devising and checking formulae in a spreadsheet

  • course pack | Publicly viewable | v. 2013

    A hands-on activity session to grow your confidence in devising and checking formulae in a spreadsheet

  • playlist | Oxford only | v. 2013

    Excel skills to be comfortable with before attending this course and suggested post-course study to consolidate your learning.

  • course pack | Publicly viewable | v. 2013

    This session provides an introduction to statistical functionality in Excel where you will learn how to use various tools to perform a core set of statistical operations including mean, standard deviation, frequency, goodness of fit, t tests, ANOVA, correlation and regression and then display the results in charts such as histograms.

  • course pack | Publicly viewable | v. 2013

    Use Word to carry out a mail merge - sending a standard letter to many recipients, with personalised content. A hands-on course for administrative support staff.

  • course pack | Publicly viewable | v. 2010

    Using Word, Excel and Outlook together, to send personalised emails to a list of recipients

Pages

Subscribe to spreadsheets