Work through this MS Excel tutorial, which introduces new users to a spreadsheet program and helps them create a simple mark book to record and store student marks. It looks at basic formatting, calculating the sum and average of a set of numbers, and writing formulas to determine term marks.
Task 1b [Intermediate]
Creating a Class Mark Book in Excel (2 Hours)
Work through this MS Excel tutorial, which introduces intermediate users of MS Excel to some cool, advanced features to improve your mark book. It includes training in Autofill, AutoFilters, Conditional Formatting, Customising Toolbars and the VLOOKUP function.
| 120 min |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
