Excel Level 1

IT Training Solutions Limited
5.0
1 review
  • I enjoyed the training - the trainer was very helpful and positive, I never felt under pressure but thouroughly enjoyed the day. Would use again.
    ← | →

Short course

In Newcastle Upon Tyne and Washington

£ 165 + VAT

The best Excel courses

See all

See all

Description

  • Duration

    1 Day

This course will enable the delegate to gain a good general understanding of the main features of Excel, giving them the ability to produce their own standard spreadsheets, create their own formulae and format and print spreadsheets.

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
Cuthbert House, City Road, Newcastle Upon Tyne, NE1 2ET

Start date

On request
Washington (Tyne and Wear)
See map
Suite 13, Vermont, House Concorde, NE37 2SQ

Start date

On request

About this course

Previous use of a keyboard and mouse is assumed for this course. Delegates should have some working knowledge of using a Windows based PC or they should have completed the Introduction to Windows course. Delegates should feel at ease performing tasks such as arranging, sizing and switching between Windows.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • I enjoyed the training - the trainer was very helpful and positive, I never felt under pressure but thouroughly enjoyed the day. Would use again.
    ← | →
100%
5.0
excellent

Course rating

Recommended

Centre rating

Kierra Desomme

5.0
15/06/2010
What I would highlight: I enjoyed the training - the trainer was very helpful and positive, I never felt under pressure but thouroughly enjoyed the day. Would use again.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Course programme

Course Overview

This course will enable the delegate to gain a good general understanding of the main features of Excel, giving them the ability to produce their own standard spreadsheets, create their own formulae and format and print spreadsheets.
Prerequisites
  • Previous use of a keyboard and mouse is assumed for this course.
  • Delegates should have some working knowledge of using a Windows based PC or they should have completed the Introduction to Windows course.
  • Delegates should feel at ease performing tasks such as arranging, sizing and switching between Windows.


Objectives


    Delegates will be able to :
  • Create a spreadsheet that will contain data. Navigate the spreadsheet using keyboard shortcuts. Add a New Column and Rows and saving the spreadsheet to their own folder.
  • Create and format a spreadsheet using the main features of the Formatting toolbar to change the appearance of the spreadsheet.
  • Performing the following calculations on a range of numbers, addition, subtraction, multiplication and division.
  • Use the following 5 Functions on a range of numbers to speed up basic calculations : Sum, Average, Count, Min, Max.
Follow on Courses
  • Excel Level 2
  • Excel Level 3
Training Options
  • Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
  • Scheduled public course at one of our training venues
  • Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
Whats Included
  • 1 delegate per computer
  • 12 Months telephone and email support
  • Comprehensive colour course manual and exercises
  • Use of a Modern Training suite with 19 inch flat screen monitors
  • Lunch (When at our training venue)
  • Refreshments (When at our training venue)
  • Relaxed refreshment area at our training room
Course Content
Starting Excel
  • The Excel screen
  • Exiting Excel
  • Opening Excel from the desktop
  • Opening Excel from the start menu
Workbooks
  • Closing a workbook
  • Opening a workbook already created
  • Saving a workbook
  • Creating a new workbook using a predefined solution
  • Creating a new workbook
Screen options
  • Changing the view options for Excel
  • Moving toolbars
  • Zooming in and out
  • Viewing different toolbars
Entering information onto a worksheet
  • The undo/redo buttons
  • The fill handle
  • Editing the contents of a cell
  • Inputting dates and times
  • Entering numbers as text
  • Entering text and numbers
Navigating a worksheet
  • The goto command
  • The scroll bars
  • Using the Keyboard
Inserting & deleting columns & rows
  • Hiding and unhiding columns and rows
  • Adjusting column widths and row heights
  • Deleting columns and rows
  • Inserting columns and rows
Ranges
  • Highlighting the entire worksheet
  • Selecting an entire column and row
  • Selecting more than one range
  • Selecting a range of cells
Formatting a worksheet
  • Applying formats using the keyboard
  • Clearing cells (removing formats)
  • Using the format painter
  • Using autoformat
  • Adding a fill colour to a selection
  • Changing the colour, size and style of a font
  • Changing the alignment of the contents of a cell
  • Applying a date format to a cell or range
  • Applying or deleting borders to a selection
  • Using merge and centre
Performing calculations
  • Other useful functions
  • Using autosum
  • Displaying formulae on a worksheet
  • Order of operation
  • Entering a simple formula in a cell
Worksheets
  • Moving the contents of cells
  • Making copies of cell contents
  • Moving and copying a worksheet
  • Deleting a worksheet
  • Renaming a worksheet
  • Inserting another worksheet in the same workbook
Spelling and printing
  • Clearing a print area
  • Setting a print area
  • Printing a section of a worksheet
  • Printing the spreadsheet
  • Viewing a print preview
  • Using the spell checker

See related categories

Excel Level 1

£ 165 + VAT

The best Excel courses

See all

See all