Practical approach to Microsoft Excel
The Business School presents Microsoft Excel training.
Basic Excel Training
Date:
6 February and 12 June 2024
Venue:
In-person - PwC Business School, 344 Independence Ave, Windhoek
Virtually - in the comfort of your home or office.
Time: 08h00 - 17h00
Cost (incl VAT):
N$1,500 (including refreshments)
N$1,300 (virtual attendees)
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: 7 February and 13 June 2024
Venue:
In-person - PwC Business School, 344 Independence Ave, Windhoek
Virtually - in the comfort of your home or office.
Time: 08h00 - 17h00
Cost (incl VAT):
N$2,000 (including refreshments)
N$1,800 (virtual attendees)
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.
Cost for both sessions: N$3,500 per delegate for the classroom attendance and N$3,000 for the virtual attendance.
CPD Hours: 16
PayToday is available for Business School event registration and payment. Just browse PwC on the PayToday App and select the PwC Business School for your payment.
Registrations for February sessions close 30 January 2024. For logistical purposes registrations will close at 15h00.
Registrations for June sessions close 5 June 2024. For logistical purposes registrations will close at 15h00.
Contact us
