MS Excel 2007 Introduction (2 days)

Requires no experience of using Excel, just basic computing skills.

Basics
	Standard toolbar overview Formatting toolbar overview Data entry Block selection Copying data Moving data Inserting cells, rows and columns Deleting cells, rows and columns Resizing rows and columns Using the AutoFit facility Undoing and redoing operations Spell checking Printing a spreadsheet

Formatting
	Setting alignment Using cell shading Adding borders to cells

	Using Autoformat Number and date Formats Creating styles Applying styles Modifying Styles Using conditional formatting

Formulas
	Formulas How formulas work About cell references About Excel ranges Overview of functions Using the AutoSum facility Using the formula palette Using conditionals Statistical functions Financial functions Creating external references

Charts
	Creating a chart Setting chart options Editing chart elements Editing chart data Adding logos and graphics Printing charts

Productivity
	Creating reports Setting print options Creating custom lists AutoCorrect Password protecting documents Protecting worksheets Using hyperlinks Save As Web Page Web Page Preview