Download workbooks and associated exercise files

Note: These training materials are licensed to the University of Aberdeen. Consequently, access is restricted to University of Aberdeen users only (University login required).

Workbooks are PDFs and exercise files are compressed as ZIPs.

  1. Finding your Way Around
  2. Creating and Using Workbooks - Exercise Files
  3. Selecting, Finding and Replacing Data - Exercise Files
  4. Inserting, Deleting & Viewing Worksheets - Exercise Files
  5. Copying, Moving and Pasting Data - Exercise Files
  6. Using Autofill and Flash Fill - Exercise Files
  7. Introduction to Formulas, Functions and Linking - Exercise Files
  8. Formatting Cells, Columns and Rows - Exercise Files
  9. Getting Ready to Print Data - Exercise Files
  10. Creating and Using Charts - Exercise Files
  11. Using the Quick Analysis Toolbar - Exercise Files
  12. Using Logical Functions - Exercise Files
  13. Using Lookup Functions - Exercise Files
  14. Using Statistical Functions - Exercise Files
  15. Using Date and time Functions - Exercise Files
  16. Using Text Functions - Exercise Files
  17. Using Other Useful Functions - Exercise Files
  18. Creating and Using Named Ranges - Exercise Files
  19. Sorting and Filtering Data - Exercise Files
  20. Using Grouping, Subtotalling and Outlining - Exercise Files
  21. Analysing Data with Pivot Tables and Pivot Charts - Exercise Files
  22. Setting Data Validation Options - Exercise Files
  23. Creating and Using Excel Tables - Exercise Files
  24. Using Conditional Formatting Rules - Exercise Files
  25. Using Data from Other Sources - Exercise Files
  26. Using the Formula Auditing Tools - Exercise Files
  27. Applying Protection Options - Exercise Files
  28. Recording Macros - Exercise Files
  29. Using the What-if Analysis Tools - Exercise Files
  30. Using the Excel Application Options - Exercise Files
  31. Using Power Pivot to analyze large amounts of data - Exercise Files