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 |
Exercise files
|
|
| ||||||
|
| ||||
Data Validation
|
Video and other links
|
Demo files
| overage.xlsx |
Exercise
| exercise_datavalidation.pdf |
Exercise file
| deliveries.xlsx |
Consolidation
|
Video and other links
|
Demo files
|
| ||||
Exercise and exercise files
| sales_consolidation_exercise.xlsx |
|
| ||||
| consolidation_choco_all_exercise.xlsx |
Exercise completion - answers
| sales_consolidation_exercise_complete.xlsx |
| consolidation_choco_allyears_complete.xlsx |
Pivot Tables and Pivot Charts
Tutorial notes
| pivottables.pdf |
|
Video and other links
|
Practice files - try using a pivot table and edit for whatever analysis you would like to perform
| bigdata.xlsx |
Exercise
| pivottableexercise.pdf |
Exercise files
|
| ||||
Auditing, trace precedents and dependents
Tutorial notes and explanation
| auditingtools_notes.pdf |
Demo files
| auditing_bdm_1.xls |
Exercise
| exercise_auditing.pdf |
Exercise files
|
| ||||
Macros
Tutorial notes and explanation
| macros_explained_mg.pdf |
Demo files
| inventory_demo.xlsx |
Exercise
| macro_exercise.pdf |
Exercise files
|
| ||||
|
| ||||
Protection and collaboration
Tutorial notes and explanation
| protection_notes.pdf |
|
Video and other links
Video explaining sharing process and tracking changes to Excel Workbooks - note: SkyDrive is now OneDrive
|
Demo files
| protection_demo.xlsx |
Exercise
| protection_exercise.pdf |
Exercise files
| loancalculator.xlsx |
|
Reading List and resources |
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
|
Other books by Mark Gillan |
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