Microsoft Excel 2003 Level 1

Who should do this course?

This course is primarily designed for people who need to know how to use Microsoft Excel. It is ideal for people who need to produce reports, budgets, lists and the like. No prior knowledge of Microsoft Excel is required, however it would be beneficial to have a general understanding of personal computers and the Windows operating system.

About the course:

The skills and knowledge are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists.

Learning outcomes:

Upon successful completion of this course, students will be able to:

• work within the basic Excel environment
• create a new workbook
• open and navigate within workbooks and worksheets
• make changes to data in a workbook
• understand, create and work with formulas and functions used to perform calculations
• understand and use formula cell referencing to create more complex formulas
• understand and work with ranges in a worksheet
• copy and paste data in Excel
• use font formatting techniques to greatly enhance the look of a worksheet
• align the contents of cells in a number of ways * format rows and columns in a worksheet
• understand and use the number formatting features in Excel
• print your workbook data
• create effective charts in Microsoft Excel