Msoffice

Syllabus of msoffice 

Introduction  to msoffice 

Msoffice  

Word

Excel

PowerPoint 

Access 

Word

Creating  documents, formats,pictures, labels envelopes, tables, 

Working with headers and footer ,border  and shading,,pagebreK, pagenumbers etc 

Working  with  mailmerge  macros, background and foreground  design

Working  with  templates  etc

Excel

Introduction  to excel 

Basic formula  used for working with excel 

Working with scenarios, datatable,data validation, consolidate  etc

Working  with  pivot table and pivot  chart 

Working with vlookup, lookup,hlookup etc

Working with formulas like sumifs,counting,countifs  averageifs etc

Rest of the formula  are covered in class 

PowerPoint

Introduction  to PowerPoint 

Uses of PowerPoint 

Creating slides,custom show setup show,slide sorter etc

Creating  presentations manual and automatic 

Creating  animations  in PowerPoint  for both page animations and text  animations 

Access 

Introduction  to access

Define  data,database 

Creating  a database 

Creating  different  types of forms,report, query etc