Tools & resources
Your course files, and a few things worth keeping.
Been on one of our training days? Everything you worked from is here to download. And whether you’ve trained with us or not, help yourself to our free quick-reference guides.
Downloads
Everything in one place.
Excel
Free reference guides and handouts, distilled from the things people ask us about most. Click to download – no sign-up, no details to hand over.
Excel
- Conditionally formatting dates in ExcelWant to format rows where the date is in the next 2 weeks? Or just dates in the past? This guide tells you how.PDF
- Working with data in ExcelFrom sorting and filtering to using Database functions such as DMAX and DGET.PDF
- Common functions in ExcelThe functions that people most ask us about – including SUM, MAX, MIN, COUNT, COUNTIF, SUMIF and more.PDF
- The top 5 Excel shortcuts – infographicWant a quick poster for your wall to remind you of the best 5 shortcuts in Excel? Look no further!PDF
Databases
- Database requirements analysisIf you are planning a database – whether web, Access, SQL or any other platform, this document helps you ask the right questions before you start.PDF
- A guide to writing SQL queriesA complete guide to writing SQL queries – starting with the absolute basics and working up from there.PDF
- Splitting an Access databaseIf your Access database is a single file – data, forms and all – you need to split it. This guide tells you how and why.PDF
- Microsoft Access basicsFor anyone just getting to grips with building databases in Access – this is the essential guide.PDF
- Naming conventions in Microsoft AccessNot everyone uses a naming convention in Access. But if you’re going to, here’s a guide to the most common conventions in use.PDF
Word
More guides and handouts on the way – check back soon.