x

Choose Country Code

x

Direction

x

Ask a Question

x

Microsoft Excel Training Topics

Home > Study Notes > Microsoft Excel Training Topics

Published in: MS Office

371 Views

Live examples/exercises (in softcopy) will be given out to all students.

Alex K / Puchong

16 years of teaching experience

Qualification: CIMA

Teaches: MS Office

Contact this Tutor

Microsoft Excel Training Topics 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. Formula @vlookup @hlookup @right, @left @count @trim @sum @average,@max,@min @iserr, @isna, @isblank, @isref etc.. @round, @roundup & @rounddown fixed and variable cells definition in formulas @sumif or @countif Combination of cells (using &) Functions Pivot Table Format Painter Audit Trail Sorting Filter Arrange Windows (> one worksheet) Add/Remove Icon - Set Print Area Auto/Manual Calculation Sub-total Freeze Panel & Splitting Windows Grouping & ungrouping Cell Validation Protection (Cell,Worksheet & file) Graphical Presentation Copy Worksheet Copy & Paste Wrap & Merge Find & Replace Hyperlink