ols Logo

Advanced Microsoft Excel Training Portal

< REGISTER HERE >

ACCESS FREE MODULES HERE

Module 0 - INTRODUCTION

Module 1 - Worksheet Design

Module 2 - Training Worksheet

Module 3 - Excel Concepts

PRACTICAL SUBMISSION 1

Module 4 - Intro. 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 - Sorting And Filtering

Module 11 - Collating Multiple Sheets

PRACTICAL SUBMISSION 3

Module 12 - Pivot Tables and Charts

Module 13 - Creating Forms

PRACTICAL SUBMISSION 4

Module 14 - Protecting Your Work

Module 15 - Cell Comments

Module 16 - Programming Macros

Module 17 - Overview

PRACTICAL SUBMISSION 5

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