Practical approach to Microsoft Excel

Basic Excel Training

Date: 5 February 2025

Venue: In-person - TBC, Windhoek

Time: 08h00 - 17h00

Cost (incl VAT): N$1,750 (including refreshments) 

CPD Hours: 8

Topics:

Navigating in excel: Resizing cells and editing cells; Adding sheets/Deleting sheets; Inserting/ deleting rows/columns; Renaming sheets; Moving between sheets (Ctrl + Pgup/Pgdn).

Working with data: Renaming ranges; Filters/Sorting; Freeze panes; Creating and formatting tables; Inserting charts; Hyperlinks; Pictures; Shapes; Printing; Transpose.

Prerequisites:

To ensure success, delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse.

Specific tasks the delegates should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders.

Intermediate Excel Training

Date: 5 February 2025

Venue: In-person - TBC, Windhoek

Time: 08h00 - 17h00

Cost (incl VAT): N$2,000 (including refreshments) 

CPD Hours: 8

Topics:

Navigating in excel: Text to column; Left formula; Right formula; Concatenate; Self filling; Date function; Time function; Data validation; Protecting excel sheets; VLOOKUP’s; Pivot tables; Conditional formatting; IF formula; SUMIF formula.

Prerequisites:

To ensure success, delegates should have completed our Basic Excel course.