IT & Software

Excel Level 1

Course Fee R799.00

What this course is about

Course 1 of the Excel series is designed for people who have never worked in Excel or have only the most basic of experience, and want to get an idea of the basic functionalities of this powerful program. The course firstly navigates the student through the interface. Secondly, it showcases many of the functionalities used in foundational Excel, and uses the central theme of a spreadsheet budget to show users how one would go about doing data entries and simple manipulations.

Who should be doing this course?

The course is therefore aimed at people who will classify themselves as a novice or an absolute beginner, and will give them a basis to understand further basic commands and structures from. The course aims to assist anyone who intends on using Excel for personal or business use, and can be enrolled for even if they do not have a computer with them. Students who enrol for Excel course 2 and find it too difficult should also consider firstly completing course 1 to lay the correct foundation.

Learning outcomes

After completing this course, you should be able to:

Participants will be able to do & understand the following:

Basic use of excel for individuals and by businesses

Navigate sections of an excel screen     

Navigational features on a blank worksheet     

The quick access tool bar 

Entering and editing worksheet data      

Working with cells, rows and columns   

How to use the tabs

Commands on the ribbon 

Accessing the ribbon using the keyboard         

Creating workbooks and worksheets     

Modifying worksheets        

Duplicating worksheets and worksheet view    

Sum function and basic referencing techniques          

HOW YOUR COURSE MARK IS CALCULATED?

Your course mark is calculated using the average mark obtained in each of the Chapter tests. In order to pass this course, you must obtain a final course mark of at least 50%. This means that even if you fail a few of the chapter tests, if your test marks in the other chapter tests are high enough you will still be able to pass the course. Good Luck!

Study at your own pace!

We’ve created our courses to suit your busy life! The duration of this course is based on a student guide where one 300 – 500 word article is read per day, and the assessment is done on a separate day after the relevant articles have been reviewed. But you can do the course in your own time and at your own pace. If you choose to do two readings per day, it will take you half of the estimated time, four readings per day means doing the course in a quarter of the time etc. We leave that decision up to you!

In the 5 chapters of this course you'll be covering the following areas:

CHAPTER 1 Introduction to Excel
CHAPTER 2 Navigating the Excel Interface
CHAPTER 3 Data Selection and Formatting
CHAPTER 4 Ribbon Tabs
CHAPTER 5 Understanding workbooks, worksheets and basic referencing
Thumbnail_dr_rousseau_lötter

Dr Rousseau Lötter

Educator

Dr Lötter is a senior lecturer in Investment Management at a leading South African University. He worked as a portfolio manager at a large asset-manager before joining the University, and has held the CFP® designation since 2008. He has helped many individuals set up and plan their budgets, and has often presented financial talks in public forums. He has published financial papers in accredited journals locally and internationally, and has received numerous teaching awards in South Africa and abroad. He is married and has one daughter. Qualifications: Doctorate in Investment Management, Postgraduate Diploma in Financial Management, Certified Financial Planner
Thumbnail_f4d6e862-219c-4246-9440-6acb7a7e2998

Professor Elsamari Botha

Educator

Not sure if this is the right course for you?

Let one of your career counselors help you make the right choice.

Related Courses

Microsoft Word 2016 For Beginners

Convener: Luigi McLeod

Microsoft Word is the most popular word processing on the market and is available on platforms such as Windows, Apple MAC and Android. The Microsoft Word...
read more

WhatsApp for iPhone: A Quick Guide

Convener: Luigi McLeod

WhatsApp is a mobile messaging service that makes use of the user’s mobile phone number as a user account and their internet connection, either via cellular or...
read more

WhatsApp for Android: A Quick Guide

Convener: Luigi McLeod

WhatsApp is a mobile messaging service that makes use of the user’s mobile phone number as a user account and their internet connection, either via cellular or Wi-Fi, to...
read more

A Guide To Windows 7, 8 And 10

Convener: Aman Parker

This course is designed to teach the basics of using Microsoft Windows. The course will take learners through the basics of understanding the Windows desktop, navigating...
read more

Get To Know Your Computer Inside And Out: A Guide To Desktop Computers And How They Work

Convener: Luigi McLeod

This course will cover some of the most important things you need to know about the desktop computer, including terms/phrases, how to set up your computer and what kinds of...
read more

Get To Know Your Android Smartphone And Tablet

Convener: Deen Brandreth

An introduction to Android operating system and its key features. This course provides a step by step guide to enhance the smartphone and tablet experience. This includes...
read more