Learning objectives

When you have completed this course, you will be able to:

• Open and close Excel and use the Help features
• Understand the basic Excel 2010 screen and its components
• Use techniques to navigate Excel workbooks and its associated worksheets
• Personalise Excel to suit your own requirements by changing zoom magnification, splitting windows and freezing panes
• Create new workbooks and enter and edit data in worksheets
• Open existing workbooks and move between them
• Save workbooks in different file formats so people with earlier versions of Excel or other applications can open them
• Use some of the more common selection methods in Excel to ensure fast ways to select data saving you time and effort when creating large worksheets
• Move and copy data using the ribbon buttons, ‘right-click’ menu, and shortcut keys
• Insert, delete columns and rows and adjust the width of columns and the height of rows
• Locate specific data within a worksheet using the ‘Find’ and ‘Replace’ commands and identify Search Options
• Sort data alphabetically, numerically using the ‘Sort’ feature change the appearance of a worksheet by modifying various formatting features such as font styles and sizes, data alignment, currency symbols, decimal placing
• Work with multiple worksheets, including deleting, inserting, moving, copying, renaming tabs and applying a colour to worksheet