Course Description

Knowing more excel skills will definitely improve your speed when using excel in the workplace. Learn 50 cool tips that excel can do with this course and shine in your workplace.


This training will cover following topics:
1. Moving data
2. Copy an Excel sheet from one workbook to another
3. Copy Excel data into word and powerpoint
4. Line break and wrap text
5. Auto format
6. Screenshot insertion
7. Input same data in multiple cells
8. Scale to fit
9. Shrink to fit data
10. Hide data in plain sight
11. Tilt your text
12. Bullets
13. Strikethrough
14. Copy format to multiple cells
15. Fill series
16. Flash fill
17. Paste values
18. Paste special with formulas
19. Paste from clipboard
20. Status bar
21. Transpose to different orientation of table
22. Amend multiple cells with same data
23. Color Blank cells
24. Delete blank rows
25. Show graphics in chart
26. Prevent shifting of cell reference
27. New window for second view
28. Hyperlink to a website
29. Add check box
30. Add dropdown menus
31. Subtotal function to include or exclude hidden values
32. Copy and paste filtered data
33. Time stamp
34. now and today functions
35. Define Name
36. Entering leading zeroes
37. Custom format to read millions
38. Different colors for positive and negative numbers
39. Convert negative to positive number
40. Trim function
41. Replace function
42. Remove extra characters
43. Delete cells with same contents or format
44. Delete duplicates
45. Watch window
46. Camera
47. User form
48. Import pdf file
49. Speak cell
50. Faster way to add data