Excel

58 resource(s) found!
  1. course pack | Publicly viewable | v. 2013

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

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

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

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

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

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

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

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

  9. article | Publicly viewable | v. 2010

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

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

  11. video | Publicly viewable | v. 2013

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

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

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

  14. video | Oxford only | v. 2007

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

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

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

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

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

  19. course pack | Publicly viewable | v. 2010

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

  20. course pack | Publicly viewable | v. 2013

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

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

  22. playlist | Oxford only | v. 2013

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

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

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

  25. course pack | Publicly viewable | v. 2013

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

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

  27. playlist | Oxford only | v. 2013

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

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

  29. course pack | Publicly viewable | v. 2010

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

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

  31. playlist | Oxford only | v. 2013

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

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

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

  34. course pack | Publicly viewable | v. 2013

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

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

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

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

  38. video | Publicly viewable | v. 2013

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

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

  40. playlist | Oxford only | v. 2013

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

  41. course pack | Publicly viewable

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

  42. course pack | Publicly viewable

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

  43. course pack | Oxford only

    This one-day course introduces the concept of regression and then extends this to multiple regression using practical, real examples.

  44. software | Publicly viewable

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

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

  46. software | Publicly viewable

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

  47. event | Oxford only

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

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

     


     

  49. learning activity | Oxford only

    This one-day course introduces the concept of regression and then extends this to multiple regression using practical, real examples.

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

  51. playlist | Oxford only

    Watch these videos to prepare for the workshop: Enhance your online presence using CSS.

  52. playlist | Oxford only | v. 2013

    If you are new to Microsoft Office, here is an opportunity to get your skills started in Word, Excel, and Office.
    With a series of videos, you can follow the simple step-by-step instructions, working at your own pace.

  53. course pack | Oxford only | v. 2010

    This module shows how to make effective use of graphics in your documents. The graphics may already exist as images (JPEGs, GIFs) or you can create simple graphics and diagrams directly. You will also learn how to create charts and data tables using the Excel features that are available in Word 2010.

  54. article | Publicly viewable | v. 2010

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

  55. article | Publicly viewable | v. 2010

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

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

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

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