Excel

  • playlist | Oxford only

    Playlist for Matlab is a high-performance language for technical computing. This course provides a working introduction to the Matlab technical computing environment. Themes of data analysis, visualization, and programming are explored throughout the course.

  • software | Publicly viewable

    Download a tool to help you choose which software to use, for your database project

  • video | Publicly viewable | v. 2013

    Watch this video to make the switch to Excel 2013 from earlier versions of Excel.

  • course pack | Oxford only | v. 2010

    Analysing your data across multiple worksheets and workbooks? It couldn't be easier using 3-D referencing. Perhaps you want to collaborate with others? Find out how to protect your workbooks or even lock some areas, to keep the data secure and prevent accidental edits. Want to learn some advanced charting features and how to create histograms? Learn how to do all this and more.

  • course pack | Oxford only | v. 2010

    How do you filter, summarise and subtotal large lists of data? With this course you will learn all about advanced filtering, database and other advanced functions to answer the question. Want to do some "what-if-analysis"? Want to find out how to create dynamic models that instantly recalculate when related cell values change? How do you analyse external data? Learn to use some of the more advanced tools in Excel and get the answers to these questions and much more.

  • course pack | Oxford only | v. 2010

    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 | Oxford only | v. 2010

    As a data analysis tool it is hard to see past pivot tables. Learn how easy it is to create multiple views, calculated fields and items just by dragging and dropping.

  • course pack | Oxford only | v. 2011

    As a data analysis tool it is hard to see past pivot tables. Learn how easy it is to create multiple views, calculated fields and items just by dragging and dropping. Want to create a pivot chart from an external data source or filter data with Slicers? Easy.

  • hands-on task | Publicly viewable

    This task will give you a flavour of how Excel might be used to collate and organise data and to carry out calculations and analysis

  • article | Publicly viewable | v. 2010

    Checklist of where the Excel commands have gone, in version 2010; presented in an Excel workbook.

  • course pack | Oxford only | v. 2010

    Covering some aspects of Excel that puzzle users, including frequency distribution, arrays dynamic charts. Move beyond macros to VBA coding.

  • course pack | Publicly viewable

    A one-day workshop to introduce those researching in the fields of history and archaeology to working with computerised databases.

  • software | Publicly viewable

    View the IT Learning Programme web page for information about the learning resources available for different Microsoft Office versions.

  • software | Oxford only

    Microsoft Office 365 for Students: student copies of Office 365 Pro Plus are now available free of charge for Oxford University members

  • video | Publicly viewable | v. 2013

    Watch these videos to make the switch to Office 2013 from earlier versions of Office.

  • playlist | Oxford only | v. 2013

    This course is an introduction to using VBA in Excel. VBA is a powerful programming language that can be used to add functionaility to your spreadsheets.

  • learning activity | Publicly viewable

    1 sentence teaser text for the search results list

  • event | Oxford only

    At this hands-on session, graduate researchers in the Humanities 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 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.

Pages

Subscribe to Excel