Microsoft Excel (Spreadsheet) Basics

A practical or hands-on approach on how you can create spreadsheets

The Microsoft Excel (Ms-Excel) application is one of the many applications in the Microsoft Office package. Ms-Excel is used in offices, schools, and organizations to create financial and accounting sheets and documentation such as balanced sheet, profit, and loss profit. You can also add some graphics and designs in your worksheet or documents.

What you’ll learn

  • You will be able to start Ms Excess application and understand its environment.
  • You will be able to create and work with Workbook and Worksheets from scratch.
  • You will be able to edit and format text in your workbook.
  • You will be able to work with Layout and Designs.
  • You will be able to create and work with Charts and Pictures in your workbook.
  • You will be able to use Formulas and Functions.

Course Content

  • General Introduction and Course Description –> 1 lecture • 1min.
  • Module 1 – Introduction to Ms-Excel Environment –> 7 lectures • 46min.
  • Module 2 – Working with Workbook, Worksheets and Cells –> 7 lectures • 50min.
  • Module 3 – Entering and Editing Text –> 3 lectures • 16min.
  • Module 4 – Formatting Text, Layout and Designs –> 8 lectures • 38min.
  • Module 5 – Charts and Pictures + Formulas and Functions –> 10 lectures • 1hr 2min.

Auto Draft

Requirements

  • Basic knowledge of using a windows operating system interface like Windows 10 or any other windows.
  • Ensure you have Ms Excess installed on your laptop or computer via Microsoft Office package (e.g. Ms Office 365 or any other).
  • A laptop or desktop computer.

The Microsoft Excel (Ms-Excel) application is one of the many applications in the Microsoft Office package. Ms-Excel is used in offices, schools, and organizations to create financial and accounting sheets and documentation such as balanced sheet, profit, and loss profit. You can also add some graphics and designs in your worksheet or documents.

 

Course Objectives

In this Ms-Excel course, we will utilize a practical or hands-on approach to show how you can create simple Excel documents or worksheets or workbook with pre-formatted texts, tables and adding some graphics and designs. You will learn the skills of editing texts, formatting texts, creating tables, adding designs to your workbook. You will also learn to do some financial calculations at the end of this course.

 

Pre-Requirements and Target Audience

The course is designed for both beginners who do not have any prior background in Ms-Excel, and for intermediate level people who also wish to extend their practical/hand-on skills and knowledge.

To achieve or fully take advantage of this course, you need to have some prior knowledge Windows operating system environments.

It is important you have a laptop or desktop computer with the Ms-Excel application installed, preferably, a laptop with Windows 10 and with Office365.

 

Job Opportunities – The course also enables you to find jobs in the following areas

  • Secretarial job in any organization
  • Freelancer – Create financial and accounting sheets adaptable to the need of an individual or group and get paid based on hours spent
  • Marketing and Accounting jobs (related to financial promotions using Excel skills)
  • Education as a trainer/instructor in a primary school, secondary/high school, private firms etc.
  • Start your own Computer Business and Computer Training for Ms-Excel with little income/investment.

 

Course Modules / Structure

The Course is divided into 5 Modules:

Module 1: Introduction to Ms-Excel Environment

Module 2: Working with Workbook, Worksheets and Cells

Module 3: Entering and Editing Text

Module 4: Formatting Text, Layout and Designs

Module 5: Charts and Pictures + Formulas and Functions

 

Finding the Course (Modules) Contents

For each module, a number of videos are made available. These guide you step-by-step through the course. If you have issues with the course materials, please send us a feedback.