EXCEL - INTERMEDIATE

EPPD 1063

Bab 2 : Microsoft Excel Intermediate Formula

Dalam bahagian ini pula kami didedahkan kepada penggunaan Formula :

Vlookup(

Countif(

If(

If(and(

If(or(

Pivot Table

Selain itu kami juga mempelajari :

Enter formulas using Point mode

Apply the AVERAGE, MAX, and MIN functions

Verify a formula using Range Finder

Apply a theme to a workbook

Apply a date format to a cell or range

Add conditional formatting to cells

Change column width and row height

Check the spelling in a worksheet

Set margins, headers, and footers in Page Layout view

Preview and print versions of a worksheet