Wiki Sumber Informasi iSIKHNAS

Basic Excel Skills

Learning objectives

After completing this activity, you will:

• be able to apply the principles of good data management to design a simple data entry spreadsheet that is fit-for-purpose
• have mastered basic Excel data entry skills including:
  • creating and saving a new Excel workbook
  • entering information into a cell by typing
  • copying and pasting data
  • inserting a column or a row
  • moving items
  • clearing and deleting cells
  • setting cell data categories and formats (text, number, date)
  • setting cell appearance (font, highlight, styles, borders)
  • insertion of comments
  • insertion of illustrations.