EXCEL INTRODUCTION 2010 LEVEL 1
Sales Ended
EXCEL INTRODUCTION 2010 LEVEL 1

Event Information

Share this event

Date and Time

Location

Location

Rombourne Business Centre

Merlin House

Langstone Business Park

Newport

NP18 2HJ

United Kingdom

View Map

Friends Who Are Going
Event description

Description

COURSE OUTLINE
Excel Introduction

This comprehensive introduction course in Excel teaches participants how to create and enhance spreadsheets, use charts, formulas and functions, and formatting a spreadsheet effectively.

This 1-day Excel Introduction course will assist delegates to develop their skills in creating and formatting professional looking spreadsheets

Course Content:

  • Screen layout & features
  • Using workbooks & worksheets
  • Navigating a spreadsheet
  • Highlighting cells and ranges of cells
  • Entering text and numbers
  • Best practice – avoiding the pit falls
  • Entering days and months using AutoFill
  • Resizing rows and columns
  • Inserting new rows and columns
  • Addition using AutoSum
  • Font type – Font size – Font colour
  • Bold - Italics - Underline
  • Align: Left – Centre – Right – Merge cells
  • Currency – Percentage - Decimals
  • Creating cell borders
  • Formatting cells as a date or time
  • Using print preview
  • Set up landscape & portrait
  • Scaling – adjust a print out size
  • Applying headers and footers
  • Saving – best practice
  • Creating a new folder or subfolder
  • Average, Maximum, Minimum and count formulae
  • Using absolute cell referencing
  • Sort alphabetically or numerically
  • Sort in Ascending or Descending
  • Creating a simple graph or chart
  • Format appearance & colour
  • Adding legends & data labels
  • Adding / removing data
  • Changing the chart type

Who should attend?

This course is designed for any delegates who would like to learn how to create, format a professional spreadsheet and learn how to use and create basic formulas and functions in a spreadsheet.

Share with friends

Date and Time

Location

Rombourne Business Centre

Merlin House

Langstone Business Park

Newport

NP18 2HJ

United Kingdom

View Map

Save This Event

Event Saved