ols Logo

Advanced Microsoft Excel Training Portal

MAIN MENU:

JOIN QUESTION/ DISCUSSION FORUM

Items in RED can be accessed without REGISTERING.

Module 0 - INTRODUCTION

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 : INTRODUCTION SCREEN

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 practical submissions are not tests or homework but simply proof that you are following the lessons. Each lesson shows you how to perform certain tasks which you will be required to perform in the training worksheet that you are going to create.

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.

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


ALL THE BEST