ExcelLearn Consultancy

Gunakan excel untuk dapatkan keputusan samda 'Ok' @ 'KO'.

Simulasi Pricing Dengan Excel

Column E : Gunakan function 'Goal Seek' untuk dptkan figure di column F
Column K : Gunakan fungsi 'Roundup' untuk dapatkan exact bilangan carton
Column S : Gunakan fungsi 'IF Else' untuk dapatkan keputusan samada pricing is ok @ tidak

Assalamualaikum.

Q: How to identify duplicate serial numbers from 2 different set of data?

A: We can use multiple methods such as Vlookup, Conditional Formatting, Index Match Functions and etc to solve this but the most simplest method is using CONDITIONAL FORMATTING.

1. Highlight the data that we want to compare.
2. Go to 'Conditional Formatting'
3. Choose 'Highlight Cells Rules'
4. Choose 'Duplicate Values'
5. Assign the duplicate values with different font/cell colors for our easy reference.

Assalamualaikum

Track your income vs expenses with Excel

Attached is the simplest and easiest template created by one of ExcelLearn group members. It is simple but yet reliable.

To those who are new to Excel, you may try this to enhance your skill! ;-)

Assalamualaikum

Common Mathematical symbol used in Excel.