Tuesday, April 21, 2020

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


Copying Cells – Relative and Absolute referencing


Making calculations and re-calculations


Conditional Formatting