Santa Clara University

Spreadsheets

Up and Running with Excel 2003

Do you need to get up and running with Excel 2003 fast? Do you have a project in mind or just need to understand how to create and format a spreadsheet? Do you need to create a graph of your data? Then this hands-on Excel basics class is just for you! Preview Class Handout »

• Understand the Excel Workbook
  Use: the menu bar, the Excel tool bar, the formatting tool bar, the formula bar; learn cell addresses, enter text and numbers into cells.
• Creating an Excel Worksheet
  Enter data, format cells, use the Auto Fill handle, center a title, insert and delete rows and columns
• Working with Formulas
  Use the AutoSum function, copy formulas, working with absolute cell addresses, Enter formulas using cell addresses.
• Format your Worksheet
  Add borders and shading, Add headers and footers, format numbers, merge cells, wrapping and shrinking text in a cell, format fonts, borders and shading, name your worksheets.
• Create a Chart
  Use Chart Wizard to create a graph, customize your graph.
• Use Page Setup

Prerequisites:

Familiarity with Windows is strongly recommended. Skills that will be used include cutting, pasting, inserting, resizing objects, etc.

Intended audience:

Faculty, Staff, Students