basic excel

Objective : To learn the basic functionalities available in MS Excel
Suitability : Entry level executives
Prior excel background : No prior excel background is required.
Duration: : 10 Hours or 1½ Day
Functionalities Covered :
  • Introduction to excel environment - workbook, worksheet, rows, columns & cells
  • Cell numberformats
  • Fill and Fill handle
  • Navigating shortcuts
  • Sort
  • Filter
  • Paste - special
  • Go to and go to special
  • Calculator
  • Format painter
  • Functions - sum, count, max, min, average, median, round, today, now
  • Find and replace
  • Printing
  • Charts
  • Name
  • Freeze panes
  • Saving workbook - different formats