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

Jom belajar excel smbil2 pkpb di rumah.

Belajar Excel online - Berkenalan dengan Excel Sesi 1 : Pengenalan mengenai excel kepada audiens yang baru nak explore excel. Excel ialah salah satu aplikasi di dalam microsoft office yang dibekalkan bers...

Q: How to grade student's carry marks automatically??

How to grade student's carry marks automatically?? Tutorial 9 App Grading

Assalamualaikum

Q: How to identify birth date from ID No.?

How To Identify Birth Date From ID No. Tutorial 8 App BirthDate

Assalamualaikum

SEDANG MENCARI KELAS EXCEL DENGAN HARGA BAJET??
Jika YA, kami boleh bantu anda! EziDatabaseServices menyediakan kelas pembelajaran dari level BASIC, INTERMEDIATE dan ADVANCE untuk Eksekutif, Guru, Penganalisa Data, Penganalisa Bisnes, Konsultan, Pelajar, Dan Orang Perseorangan dgn harga BAJET.
Jadi, apa tngu lg?? jom join kelas EXCEL ini dan UPGRADE SKILL anda!!
KELAS MICROSOFT EXCEL-PENYELESAIAN DI HUJUNG JARI ☝

📆: 30hb September 2017
📌: MPWS Training Center, Seksyen 7, Bandar Baru Bangi, Sel.
📅: 9am-4pm
💰RM50 SAHAJA seorang‼
Organizer: EziDatabaseServices (002650705-H)

📝 Semasa kelas,anda akan didedahkan dengan formula:
✅ Date & Time - Cth: Today
✅Math & Trigo - Cth: Sum, Power, Product,SumIf
✅Text Function - Cth: Mid,Left & Right, Proper, Concatenate
✅Statistics - Cth: Count, Average, Min, Max, Countif
✅Logical - Cth: And, If , Or
✅Lookup & Reference - Cth: Vlookup,Hlookup,Index,Match

Special session untuk peserta2!!
✅Belajar membuat aplikasi mudah
✅2 ways discussion tentang permasalahan kerja anda

📞 Hubungi
Fisza - 0179877069

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

Refresh3x..

How to eliminate dash sign in identification card no. Tutorial 2_App_ Eliminate Dash Sign

Assalamualaikum.

Soalan simple yg kami terima hari ini dari group;

How do we exclude certain objects from being print out together with required data? Ex: Refer green object in the pic.

Answer:
1) Right click on the object
2) Choose 'Size and Properties'
3) Then choose 'Properties'
4) Untick the box of 'Print Object'
5) Done!

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

Let's refresh what we have learned previously. This info is very basic but yet important.

How to insert zero in front of phone numbers in Excel Tutorial 1 - Basic Excel's Applications

Assalamualaikum.

Again on macro.

Assalamualaikum.

Alhamdulillah...Part 3 Ezi Account System

*Rekod Transaksi Hutang (Belian)

Tujuan:
Merekod transaksi belian hutang bagi usahawan2 kecil yang seterusnya memparkan untung rugi dan penyata imbangan (balance sheet ;-)) sesuatu akaun company.

Next>> Rekod Transaksi Hutang (Belian Aset)

Assalamualaikum

Common Mathematical symbol used in Excel.