Archive for Office
You are browsing the archives of Office.
Mail Merge Dengan Word and Excel
Mail merge di Microsoft Word memang banyak berguna untuk pekerjaan sehari-hari, terutama yang berprofesi sebagai administrator dan sekretaris. Sayangnya pengisian database di Word menggunakan Wizard kurang nyaman dan terorganisir.
Let’s say kita akan membuat sebuah surat sederhana. Ikuti langkah-langkah ini, kemudian anda bisa berimprovisasi setelah memahaminya.
Di Microsoft Word ketiklah surat seperti ini (cukup copy paste ke [...]
Logics in Microsoft Excel
Level Easy
Ver Excel 2000 or above
Microsoft Excel has built in Logic Function like NOT, AND, OR. Observe the picture below.
Look at Cell D5, the formula is =NOT(A5>60). Cell A5 is NOT smaller than 60. Is it True? TRUE
Look at Cell D6, the formula is =AND(A6<=50,B6>=70). While B6<=70 = TRUE, A6<=65 = FALSE. Because the operator [...]
SUMIF and SUM
Level Easy
Ver Excel 2000 or above
SUMIF syntax =SUMIF(range, criteria, [sub_range])
Look at the picture below;
We can easily total it in Cell B8 with formula =SUM(B2:B7). The Total is 1727. But, what if we have to total each of the item? We need to know how much NP, how much Mag, and how much Tab.
The Formula for [...]
Page 1 of 1 1
