Microsoft Excel Introduction

Microsoft Excel Introduction



Next Date



One Day

Microsoft Excel Introduction

Course Description

This one-day course has been designed for new users to Excel who need to understand the basic fundamentals.

Course Objectives

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

Course Content

Microsoft Office 2010 / 2013

The fundamentals

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

Worksheet basics

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 a Worksheet

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 a Worksheet

Formatting labels | Formatting values | Adjusting row height and column width | Modifying cell alignment | Adding cell borders, background colour and fill pattern

Introduction to Charting

Creating a chart | Resizing and moving a chart | Changing chart type | Applying built-in chart layouts and styles

Related courses

Microsoft Excel Intermediate

Microsoft Excel Advanced

Microsoft Word Introduction