Course Modules
INroduction of MS Excel's Environment, WHich includes RIbbon,TAB,GROUP, FOrmating, CUstomization of Toolbar e.t.c
- Relative Cell Referencing in Excel
- Absolute Cell Referencing in Excel
Their definition & use with example.
- Mathmatical function
- Common function
- Logical
- Conditional
- String
- Date TIme
- Data Visualization with Chart
- Vllokup
- Pivot table
- e.t.c
- Sorting & Filtering in Excel
- Data Validation & VLOOKUP
- Pivot Table & Pivot Chart
- Perfect Printing