Form creation using Design View and Wizard

Query generation using Design View and Wizard

Report generation using Design View and Wizard

Concept of Workbook, Worksheet, Row, Column, Cell

Creating, Opening, Editing, Saving a Workbook

Changing Row and Column widths

Formatting cells

Different data types in Excel

Entering labels and values

Use of formulas – SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, CONCATINATE, AND, OR, NOT, RAND, SQRT, TDEVA