This one-day course has been designed for new users to Excel who need to understand the basic fundamentals.
By the end of the course, you will be confident in using the essential features of Excel to create and alter simple spreadsheets, using formulae
Microsoft Office 2010 / 2013
Starting Excel | Understanding the Excel program screen | Understanding the Ribbon | Using the Office button and Quick Access toolbar | Using keyboard commands | Using contextual menus and the mini toolbar | Using Help | Exiting Excel
Creating a new Workbook | Opening a Workbook | Navigating a Worksheet | Entering labels | Entering values | Selecting a cell range | Overview of formulas and using AutoSum | Entering formulas | Using AutoFill | Understanding absolute and relative cell references | Using undo and redo | Saving a Workbook | Previewing and printing a Worksheet | Closing a Workbook
Editing cell contents | Cutting, copying, and pasting cells | Moving and copying cells using the mouse | Using the Office clipboard | Inserting cells, rows and columns | Deleting cells, rows and columns | Using find and replace | Using cell comments
Formatting labels | Formatting values | Adjusting row height and column width | Modifying cell alignment | Adding cell borders, background colour and fill pattern
Creating a chart | Resizing and moving a chart | Changing chart type | Applying built-in chart layouts and styles