TINJAUAN KURSUS
LEVEL 1: BEGINNER- FORMATTING
1. 15 Shortcut Keys for Beginners
2. How to add today’s date & current time
3. How to add quick date series
4. How to add quick days series
5. How to add quick number sequences
6. Seconds add Data Picker Calender (PREVIEW)
7. Transpose data
8. Copy & move worksheet
9. Add more data in one cell
10. Change title case
11. Freeze panes
12. Quick color scales-formatting colors
13. Paste Special…Values
14. Sort cells by colors
15. Insert 3D Model
LEVEL 2: INTERMEDIATE- FORMATTING
16. 10 Intermediate Keyboard shortcuts
17. Quick Fill in blank cells
18. Flash fill feature in Excel
19. Alternate to merging & centering cells
20. Create a table & format tables
21. Find & remove unwanted text (PREVIEW)
22. Highlight duplicates-conditional formatting
23. Percentage formatting cell
24. Quick move data rows up & down
25. Insert multiple rows in one click
26. Data Validation
27. Checklist strikethrough
28. Auto fill Email address
29. Remove background image
30. Shrink text to fit cell
31. Add background Image
32. Insert PDF data into Excel
33. Insert Data Bar
34. Split cell diagonally
35. Compare Differences
LEVEL 3: INTERMEDIATE - FUNCTIONS
36. Quick Auto Sum
37. Add or collapse formula breakdown
38. Percentage calculation (PREVIEW)
39. Mix & Max
40. Remove blank multiple rows in a data
41. Quick join text column
42. Repeat last format
43. Count function
44. Trim Function
45. Add bullet points in list
LEVEL 4: ADVANCED- FORMATTING
46. Adding Units custom format KG/ $
47. Custom numbers in Thousand (K) / Millions (M)
48. Create form for data entry
49. Rename formula heading
50. Insert data from Web
51. Collapse image on filter
52. Sparkline (PREVIEW)
53. Pivot Table
54. Slicer & Timeline Slider
55. Spin Button
LEVEL 5: ADVANCED- FUNCTIONS
56. Insert Subtotals (PREVIEW)
57.Concatenate() Function/ Join Text
58. Match Function
59. $-Fix Reference
60. IF..Function
61. SUMIF… Function
62. SUMIFS…Function
63. Convert Units
64. Find smallest Value
65. XLOOKUP
66. VLOOKUP
67. Refresh Pivot Table
68. Pivot Table Running Total
69. Custom with Indicator
70. Dynamic Calender
LEVEL 6: ADVANCED- CHARTS
71. Slicer with chart
72. Ring chart
73. Grouping Chart
74. Pivot Chart
75. Create Radio Button & Filter Chart
76. Vertical Bullet Chart
77. 3D glass chart (PREVIEW)
78. Geo Chart
79. Infographic
80. Dashboard
LEVEL 7: ADVANCED- GOOGLE SHEET
81. VSTACK Function
82. TOCOL Function
83. IF..Function
84. COUNTIF.. Function (PREVIEW)
85. Sparkline
86. Dropdown with Colors
87. Calender Dropdown
88. Split text
89. Google Translate
90. SheetGPT