Microsoft Excel for Teachers

Microsoft Excel Absolute Essential Skills for Teachers
Rating: 4.3 out of 5 (50 ratings)
2,856 students
Microsoft Excel for Teachers
Rating: 4.3 out of 5 (50 ratings)
2,856 students
Apply excel formatting features to enhance the look and readability of document
Use excel formulas to compute sum, average, grades, and number of occurrences of each grade
Create graph to show class result vividly
Set printing options to produce output on one page
Set password to control file access
Change assessment percentage

Requirements

  • Basic computer literacy
  • Microsoft Excel software is required
Description

This course teaches skills that are required to create, format, and compile class result in Microsoft Excel. First, it teaches Excel formatting. Second, it covers SUM, AVERAGE, VLOOKUP, and COUNTIF formulas. Third, it teaches graph creation. Fourth, it shows print settings. Fifth, it covers file password setting. Last, it teaches how to change the percentage.

This course is project-based, all skills are taught by accomplishing a project incrementally.

Microsoft Excel 2016 is used in MacBook to record course videos.

Who this course is for:
  • Teachers
  • Anybody who wants to learn Excel
Course content
4 sections • 7 lectures • 35m total length
  • Excel Interface and Basic Formatting
    04:59
  • Excel Formatting
    07:11
  • Formatting and SUM Formula
    04:58
  • Formatting and VLOOKUP Formula
    07:15
  • COUNTIF Formula
    03:15
  • Graph, Print Setting, and Password
    05:00
  • Change Percentage
    02:54
  • Course Assignment
    1 question

Instructor
Humera Ghani Khan
  • 4.4 Instructor Rating
  • 54 Reviews
  • 3,435 Students
  • 2 Courses

Course instructor, Humera Ghani Khan, has 10+ years teaching experience. She has worked on senior management positions in academia. Now, she is involved in teaching, research, curriculum development, and project supervision.

Her pedagogical approach is student centered. She believes each learner is unique and requires some input addressing his specific need. Therefore, she is always available to answer her student’s queries.