Excel Level 1

5.0
1 opinion
  • 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

Description

  • Duration

    1 Day

Description

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

Starts

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

Starts

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

Starts

On request

To take into account

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

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Opinions

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
Reviews gathered by Emagister & iAgora

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

Excel Level 1

£ 165 + VAT