Microsoft Excel Syllabus

Excel-Ist Session

A. How to protect the sheet

B. Using the pick from drop down list option

C. Using auto complete feature

D. Using fill option

E. Using move or copy option

Excel-IInd Session

A. Set the page setup, Print Area & Print Preview.

B. Set the Page Break Preview.

C. How to print the sheet.

D. Applying the Header and Footer Option.

Excel-IIIrd Session

A. Inserting the row , column or worksheet

B. Inserting the picture

C. How to merge the cells

D. Apply the charts

E. Using functions

F. Insert the comment

G. Applying Hyperlink or Bookmark

H. How to Format the cell or Sheet

I. How to Rename, Hide and Background the sheet.

J. How to apply conditional formatting.

Excel-IVth Session

A. How to apply Track Changes

B. How to use Freeze panes option.

C. Using Goal Seek option

D. How to use Scenario’s

E. How to apply the Sorting.

Excel-Vth Session

A. Using Form and Filter option

B. Using Subtotal option.

C. Using Data Validation Option

D. How to apply Pivot Table

E. Ho to apply Group or Ungroup Option

Excel-VIth Session

A. Using VLookup & HLookup

B. Applying Advance Filter & Sorting