Package Excel & GSheet
Uncategorized
About Course
RM429
- Bundle
- 2 Products
*Note: The price includes 8% SST
Related
Course Content
Microsoft Excel – Start Here!
-
Download Workbook
-
Join Whatsapp Support Group
Microsoft Excel Basic Level (100 minutes)
-
1 – Ribbon
-
2 – Worksheets
-
3 – Cursor
-
4 – Data
-
5 – Autofill
-
6 – Formula & Function
-
7 – Data Cleaning
-
8 – Table & Freeze
Microsoft Excel Intermediate Level (100 Minutes)
-
– Conditional Formatting
-
– Sort & Filter
-
– Absolute & Relative Reference
-
– Charts
-
– Vlookup
-
– XLOOKUP
-
– IF Function
Microsoft Excel Advanced Level (100 minutes)
-
– Pivot Table
-
– Linking.mp4
-
– Protection.mp4
-
– Consolidate.mp4
-
– VBA & Macros.mp4
-
– Dashboard Part 1
-
– Dashboard Part 2
-
– Dashboard Part 3
-
– Dashboard Part 4
-
– Dashboard Part 5
-
– Dashboard Part 6
Google Sheets – Start Here!
-
Download Workbook
-
Join Whatsapp Support Group
Basic
-
TOPIC 1-MENU
-
TOPIC 2 – MUKASURAT
-
TOPIC 3 – FORMULA & FUNCTION
-
TOPIC 4 – CURSOR
-
TOPIC 5 – AUTOFILL
-
TOPIC 6 – DATA
Intermediate
-
TOPIC 1 – TEMPLATE GALLERY
-
TOPIC 2 – TOP 10 SHORTCUTS
-
TOPIC 3 – SORT, FILTER, FREEZE
-
TOPIC 4 – CONDITIONAL FORMATTING
-
TOPIC 5 – PIE CHART
-
TOPIC 6 – COMBO CHART
-
TOPIC 7- 5 MUST KNOW FUNCTIONS
Advanced
-
TOPIC 1 – ABSOLUTE REFERENCE
-
TOPIC 2 – XLOOKUP
-
TOPIC 3 – PIVOT TABLES & CHARTS
-
TOPIC 4-LINKING DATA
-
TOPIC 5 – EXPLORE