Microsoft Excel (Spreadsheet) Basics

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

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

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

Description
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

Who this course is for
For Beginners who have no prior knowledge of Ms Excess
For Intermediates who know some basics and wish to extend their knowledge practically