بسم الله الرحمن الرحيم
Assalamualaikum wbt. Didoakan agar para pembaca sentiasa sihat dan dilimpahi rahmat oleh Allah S.W.T InshaaAllah. Entry saya kali ini adalah tentang kuliah yang telah saya pelajari dalam Aplikasi Komputer iaitu tentang penggunaan Microsoft Excel dan Word.
Microsoft Excel 2013/2016
Ada bermacam yang saya pelajari di dalam excel, tetapi penerangan entry ini adalah lebih kepada penggunaan Vlookup Function dan If Function.
Vlookup Function
▪Unlike using VLOOKUP with the optional = 0 to return a true value, here we will get a value between 2 slices of values.
▪Take for example the case of compensation for a commercial company.
▪In the following document, you show the percentage of commissions paid by volume of sales.
▪As there is little chance the sales volume achieved by the commercial falls exactly on one of values in table, set up a search on exact value (optional parameter to 0) makes no sense.
▪Here, we want to return a value between 2 slices. So, in this case, we will use function VLOOKUP by approaching value.
Vlookup Function
▪Unlike using VLOOKUP with the optional = 0 to return a true value, here we will get a value between 2 slices of values.
▪Take for example the case of compensation for a commercial company.
▪In the following document, you show the percentage of commissions paid by volume of sales.
▪As there is little chance the sales volume achieved by the commercial falls exactly on one of values in table, set up a search on exact value (optional parameter to 0) makes no sense.
▪Here, we want to return a value between 2 slices. So, in this case, we will use function VLOOKUP by approaching value.
IF Function
▪The IF function is used when you have to display different result in function of values of other cells.
The IF function needs 3 parameters
1) The TEST
2) The result if the TEST is TRUE
3) The result if the TEST is FALSE
3) The result if the TEST is FALSE
Microsoft Word 2013/2016
Manakala penggunaan Word pula dalam entry ini adalah bagaimana untuk menggunakan mail merge. Use mail merge to create and send bulk mail, labels, and envelopes
Mail Merge Process
1) The mail merge process has three documents involved in creating and printing letters and emails, or labels and envelopes.
2)Your main document
This document contains text and graphics (a logo or an image, for example) that are identical for each version of the merged document. An example of identical content is the return address on the envelope or in the body of a letter or an email message.
3)Your mailing list
This document contains the data that is used to fill in information in your main document. For example, your mailing list contains the addresses to be printed on the labels or envelopes.
4) Your merged document
This document is a combination of the main document and the mailing list. Information is pulled from your mailing list and inserted in your main document, resulting in the merged document—the letter, email, labels, or envelopes—personalized for different people on the mailing list.
Okay selesai sudah perkongsian kali ini, semoga bermanfaat dan semoga bertemu di entry yang lain pula. Assalammualaikum.
IN THE SOCIAL AGE KNOWLEDGE IS ONLY POWERFUL IF YOU SHARE WHAT YOU KNOW
No comments:
Post a Comment