Entering marks

I used Camtasia to create the following clips relating to working with marks in Excel: the first is about checking that valid marks (Validation) are added to a marksheet, then showing how the highest and lowest marks (Conditional formatting) can quickly be seen, and then how to add a code (Vlookup) to a percentage. Please WAIT to view them and make sure your speakers are switched on.