Sila swipe gambar untuk melihat outline

Apa yang akan dapat?

1. Class Recording streaming 90 hari
2. File Latihan (Excel dan Words)
3. Template Automation (File Jawapan)
4. Notes

TOPIC

1. FUNCTION & FEATURES
2. SUBSTITUTE
3. UPPER
4. TEXT
5. LOWER
6. TRIM
7. UPPER
8. FIND & REPLACE
9. LEN
10. TEXT-TO-COLUMN
11. SYMBOL &
12. MAIL MERGE
13. AUTOFILL
14. COPY AND PASTE
15. NAVIGATION SHORTCUT

1. AUTOMATED TEMPLATE
2. NAME FORMATTING
3. LOWER CASE
4. CAPITALIZE
5. UPPER CASE
6. TRIM SPACES
7. REMOVE BIN
8. REMOVE BINTI
9. REMOVE A/L
10. REMOVE A/P

1. IC NUMBER FORMATTING
2. COUNT DIGIT
3. REMOVE DASH
4. REMOVE SPACE
5. FORMAT 12 DIGIT
6. DASH FORMAT
7. SPACE FORMAT

1. PHONE NUMBER FORMATTING
2. SUBSTITUTE +60
3. SUBSTITUTE DASH
4. SUBSTITUTE SPACE
5. FORMAT +60
6. DASH FORMAT
7. SPACE FORMAT

1. ADDRESS EXTRACTION
2. DEFAULT SEPARATOR
3. CUSTOM SEPARATOR
4. SPACE SEPARATOR
5. ERROR TIPS

1. CERTIFICATE CREATION
2. COMBINE TITLE AND NAME
3. COMBINE NAME WITH IC
4. AUTO INSERT 20 NAME TO CERT

1. EMAIL EXERCISE
2. EMAIL FORMATTING
3. EMAIL EXTRACTION
4. CREATE OFFICE EMAIL