Microsoft Excel: Super User

This one-day course is designed to introduce the advanced user to more of Microsoft Excel's specialised functions.

Successfully completed Microsoft Excel: Advanced Course and be fully competent with all the concepts covered.

This course consists of 6 modules
Module One	Using Add-Ins Paste Special Operation commands
Module Two	Text Functions: Using Concatenate Using Change Text case Using Extract characters
Module Three	Date & Time Options: Dispaly the current date Calculate the number of days between two dates Calculate the number of working days between two dates Calculate the number of months between two dates Calculate the number of years between two dates Calculate a person’s age
Module Four	Logical Functions: Using the And/Or functions with CountIf Using the And function eith the IF Using SumIf Using CountIf
Module Five	Financial Functions: Using Ipmt Using IsPmt Using CumIpmt
Module Six	Advanced Filters: Extracting information to other sheets using the Advanced filter

Duration	1 day
Cost	R915,00 (excl. VAT)
Includes	Comprehensive Manual Lunch & Refreshments Electronic Certificate (on successful completion of the course) Electronic Trainer Feedback Report Electronic Delegate Feedback Questionnaire

Any delegate wanting to further develop their skills in designing specialised spreadsheet solutions.

Website Designed by: Witz Communication