Duration

1 day

Aim

Need to build your confidence and skills in Microsoft Excel? This is the workshop for you. The workshop will build your confidence and skills allowing you to successfully navigate worksheets and workbooks with an introduction to some of Excel’s functions that will make life and Excel easier.

In addition to this you will know how to construct and understand simple and the more complex formulas, without being intimidated or confused. You will then be able to present a professional spreadsheet confident in your ability to have saved time, effort and frustration.

Target Audience

Microsoft Excel 2003, Level One is designed for users who are keen to extend their understanding and knowledge of the software.

Prerequisites

Microsoft Excel 2003, Level One assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Content

 Excel 2003 Orientation  A Simple Workbook  Working With Workbooks  Working With Worksheets  Viewing Worksheets  Formulas  Adjusting A Worksheet  Printing  Sorting  Copying And Filling  Working With Functions  Selecting Ranges  Formatting Cells

Course Objectives

At the completion of this course participants will be able to:

 start Microsoft Excel, navigate workbooks, and exit correctly  create, modify, save, and close a simple workbook  work with one or more workbooks at once  use a range of techniques to work with worksheets  use a variety of viewing techniques to view worksheets  adjust the sizing of columns and rows in a workbook  create formulas that perform calculations in a workbook  create and work with functions in a workbook  select ranges of cells in a workbook  format cells in a workbook  copy and fill data in a workbook  sort data in lists in a workbook  print data in a workbook

Course Outline