Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Ultimate Microsoft Excel Programme for Industrial (Zero-to-Hero)
Chapter 1 - Get started
1A Introduction - Start Here! (1:19)
1B Interface (2:21)
1C New Workbook (0:34)
1D Open Existing Workbook (0:33)
1E Save Workbook (1:04)
1F Cell Address (0:34)
Chapter 2 - Font and Cell Formatting, Copy, Paste, Duplicate
2A Data Entry and Edit (1:19)
2B Font Setting (0:24)
2C Cell Formatting (0:58)
2D Copy Paste (1:27)
2E Cut Paste (0:30)
2F Duplicate (0:18)
2G Autofill (1:07)
2H Troubleshoot - Cursor (0:54)
2I Track Changes (0:37)
Chapter 3 - Worksheet Settings
3A New Worksheets (0:30)
3B Rename Worksheets (0:36)
3C Worksheet Tab Color (0:31)
3D Move workbook (0:39)
3E Copy workbook (0:31)
3F Hide Worksheet (0:33)
Chapter 4 - Worksheet Accessibility
4A Column Width and Row Height (0:46)
4B Hide and Unhide Row and Column (0:46)
4C Split Panes (0:50)
4D Zoom (0:33)
4E Freeze Pane (1:07)
4G Watermark (1:37)
4F Background (0:43)
Chapter 5 - Data Formatting
5A Data Formatting (3:04)
5B Date Format - Practice (0:56)
Chapter 6 - Condition Formatting
6A Conditional Formatting (3:53)
6B Remove Duplicate (0:36)
Chapter 7 - Compare, Combine, Replace, Comment
7A Data Comparison (1:13)
7B Data Combination (3:41)
7C Find and Replace (0:42)
7D Add Comment (0:42)
Chapter 8 - Text Import and Text Handling
8A Import Text (0:57)
8B Trim (1:20)
8C Text To Column (1:49)
Chapter 9 - Insert Picture and Table
9A Insert Picture (0:57)
9B Insert Table (1:03)
9C Slicer (1:52)
9D Data Validation (7:15)
Chapter 10 - Rounding, Sorting, Filtering, Combine
10A Number Rounding (2:09)
10B Sort & Filter (2:18)
10C Data Consolidation (3:24)
Chapter 11 - Concept of Formulas
11A Cell References (2:28)
11B Basic Calculations (3:31)
11C Range Name (2:38)
11D Array Formula (1:14)
11E Practice-Basic Calculation (1:43)
Chapter 12 - If, And, Or, Min, Max
12A If (1:19)
12B Nested If (1:28)
12C IFS (1:13)
12D Count If (1:54)
12E And & Or (2:20)
12F Min & Max (1:00)
Chapter 13 - Lookup Functions and Linkage
13A VLookup (2:57)
13B HLookup (2:26)
13C XLookup (2:23)
13D Unlink Reference (1:24)
13E Goal Seek (2:33)
Chapter 14 - Charts
14A Basic charts (3:49)
14B Treemap & Sunburst (5:11)
14C Histogram (1:54)
14D Box and Whisker (1:05)
14E Waterfall (1:23)
14F Funnel (0:57)
Chapter 15 - Pivot Table
15A Insert a Pivot Table (3:50)
15B Pivot Table setting (1:52)
15C Pivot chart (1:53)
Chapter 16 - Data Grouping
16A Auto Outline (2:20)
16B Manual Outline (1:49)
16C Subtotal (3:19)
Chapter 17 - Macro
17C Update Settings (1:47)
17A Record Macro (5:04)
17B Run a Macro (0:44)
17D Delete Macro (1:00)
Chapter 18 - Workbook Protection
18A Protect workbook (5:01)
18B Editable Range (2:31)
Bonus Chapter - Display & Print Settings
19A View Layout (1:22)
19B Header & Footer (2:44)
19C Page Break (1:19)
19D Scale (2:04)
19E Margin (0:46)
19F Page Orientation (0:35)
19G Print Area (1:11)
Practical Chapter - 3 Real-life Cases
20A Practice1 - Backlog Report Matching (6:30)
20B Practice2 - Survey's Report Analysis (5:45)
20C Practice3 - Create Invoice From Sketch (26:26)
13A VLookup
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock