Introductory

Microsoft Excel 2003/2007/2010

Introductory Level

The course is designed to give delegates an introduction to Microsoft Excel, covering the basic concepts of spreadsheets, showing the user how to build formulae, thus creating fully functional financial spreadsheets.  By the end of this course, delegates will be able to build, use and manipulate data in a spreadsheet using Microsoft Excel for Windows.

Pre-Requisite:  Delegates attending this course should be already working with Microsoft Excel and wish to expand their knowledge, or should be about to commence using Microsoft Excel, or are converting from another Electronic Spreadsheet package.

Duration:           1 Day

A first look at Excel
  • The advantages of using Excel
  • What are workbooks and worksheets?
  • Creating and opening workbooks
  • Entering data
  • Further data entry techniques
  • Autocorrect
  • Autocomplete
  • Using the pick list
  • Navigating in the worksheet
  • Selecting items within Excel
  • Inserting and deleting cells, rows and columns
  • Saving workbooks
  • Moving between worksheets
  • Using the spelling checker
  • Closing an Excel workbook
  • Exiting Excel?
 A closer look at the Excel screen
  • The standard toolbar
  • The formatting toolbar
  • Selecting worksheet views
  • Undo and repeat
  • The office assistant?
 Formatting and customizing data
  • Formatting options within Excel
  • Alignment
  • Data indentation and rotation – introduced with Excel
  • To center items in a cell/cells
  • Using fonts
  • Formatting numbers
  • Decimal places
  • Formatting columns and rows
  • Deleting cells, formats, objects and worksheets
  • Adding, editing and removing borders
  • Using Autoformat
  • Copying data
  • Copying data using drag and drop
  • Copying columns and rows?
Formulas, functions and named ranges
  • Formulas
  • Operator evaluation order within Excel
  • Functions
  • Using the sum function
  • Other commonly used functions
  • Using paste function
  • Naming cells and ranges
  • Using named ranges with formulas?
 Introducing charts
  • Creating a chart
  • Moving, re-sizing and deleting charts
  • Changing the chart type
 Printing
  • Page setup
  • Margins
  • Centering printed output
  • Headers and footers
  • Sheet printing options
  • Choosing a printer and changing settings
  • Printing a worksheet
  • Printing multiple files