Excel training - Basic to Advanced

This is a complete guide that any teacher with access to Microsoft Excel can work through to improve their own spreadsheet skills. Users create a mock markbook, utilising every feature in Excel I can think would be useful for a teacher.

You can go through from start to finish, or just pick out a key feature you want to work through.

See below for a list of things covered, though this list is by no means exhaustive and there is a lot more detail. Equally, if you are a beginner most of it may make no sense. Rest assured there will be something in there that can speed up your life by making good use of a spreadsheet.

Some of my favourites are being able to click a button to auto-generate an email to a specific student with parent CC’d in. Mail-merging reports to students and parents. Tracking attendance. Tracking test performance. Counting responses. Creating individual reports for students.

Also note that you can always email me for more support. I am always looking for a new Excel challenge, so if there is something you want to achieve but you aren’t sure how, get in contact with me (I do not charge for that sort of support).

Key features covered:

• Inserting a table
• Sorting data, grouping data
• Resizing columns, centering data, inserting borders & more style features.
• Conditional formatting
• Freezing panes
• Data validation
• Button click emails
• Named ranges
• Mailmerging
• Formulae: COUNT + COUNTIF + CONCATENATE + SUM + XLOOKUP + IFERROR + UNIQUE + AVERAGEIF + SUMPRODUCT + HYPERLINK + FILTER + TRANPOSE + INDIRECT + ROUND