Krystal Calc

Course

Total duration: 3 hours

User Interface & Language Setting
5:04
01 User Interface & Language Setting Free
Basic Function
5:27
02 Basic Function
Field Settings
5:53
03 Field Settings
Automatically Generate Sequence
6:30
04 Automatically Generate Sequence
Create Formula
7:22
05 Create Formula
Freeze Rows
4:51
06 Freeze Rows
Data Sort
5:19
07 Data Sort
Data Filter
4:02
08 Data Filter
Formatting Conditional
8:16
09 Formatting Conditional
Worksheet Setting
4:36
10 Worksheet Setting
Chart
7:20
11 Chart
Pivot Table
6:15
12 Pivot Table
Print Setting
6:58
13 Print Setting
Insert Background Image
4:23
14 Insert Background Image
Quick Selection
5:28
15 Quick Selection
Protect Sheet
4:44
16 Protect Sheet
Find Duplicates Data
2:49
17 Find Duplicates Data
Capture Web Data
4:28
18 Capture Web Data
Common Function
4:47
19 Common Function
Function VLOOKUP
10:42
20 Function VLOOKUP
Function IF
5:46
21 Function IF
Function COUNT IF
9:00
22 Function COUNT IF
Function RANK
4:04
23 Function RANK
Function Extraction Cell
6:11
24 Function Extraction Cell
Function RANDBETWEEN
4:11
25 Function RANDBETWEEN
Function AND & OR
7:06
26 Function AND & OR
Function SUMRODUCT
4:47
27 Function SUMRODUCT
Function SUMIF
2:47
28 Function SUMIF
Function CONCAT
6:56
29 Function CONCAT
Function OFFSET
3:53
30 Function OFFSET
Function DSUM
3:48
31 Function DSUM
Function DGET
3:09
32 Function DGET