Course Information

Facilitators:

The completion of the training will allow users to harness the functionality inherent in Excel by:

• Applying short cuts enabling the user to save time

• Application of new formulae that enhance data presentation and manipulation of any dataset in the following areas:

• Financial
• Calculation of interest and capital payments
• Calculation of payment periods and interest rates
• Calculation of present, net present and future values
• Calculation of internal rate of returns
• Calculation of straight line depreciation and the allowable depreciation per year
• Date and Time
• Isolation and manipulation of year, month, day, hour, minute and second components
• Determination of weekdays, week numbers, and number of working days between given dates
• Mathematical Operands
• Summation, subtraction, multiplication and division
• Combination of summation and other operands
• Exponential, square rooting and raising to the power operands
• Conditional summation
• Statistical
• Measure of central positioning
• Maximum and minimum ranges and associated positions of values in data sets
• Measure of data dispersion
• Forecasting
• Data lookup operands
• Text manipulation operands
• Data and cell information operands
• Logic function
• What if analysis
• Data validation
• Pivot tables and charts

• The application of material learned in practical situations

Training course prerequisites

To achieve the completion of the given framework within the allotted time, the participants must already have good working knowledge of Excel.  Thus the participant must be comfortable with the basic functionality of worksheet creation and the navigation within a spreadsheet.  No time will be afforded to explain the fundamentals of Excel.

Duration

16 hours.  A R250.00 Non-refundable registration fee applies to all courses and is not include in the  pricing.

Contact us for the cost of this course and for registration enquiries

Email: Donovan Email: Kelly