Excelguru

Company Information

• Year Establish
• Description/Remarks MICROSOFT EXCEL 2007 PROFICIENCY (LEVEL 2) Course Duration: 2 Days This course is designed to provide delegates, with no or a limited understanding of spreadsheets, a background to allow them to use Microsoft Excel 2007 in a day to day environment. Course Material Includes: 1. Greyspace Training Manual Training Methodology: 1. Self Guided Training with Tutor Assistance Topics Include: 1. What is a spreadsheet 2. Problem solving using spreadsheets 3. Starting Microsoft excel 4. Workbooks 5. Office Icons 6. Menu Ribbon 7. Types of Cells 8. Understanding the Mouse cursers in Excel 9. Naming Spreadsheets 10. Inserting Spreadsheets 11. Moving Spreadsheet 12. Entering Data 13. Changing Spreadsheets 14. Deleting Spreadsheet 15. Saving Spreadsheet 16. Creating Formulas 17. Operator precedence (why formulae do not work properly) 18. Calculating percentages 19. Calculating averages 20. Using Relative and Absolute References 21. Troubleshooting Formulas 22. Spell Check 23. Using the following Max, Min, Count and Counta Formulae 24. Sorting Data 25. What-if Scenarios 26. Sub Totals 27. Outline Symbols 28. AutoFill 29. Character Map Symbols 30. Printing 31. Headers and Footer 32. Protecting Spreadsheets 33. Templates 34. Clipart 35. Testing and Validating Formulae Course Fee: R1490.00 MICROSOFT EXCEL 2007 ADVANCE (LEVEL 3) Course Duration: 2 Days This course is designed to provide delegates, with an understanding of spreadsheets, an advance skill set to allow them to use Microsoft Excel 2007 for data manipulation. Course Material Includes: 1. Greyspace Training Manual Training Methodology: 1. Self Guided Training with Tutor Assistance Topics Include: 1. Templates 2. Testing and Validating Formulae 3. Using the following functions: Date, Now, Today, Proper, Upper, Lower, Left, Right, Concatenate, PMT,IF,SumIf 4. Vlookup / Hlookup 5. Future Value 6. Goal Seek 7. Importing Data 8. Naming Cells 9. Conditional Formatting 10. Filtering Data 11. Charts/Graphs 12. Pivot Tables 13. Macro Course Fee: R1490.00