[Free] Free Excel Tutorial - Microsoft Excel For Teachers
Microsoft Excel Absolute Essential Skills for Teachers – Free Course
What you’ll learn
- 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.