Excel

29 resource(s) found!
  1. hands-on task | Publicly viewable | v. 2013

    This task will give you a flavour of how Excel can help you examine long lists of data, quickly and easily

  2. hands-on task | Publicly viewable | v. 2013

    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

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

  4. article | Publicly viewable | v. 2010

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

  5. video | Publicly viewable | v. 2013

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

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

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

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

  9. course pack | Publicly viewable | v. 2010

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

  10. course pack | Publicly viewable | v. 2013

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

  11. 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 an opportunity to learn about presenting data visually using charts

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

  13. course pack | Publicly viewable | v. 2013

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

  14. course pack | Publicly viewable | v. 2010

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

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

  16. course pack | Publicly viewable | v. 2013

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

  17. course pack | Publicly viewable | v. 2013

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

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

  19. video | Publicly viewable | v. 2013

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

  20. course pack | Publicly viewable

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

  21. course pack | Publicly viewable

    This course will cover basic concepts in exploratory data analysis and statistical modelling using R.

  22. software | Publicly viewable

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

  23. software | Publicly viewable

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

  24. learning activity | Publicly viewable

    This course provides you with you with an introdution to R.

    These activities will help you prepare for attending this workshop.  There is some introductory material and two tasks to complete.

     


     

  25. article | Publicly viewable | v. 2010

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

  26. article | Publicly viewable | v. 2010

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

  27. website | Publicly viewable | v. 2010

    The Office 2010 ribbon, common to all of the Office 2010 applications such as Word, Excel and Outlook, is quite different from the menus available in previous Office versions. Discover some interactive guides that will help you track down your most-used menu options in the new ribbon.

  28. software | Publicly viewable

    Microsoft Office Access is a relational database management system. You can use it for data which is too complex to be modelled using Excel spreadsheets.

  29. hands-on task | Publicly viewable

    Try out the snip tool to take a quick screen capture, for example so as to report an error message that has appeared