Advanced Excel - sample training course
Welcome and Introduction
Mark Gillan welcomes you to the Advanced Excel course and provides an introduction to the use of this page - please watch video
and so it begins ... enjoy!
Importing Data
Demo files
![]()
|
![]()
|
![]()
|
![]()
|
Exercise

importing_exercise.pdf | |
File Size: | 382 kb |
File Type: |
Exercise files
![]()
|
![]()
|
![]()
|
![]()
|
![]()
|
Data Validation
Video and other links
|
Demo files

overage.xlsx | |
File Size: | 11 kb |
File Type: | xlsx |
Exercise

exercise_datavalidation.pdf | |
File Size: | 374 kb |
File Type: |
Exercise file

deliveries.xlsx | |
File Size: | 9 kb |
File Type: | xlsx |
Consolidation
Video and other links
|
Demo files
![]()
|
![]()
|
Exercise and exercise files

sales_consolidation_exercise.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
![]()
|
![]()
|

consolidation_choco_all_exercise.xlsx | |
File Size: | 14 kb |
File Type: | xlsx |
Exercise completion - answers

sales_consolidation_exercise_complete.xlsx | |
File Size: | 21 kb |
File Type: | xlsx |

consolidation_choco_allyears_complete.xlsx | |
File Size: | 15 kb |
File Type: | xlsx |
Pivot Tables and Pivot Charts
Tutorial notes

pivottables.pdf | |
File Size: | 528 kb |
File Type: |
Video and other links
|
Practice files - try using a pivot table and edit for whatever analysis you would like to perform

bigdata.xlsx | |
File Size: | 33 kb |
File Type: | xlsx |
Exercise

pivottableexercise.pdf | |
File Size: | 326 kb |
File Type: |
Exercise files
![]()
|
![]()
|
Auditing, trace precedents and dependents
Tutorial notes and explanation

auditingtools_notes.pdf | |
File Size: | 899 kb |
File Type: |
Demo files

auditing_bdm_1.xls | |
File Size: | 30 kb |
File Type: | xls |
Exercise

exercise_auditing.pdf | |
File Size: | 370 kb |
File Type: |
Exercise files
![]()
|
![]()
|
Macros
Tutorial notes and explanation

macros_explained_mg.pdf | |
File Size: | 131 kb |
File Type: |
Demo files

inventory_demo.xlsx | |
File Size: | 28 kb |
File Type: | xlsx |
Exercise

macro_exercise.pdf | |
File Size: | 203 kb |
File Type: |
Exercise files
![]()
|
![]()
|
![]()
|
![]()
|
Protection and collaboration
Tutorial notes and explanation

protection_notes.pdf | |
File Size: | 1012 kb |
File Type: |
Video and other links
Video explaining sharing process and tracking changes to Excel Workbooks - note: SkyDrive is now OneDrive
|
Demo files

protection_demo.xlsx | |
File Size: | 23 kb |
File Type: | xlsx |
Exercise

protection_exercise.pdf | |
File Size: | 188 kb |
File Type: |
Exercise files

loancalculator.xlsx | |
File Size: | 12 kb |
File Type: | xlsx |
Microsoft Excel book
Excel Exercises book by Mark Gillan via Amazon ISBN: 978-0955777073
Also available elsewhere, including Excel Exercises book by Mark Gillan via Waterstones
Also available elsewhere, including Excel Exercises book by Mark Gillan via Waterstones
Microsoft Word book
Microsoft Word Exercises book by Mark Gillan via Amazon ISBN: 978-0955777028
Also available elsewhere, including Microsoft Word book by Mark Gillan via Waterstones
Also available elsewhere, including Microsoft Word book by Mark Gillan via Waterstones
Web Design book
Qualified Teacher presents Web Design book by Mark Gillan via Amazon ISBN: 978-0955777059
Also available through other book retailers, including Qualified Teacher presents Web Design by Mark Gillan
Also available through other book retailers, including Qualified Teacher presents Web Design by Mark Gillan