MS office
MS%20office%202_edited.jpg

syllabus

Basic Excel:

Home:

  • Font formatting

  • Number formatting

  • Table formatting

  • Conditional formatting

  • Hide/unhide

  • Sort /filter

  • Paste special

  • Find and select

 

Insert:

  • Illustrations

  • Charts

  • Text

 

Pagelayout:

Basic functions:

  • Sum/ Average/ Count/ Max/ Min

  • Basic Text/date/time/lookup/information functions

  • Name manager

  • Formula Auditing

 

Data:

  • Import from web

  • Import from text

  • Text to columns

  • Remove duplicates

  • Grouping and ungrouping

 

Review:

  • Proofing

  • Comments

  • Protection

 

Views:

  • Types of views

  • Zoom

  • Windows

 

Developer:

  • Enable developer

  • Using checkbox/option buttons.