Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
This is a foundation course in Excel suitable for beginners and for people who have been using Excel for a while and want to refresh their understanding of the basics of Excel. You will learn how to edit and view an Excel worksheet: navigate the sheets, learning common functions and how to write basic formulas.
WHO SHOULD ATTEND:
People who need to use Excel in their work. This is a foundation course in Excel suitable for beginners and for people who have been using Excel for a while and want to refresh their understanding of the basics of Excel.
WHAT YOU WILL GAIN:
You will learn how to edit and view an Excel worksheet: navigate the sheets, learning common functions and how to write basic formulas.
PROGRAMME OUTLINE:
Get started in Excel. The structure of an Excel spreadsheet. The Excel user interface.
Apply best practices for the start!
Cell references: relative, mixed and absolute references.
Write formulas In Excel.
Use Excel functions. A quick overview of many common and useful functions including:
• date functions e.g., TODAY, YEAR, MONTH, EDATE,
• maths functions e.g., SUM, COUNT, AVERAGE
• logical functions e.g., IF and IFS,SWITCH and CHOOSE
• general functions e.g., ISBLANK and CONCAT
Data validation and data entry; for example, how to create a list of items to use as a picklist and to identify and remove duplicates.