Quotations are hereby invited for the procurement of a registered service provider to conduct Inhouse Advanced Excel Training for 60 employees. The following outcomes are outlined as guidelines to what the course should entail: 1. Formulas and outlines; 2. Manipulating & validating data; 3. Data-in data-out; 4. Workbooks, Development of Charts, Analyzing Data; 5. Conditional formatting; 6. Templates; 7. Advanced Options; 8. Macros and customizations; 9. Program Excel macros; 10. Use Excel newsgroups for support; 11. Use string arithmetic; 12. Encrypt worksheet files for security; 13. Use the Subtotal function for ease of creating totals; 14. Edit with cut, copy & paste - advanced data exchange in Windows - the best tricks and techniques; 15. Build database queries, create and use Web queries; 16. Use VLookup and HLookup to deal with information in tables; 17. Protect the document to make it tamper proof; 18. Taking large amounts of data and manipulate it in a way that is easy for others to understand. Training will take place around Polokwane. Duration of the training: • Three (3) days per group. Training will be divided into four (4) groups of each contain fifteen (15) employees. (ЮАР - Тендер #62015032)

LPT/QUT/2024 New

Quotations are hereby invited for the procurement of a registered service provider to conduct Inhouse Advanced Excel Training for 60 employees. The following outcomes are outlined as guidelines to what the course should entail: 1. Formulas and outlines; 2. Manipulating & validating data; 3. Data-in data-out; 4. Workbooks, Development of Charts, Analyzing Data; 5. Conditional formatting; 6. Templates; 7. Advanced Options; 8. Macros and customizations; 9. Program Excel macros; 10. Use Excel newsgroups for support; 11. Use string arithmetic; 12. Encrypt worksheet files for security; 13. Use the Subtotal function for ease of creating totals; 14. Edit with cut, copy & paste - advanced data exchange in Windows - the best tricks and techniques; 15. Build database queries, create and use Web queries; 16. Use VLookup and HLookup to deal with information in tables; 17. Protect the document to make it tamper proof; 18. Taking large amounts of data and manipulate it in a way that is easy for others to understand. Training will take place around Polokwane. Duration of the training: • Three (3) days per group. Training will be divided into four (4) groups of each contain fifteen (15) employees.

To view details
Subscribe Now!

2025-03-17 11H00

Импорт - Экспорт по стране ЮАР