ols Logo

Advanced MS Excel Training Portal - Free Modules

MAIN MENU:

Back To Main Screen

Module 1 - Worksheet Design Considerations

Module 2 - Creating The Training Worksheet

Module 3 - Revision Of Basic Excel Concepts

PRACTICAL SUBMISSION 1

Module 4 - Introduction To Functions

Module 5 - String Functions

Module 6 - Date Functions

Module 7 - Financial Functions

Module 8 - Conditional Formatting

PRACTICAL SUBMISSION 2

Module 9 - Data Validation

Module 10 - Data Sorting And Filtering

Module 11 - Collating Data From Different WorkSheets

PRACTICAL SUBMISSION 3

Module 12 - Pivot Tables and Charts

Module 13 - Creating Data Collection Forms

PRACTICAL SUBMISSION 4

Module 14 - Protecting Your Work

Module 15 - Cell Comments

Module 16 - Programming Macros

Module 17 - Overview

PRACTICAL SUBMISSION 5


Foundation For Business Technology cc. Windhoek, Namibia......Email: This email address is being protected from spambots. You need JavaScript enabled to view it.


YOU ARE ON : MODULE 1 - Worksheet Design Considerations

Expand The Video To Go Into Full Screen

INTRODUCTION

This course was designed for people with a working knowledge of MS Excel. Its main objective is to equip you with skills to use Excel functions you already know and more that will be introduced, to solve business problems within the work place.

The course is very practical and will take you step by step in creating a spreadsheet on which you will practise all the.concepts that will be taught.

The practical submissions screens allow you to upload the worksheet whose name must consist of your name and the task number, eg Mary Johannes - Task 1

If at any stage you wish to ask a question or you need further clarification, post in the discussion for that particular module. The rest of the trainees will be able to see your questions and the answers given.

Should you be completely stuck, feel free to ask your colleagues who are with you on the training first. The person who helps you will better understand the concept after explaining it to you.

If you can not find a colleague to assist you, you can call the instructor Mr Tendayi on 081 255 0417


ALL THE BEST