Introduction to Microsoft Excel

Opening Excel Various Methods,Number of Columns & Rows, Cells

Toolbar, Ribbon, Tabs, Groups, Features

Various Methods of Sheet navigation

Basic and frequently used shortcuts

Freezing Panes

Referencing Techniques: Relative & Absolute Referencing

Referencing Techniques: Partial Referencing

Basic Arithmatic Functions: COUNT v/s COUNTA & COUNTBLANK

Basic Text Functions: Basic Arithmatic Functions: SUM, AVERAGE, MIN, MAX

Basic Text Functions: CONCATENATE & operator, LEN , EXACT, LEFT, RIGHT, MID

Basic Text Functions: UPPER, LOWER, PROPER

Excel Assessment