Basic Training for MS Excel

AIMS

This training is designed such that participants will gain practical, job-ready Excel skills through guided learning and real-world activities. By the end of the training, participants will be able to:

– Confidently create, save and manage Excel spreadsheets
– Enter, format and organise data effectively
– Use formulas and functions to perform common calculations
– Apply formatting and referencing techniques to enhance accuracy
– Handle basic data tasks such as totals, averages and simple reports

Training Content

Excel Foundations
– Spreadsheet basics: creating, saving and navigating
– Managing worksheets, rows and columns
– Entering and editing data, selecting ranges
– Auto-fill and Auto-complete

Formatting for Clarity
– Number & text formats (currency, dates, percentages)
– Custom formatting for professional outputs

Formulas & Functions
– Performing calculations
– Absolute & mixed references
– Referencing across worksheets

Essential Functions
– SUM, AVERAGE, MAX, MIN
– COUNT, COUNTA, COUNTBLANK

Hands-on Activities

Who should attend

– Beginners with little or no familiarity with MS Excel
– Anyone looking to enhance their knowledge of MS Excel

Participants are expected to bring their own laptops with MS Excel installed.

BND100/Pax BND 60/pax (for BICPA members)

BND150/Pax BND 90/Pax (for non-BICPA members)