Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Using Excel for Teachers
Rating: 5.0 out of 5(1 rating)
5 students

Using Excel for Teachers

Learn how to use Excel, focusing on the most important features necessary for a teaching and educational environment
Created byJustin Brodie
Last updated 2/2025
English

What you'll learn

  • Get to grips with using Microsoft Excel confidently
  • Master the basics of Excel - navigating, entering and formatting data, and using basic formulae
  • Use conditional formatting to highlight important data
  • Create a visually appealing timetable of your lessons
  • Set up and use mark books to collect and analyse student data
  • Use Excel efficiently to save time

Course content

7 sections • 37 lectures • 3h 2m total length

  • Introduction to the Course2:24
  • Layout of Excel4:10
  • Quiz on the Layout of Excel

Requirements

  • No prior knowledge of Excel required
  • Will work with any version of Microsoft Excel from 2007 onwards
  • Especially suited to teachers who need to use Excel but have limited experience

Description

Are you a teacher or do you work in education?  Do you wish to master the basics of Excel?  Have you only found courses on Excel aimed at people in business rather than education?  If so, this is the course for you.  The course will enable you to develop the following spreadsheet skills:


  • Set up a page or spreadsheet, including adding a header, so that it is suitable for printing out.

  • Enter and format data, so the presentation is clear and looks professional.

  • Use functions in order to summarise data and make calculations.

  • Copy and paste or move around data and formulas in order to save duplicating work.

  • Use conditional formatting to highlight specific data.

  • Use lookup tables to assign grades to marks, for example.

  • Develop strategies to ensure that formulas are correct, by making changes and checking results, especially after copying formulas from one place to another within a spreadsheet.

The course is presented through a series of projects, progressing in complexity, to produce the kinds of spreadsheets that a teacher or other educator should find useful.  The ideas can easily be adapted or individualised.  The projects are the following:


  • Create a weekly planner.

  • Create a timetable.

  • Set up a register.

  • Use the names from the register to produce a tick list and a seating plan.

  • Use the names from the register to produce a mark book.

Who this course is for:

  • Any teacher who has little or no previous knowledge of using Excel
  • Intermediate users who wish to refresh or build on their knowledge of Excel
  • Anybody in the world of education who has only found Excel courses aimed at businesses
  • Teachers who wish to save time by using Excel efficiently

Report abuse