Let's start your journey to mastering excel! Learn to appreciate formulas!
Hello, My Name is Mubin Satopay and I am working on Microsoft Excel from several Years.

Please contact me if you need a free advise or help on a particular excel project.

Freeze panes | How to freeze panes in excel
2:32
Freeze panes | How to freeze panes in excel
Remove Duplicates | How to remove duplicate rows in Excel
2:32
Remove Duplicates | How to remove duplicate rows in Excel
Get a Name at Random from a List - Excel Formula
2:55
Get a Name at Random from a List - Excel Formula
UNIQUE | How to get unique values
1:36
UNIQUE | How to get unique values
Advanced Filters | How to use Advanced Filters in MS Excel
5:03
Advanced Filters | How to use Advanced Filters in MS Excel
Unable to Change Date Format in Excel ? You need to watch this | Microsoft Excel Tutorial
3:10
Unable to Change Date Format in Excel ? You need to watch this | Microsoft Excel Tutorial
Relative and Absolute Cell Reference | How to lock cell range
3:34
Relative and Absolute Cell Reference | How to lock cell range
Conditional Formatting| How to Highlight Entire Row in excel with conditional formatting
3:42
Conditional Formatting| How to Highlight Entire Row in excel with conditional formatting
HOW TO MAKE AUTOMATIC ATTENDANCE SHEET| Excel tutorial
17:44
HOW TO MAKE AUTOMATIC ATTENDANCE SHEET| Excel tutorial
Password protection| Locking & Unlocking cell
2:56
Password protection| Locking & Unlocking cell
XLOOKUP | Microsoft Excel | Look up Function
3:59
XLOOKUP | Microsoft Excel | Look up Function
Conditional Formatting | Sparklines|Excel Reports
6:31
Conditional Formatting | Sparklines|Excel Reports
Transpose Function in excel
1:49
Transpose Function in excel
TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin
2:54
TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin
Conditional Formatting in Excel
3:26
Conditional Formatting in Excel
Excel Forumla Left, Right, Mid
4:13
Excel Forumla Left, Right, Mid
How to use the REPLACE formula| advanced excel tutorial
2:26
How to use the REPLACE formula| advanced excel tutorial
SUMPRODUCT Formula | advanced excel tutorial
3:15
SUMPRODUCT Formula | advanced excel tutorial
How To Convert Negative Values To Positive Values Using Microsoft Excel
1:25
How To Convert Negative Values To Positive Values Using Microsoft Excel
How to use Excel Index Match
9:46
How to use Excel Index Match
CORREL Excel Function | Formula | How to Calculate Correlation in Excel?
3:13
CORREL Excel Function | Formula | How to Calculate Correlation in Excel?
Google Forms Full Tutorial From Start To Finish - How To Use Google Forms
9:43
Google Forms Full Tutorial From Start To Finish - How To Use Google Forms
HOW TO SUM & COUNT WITH MORE THAN 1 CRITERIA | SUMIFS & COUNTIFS
6:46
HOW TO SUM & COUNT WITH MORE THAN 1 CRITERIA | SUMIFS & COUNTIFS
HOW TO FORECAST YOUR SALES AND EXPENSES USING EXCEL FORECAST FORMULA (HISTORICAL DATA)
3:57
HOW TO FORECAST YOUR SALES AND EXPENSES USING EXCEL FORECAST FORMULA (HISTORICAL DATA)
How to find length of the word in a cell using LEN formula
2:08
How to find length of the word in a cell using LEN formula
How to create HYPERLINK in Excel
2:40
How to create HYPERLINK in Excel
How to convert a number from one measurement system to another.
3:32
How to convert a number from one measurement system to another.
EXCEL FORMULA SUBTOTAL
3:49
EXCEL FORMULA SUBTOTAL
Excel Function TEXT TO COLUMN
3:35
Excel Function TEXT TO COLUMN
EXCEL FORMULA RANDBETWEEN
1:42
EXCEL FORMULA RANDBETWEEN