SHORTS
33 videos • 106 views • by Sobanan Knowledge Sharing
1
Excel Tips
Sobanan Knowledge Sharing
Download
2
EXCEL | IF FUNCTION | RANDOM SELECTION
Sobanan Knowledge Sharing
Download
3
EXCEL | OFFSET & SUM FUNCTION
Sobanan Knowledge Sharing
Download
4
EXCEL | LOWER, UPPER, PROPER FUNCTION
Sobanan Knowledge Sharing
Download
5
EXCEL | DAY, MONTH, YEAR FUNCTION
Sobanan Knowledge Sharing
Download
6
EXCEL |Concatenate & Ampersand | Join text
Sobanan Knowledge Sharing
Download
7
EXCEL | SUM OF TIME
Sobanan Knowledge Sharing
Download
8
EXCEL | FLASH FILL | CTRL + E
Sobanan Knowledge Sharing
Download
9
EXCEL | AUTO SUM | ALT + =
Sobanan Knowledge Sharing
Download
10
EXCEL | OFFSET, SUM FUNCTION
Sobanan Knowledge Sharing
Download
11
Automated Serial Number | IF Function
Sobanan Knowledge Sharing
Download
12
Combo box (Form Control) | Index Function
Sobanan Knowledge Sharing
Download
13
Comparison of 2 column | TRUE & FALSE | IF Function
Sobanan Knowledge Sharing
Download
14
Conditional Formatting - 01
Sobanan Knowledge Sharing
Download
15
Data Validation - Drop Down List
Sobanan Knowledge Sharing
Download
16
Date visual - different format
Sobanan Knowledge Sharing
Download
17
Index & Match Function
Sobanan Knowledge Sharing
Download
18
Indirect Drop Down List - Data Validation
Sobanan Knowledge Sharing
Download
19
Multiple if function | Random between function
Sobanan Knowledge Sharing
Download
20
Customize the Slicer - Dynamic chart using Slicer
Sobanan Knowledge Sharing
Download
21
Dynamic chart using Check box (Form Control)
Sobanan Knowledge Sharing
Download
22
Left Lookup using VLookup & Choose Function
Sobanan Knowledge Sharing
Download
23
Scroll bar (Form Control)
Sobanan Knowledge Sharing
Download
24
Pivot table Filter - Differentiate Max Column
Sobanan Knowledge Sharing
Download
25
Spin Button (Form Control)
Sobanan Knowledge Sharing
Download
26
Option button (Form Control) - MCQ Exam with immediate result
Sobanan Knowledge Sharing
Download
27
Running Clock in Excel
Sobanan Knowledge Sharing
Download
28
Stop Watch in Excel
Sobanan Knowledge Sharing
Download
29
20 Excel VBA Function | Color each selected Cell with different Color
Sobanan Knowledge Sharing
Download
30
Excel VBA Tips (Check them, Are you familiar to each one..)
Sobanan Knowledge Sharing
Download
31
Excel VBA Dictionary (the Result in MsgBox)
Sobanan Knowledge Sharing
Download
32
Excel VBA Goal Seek (What's your goal bro)
Sobanan Knowledge Sharing
Download
33
Color Count Function - Excel VBA Color
Sobanan Knowledge Sharing
Download