Excel 2016

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