Loading Events

Microsoft Excel 2007-2016 Level 1

Duration

1 Day

Prerequisites

This course is intended for those who have little or no experience of Microsoft Project. Delegates should have basic experience of working with a mouse and the Windows environment.

Course Type

Instructor-led hands on training with all delegates using a computer

Course Objectives

To provide delegates with a basic introduction to Excel, to demonstrate its ease of use and to enable delegates to use a spreadsheet with confidence and understanding.

Course Content

The Excel Interface

• Microsoft Office Backstage view
• The Quick Access Toolbar
• The Ribbon, Ribbon Tabs Ribbon Groups
• Customising the Ribbon
• Dialog launchers
• Contextual tabs

Creating Workbooks

• Entering Text and Numbers
• Entering and copying Formulae
• Using AutoSum
• Saving a Workbook
• Print and Preview Options
• Using different views

Editing Workbooks

•Open an Existing Workbook
• Moving around the Worksheet
• Selecting cells
• Editing and Deleting cell contents
• Copying and moving data
• Protecting Worksheets
• Freeze Panes

Formatting Cells

• Applying Font Formats
• The Mini toolbar
• Live Preview
• Apply Number formats
• Align Text
• Handling Percentages and dates

Working with Columns and Rows

• Changing Column widths
• Changing Row height
• Autofit columns and rows
• Insert and delete columns and rows

Creating Charts

• Creating a Chart
• Formatting Chart Objects
• Printing Charts

Download Course Outline