Who can take this course and what it includes?
Everyone can take this course. Microsoft Excel is taught through developing a project. This project keep, format, and compute course result.
What will learners get from this course?
Students will learn to:
a) apply excel formatting features
b) use excel formulas
c) create graph
d) set printing options
e) change percentage
What is the teaching methodology?
Project based learning methodology is adopted. In this course a project is developed incrementally. All skills are taught by working on this project.
What this course teaches?
Video 1: Course Introduction
This video introduces teacher and course.
Video 2: Excel Interface and Basic Formatting
This video covers graphical user interface of Excel and basic formatting like cut, copy, paste.
Video 3: Formatting
This video teaches following formatting features: bold, italic, underline, font size, resize column width, fill (background color), table border, merge and center, center align and middle align, and wrap text.
Video 4: Formatting and SUM Formula
This video covers SUM formula and following formatting features: auto fill, paste by value, and decimal places.
Video 5: Formatting and VLOOKUP Formula
This video teaches how VLOOKUP formula can assign grades (A, B, C, etc).
Video 6: COUNTIF Formula
This video shows how excel COUNTIF formula can count number of As, Bs, and Cs in a class.
Video 7: Graph, Print Setting and Password
This video covers graph, print setting, and file protection by setting password.
Video 8: Change Percentage
This video teaches how to change the percentage of an assessment component.