This course is for : beginner

Average time Duration : 2 Month (2hrs/day)

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world.

Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.

Course Outline

  1. Identify the different components of the Excel worksheet.
  2. Differentiate between an Excel workbook & worksheet.
  3. Use the Office Assistant
  4. Open an existing workbook and create a new workbook
  5. Enter text and formulas in to an Excel spreadsheet
  6. Enhance alpha and numeric date in an Excel Worksheet
  7. Move & Copy alpha and numeric data
  8. Construct formulas to manipulate numeric data in an Excel Worksheet
  9. Create a spreadsheet to tabulate and record numeric values.
  10. Change the appearance of an Excel spreadsheet
  11. Use the print function to create a printable copy of data stored on an Excel spreadsheet.
  12. Set up the chart function of Excel to represent numeric data in multiple formats.
  13. Differentiate between formulas and functions in Excel.
  14. Use at least four functions that are stored in Excel.
  15. Access and manipulate data using the database functions of Excel.
  16. Create simple & complex macros in Excel.