Microsoft Excel for Teachers
- Basic computer literacy
- Microsoft Excel software is required
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.
- Anybody who wants to learn Excel
- Excel Interface and Basic Formatting04:59
- Excel Formatting07:11
- Formatting and SUM Formula04:58
- Formatting and VLOOKUP Formula07:15
- COUNTIF Formula03:15
- Graph, Print Setting, and Password05:00
- Change Percentage02:54
- Course Assignment1 question
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.