Course Information
Course Overview
A fast track to using Microsoft Excel Spreadsheet
This course is a fast track to using Microsoft Excel. It is designed for busy executives and professionals who do not have time for long-term training but need the basic skills to get going. Other people who have a course to calculate and manipulate data will benefit from the course I guess that virtually anybody that is living in this present digital age must fall into any of the listed categories. It is a learn-by-doing course, the tools required to start using Excel are revealed through hands-on projects. The course designers use four projects to teach the skills. The projects and the learning outcome are listed here.
1. The first part introduces the instructor and the course stressing the importance of Microsoft Excel and why students should learn it. It also covers the learning outcome and the ideal student
2. This section is a tour of the Excel workspace the aim is to acclimatize students to the working environment of Excel
3. This part unveils the tools required for Excel calculation and how to apply then
4. This section introduces the school exam result project. After the project students can comfortably use formulas, the formulas introduce are SUM, MAX, MIN, and AVERAGE. Students can apply the principle of cell references also
5. Other three projects namely Payroll Invoice, and balance sheet unveils other tools and how to use them
Course Content
- 10 section(s)
- 13 lecture(s)
- Section 1 Introduction
- Section 2 What you will learn in this course
- Section 3 Microsoft Excel Environment
- Section 4 Student Exam Result Project
- Section 5 Students' Exam result project
- Section 6 Finalize student exam result project
- Section 7 Payroll Design Project
- Section 8 Finalize the payroll project
- Section 9 Invoice design project
- Section 10 Finalise Invoice Design Project
What You’ll Learn
- Use Electronic spreadsheet to for calculations
- Create records for objects and persons i.e. school or company records
- Use Excel to create Invoices or related data like bill of quantity
- Use excel to create financial reports or similar records
Skills covered in this course
Reviews
-
KKrystal O'quinn-Mayhorn
I am definitely learning. Sometimes I need to rewind to be able to understand what the instructor is saying. Love that I have the options to pause, rewind and fast forward. This way I am not interrupting a class and I can double check myself or skip what I already know.
-
BBejadi Ramunath
good
-
EEgene Divine
excellent
-
KKulungile Kanya Gcwabe
I am very happy because it looks like I am going to learn alot