skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

This course is self taught.

Bookings cannot be made on this course (Course is not taking bookings).



Booking / availability

Excel 2007: Level 1 (Win) (workbooks)


Description

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.

Prerequisites

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.

Topics covered
  • 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
Objectives
  • 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
Themes

Booking / availability

Override user: