Naming ranges in Microsoft Excel is a great technique for making your formulas simple to write and to understand. A named range in Microsoft Excel is much easier to recall and remember than the standard top left to bottom right refer[ces that Excel likes to use.

Need to construct a Gradebook or e-Markbook for your class? This Teachers Guide to Microsoft Excel will teach you step by step all the techniques you will need for creating feature rich and dynamic gradebooks, complete with a student summary page and flight paths./10

This video series is accompanied by a workbook, also made in excel, which includes example of the formulas used and some tasks for you to complete to check your understanding and practice the skills.

Get the Series Workbook here:
►Download: https://mr.tompkins.online/excel

Channel Members and Patreon Members can get an enhanced version of this workbook, which includes my own template for emarkbooks and dynamic student summary page. Click the JOIN button below the video to become a channel member:
►Join: https://youtube.com/c/mrtompkinsedtech/join

Or sign up to Patreon here:
►Signup: https://mr.tompkins.online/patreon

#MicrosoftExcel #Gradebooks #Markbooks #Edtech #UKEdChat #EdChat #MrTompkinsEdtech #MIEExpert
__________________________________________________________________
This video is part of the following playlist series:

Teachers Guide to Microsoft Excel:
https://www.youtube.com/playlist?list=PLxp90x5c0ttZ2I01XOmKSRHoUiaQzZ7T6

Using Microsoft Office 365 for Schools – A Teachers Guide
https://www.youtube.com/watch?v=7Cvw2YLPijM&t=21s&index=1&list=PLxp90x5c0ttaUTXly-0TjRtZfXIZ5JY69
———————————————————————————————————–
MrTompkinsEdTech on Social Media:
► https://www.facebook.com/MrTompkinsEdTech/
► https://twitter.com/AnthonyTompkins

For exclusive content, including an enhanced version of the accompanying excel workbook:
► Check out my Patreon page at: https://patreon.com/mrtompkinsedtech
——————————————————————————————————–
Mr Tompkins Ed Tech uses the following for making videos:
►Blue Snowball Cardiod USB Microphone – https://amzn.to/2IPZqSd
► Camtasia Studio (video editing software)- https://amzn.to/2xhobV6

Find more calculators, teacher/student laptops and maths gift ideas in:
► My Store: https://amazon.co.uk/shop/mrtompkinsedtech

► AD: Try Audible and Get Two Free Audiobooks: https://amzn.to/2O8InNJ

► AD: Teachers! Claim your free £80 voucher for Naked Wines!: https://www.nakedwines.com/invite/anthony-tompkins
——————————————————————————————————–
Did MrTompkinsEdTech help you with your teaching? Say thank you and
► Buy the creator a coffee at: https://www.paypal.me/MrTompkins

You can also show appreciation by purchasing something from amazon after visiting my storefront – you will pay the exact same price, but MrTompkinsEdtech will earn a small commission from the sale:
► My Store: https://amazon.co.uk/shop/mrtompkinsedtech
——————————————————————————————————-
Mr Tompkins is a qualified teacher with 20+ years classroom experience. BSc (Hons) Mathematics, Post Graduate Certificate in Education, Certified Apple Teacher, Microsoft Certified Educator, and Microsoft Innovative Educator Expert. MrTompkinsEdTech is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.