Course Description

Microsoft Excel 2007 Level 1 is part of a 3-Level study program for Microsoft Excel 2007. The course provides the learner with the skills and knowledge necessary, to create workbooks in Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting.

Outcomes

At the completion of this course, participants 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