Introduction | Editing Sheet | Formatting | Project 1

Viewing worksheet | Filling series| Flash fill 

Conditional formatting- new rule | Data validation

VLOOKUP | HLOOKUP | Cell reference

Remove duplicate values | Hyperlink | Important functions in excel

Logical functions | sum | sumif | sumifs | count | countif | countifs

Statistical functions and mathematical functions | Date related functions 

Text functions in excel | Match and index functions 

Dsum| dcount | Subtotal functions 

Chart element | Pivot table and pivot chart 

Filter and advanced filter

Custom view | Graphics | Insert object

Header and footer | Print area setup | Text to column function

Introduction to Excel tools.