Excel 2007/2010/2013/2016 Introduction

Excel Introduction

Description

Designed for new users.

Pre-requisites

Basic keyboard and PC skills and a knowledge of the windows environment is assumed

Objectives

The aim of this course is to have the participant `up and running' immediately following a one day basic programme based upon their existing skills and future needs. At the end of the course the participant should be able to create a good selection of spreadsheets. This course will assist users to prepare for the Excel 2007 Core Microsoft Office User Specialist Exam.

What is a Spreadsheet?

The Excel Screen

The Ribbon

Moving around the screen

Selecting cells and ranges

Creating a Spreadsheet

Opening workbooks

Entering text and numbers

Saving workbooks/Save as PDF

Preview and print workbooks

Closing workbooks

Views

Normal

Page Layout

Editing a Spreadsheet

Deleting cell contents

Editing text and numbers

Copying/moving data/Pasting Options

AutoFill

Inserting and deleting rows and columns

Hiding rows and columns

Inserting, deleting, copying and moving worksheets

Inserting Symbols

Formatting

Apply font formats

Formatting ranges (currency, fixed etc)

Rotate and indent text

Modify cell size and alignment

Apply borders and shading

Formulae

Simple calculations

Copying formulae

Editing formulae

Absolute & Relative Formulae

AutoCalculate

Range Finder

Statistical Functions

AutoSum

Analysing Data using AVERAGE, MIN, MAX, COUNT and COUNTA

Function Wizard