MS EXCEL SYLLABUS

MS EXCEL SYLLABUS
Introducing Ms- Excel as spreadsheet and uses of that package
How to open/close Ms.-Excel
Introducing Ms excel futures
How to enter text and number in worksheet How to introduce formula in worksheet (adding, subtracting, multiplication, division, etc
 How to copy formula on a given range …selected functions (sum, average, maximum, minimum, if messages ,grading, etc )
 How to move columns and rows by range
 Naming ranges
 Column and rows (hide unhide, width and height, AutoFit etc )
 Formatting cells ( as numbers general numbers and as currency )
Alignment (text control and orientation ) Font
(Font style, font size, underlining, effects
 How to display formula and gridline and how to remove it.
 How to format and create various chart adding range in Existing chart,
 How to create chart having different location of range..
 Data base management (sorting data ascending/descending, filtration)
 Validation and comments
 How to add and remove sheet
 Renaming sheet , Making copy of sheet
 Protect sheet as read only protect part sheet ,protect work book as open password)how to remove password
 Drawing, inserting, objects picture etc
Final examination