Excel 2007: Level 1 (Win) (Workbooks)

Loan

The skills and knowledge covered in this book are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists. This book is primarily designed for people who need to know how to use Microsoft Excel 2007 is designed for people new to the Excel environment. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations and the like.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

Microsoft Excel 2007 Level 1 assumes no knowledge of the software or creating electronic worksheets and workbooks. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

• Getting To Know Excel
• Creating A New Workbook
• Working With Workbooks
• Editing In A Workbook
• Selecting Ranges
• Copying Excel Data
• Formulas And Functions
• Row And Column Formatting
• Number Formatting
• Font Formatting
• Printing
• Creating Charts

• 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 and work with ranges in a worksheet
• Copy and paste data in Excel
• Understand, create and work with formulas and functions used to perform calculations
• Format rows and columns in a worksheet
• Understand and use the number formatting features in Excel
• Use font formatting techniques to greatly enhance the look of a worksheet
• Print your workbook data
• Create effective charts in Microsoft Excel

Please refer to the information page for self-taught loan courses

• Roger Needham Building
• New Museums Site

Download Course Files