Excel Introduction

Training

In London

£ 220 + VAT

Description

  • Type

    Training

  • Level

    Beginner

  • Location

    London

  • Duration

    1 Day

To give users an introduction to Excel and enable them to realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets, whilst also learning key essentials such as basic calculations and formatting work sheets. Suitable for: This is suitable for anyone who wants a basic knowledge of how to use Excel and get the most out of it. It is primarily for people who have not used Excel a great deal before but wish to know how to not only use it, but create functions through formatting, organising data and using multiple spread sheets.

Facilities

Location

Start date

London
See map
100a Chalk Farm Road, NW1 8EH

Start date

On request

About this course

No requirements as this is entry level Excel.

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

Course programme

Excel / Introduction

Objective: To give users an introduction to Excel and enable them to realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets.

Delegates: Maximum 8

This course is suitable for new or intending users of Excel who want to gain a good understanding of the software in a short space of time. A basic understanding of Windows is required, gained either by previous experience or by attendance on an “Introduction to Windows” course. Delegate numbers are restricted to 8, to ensure personal attention from the trainer

Structure: PC for every delegate

All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.

Duration: 1 day 9.30 am – 4.30 pm

Further Training: Excel Intermediate

Course Outline:

Excel Introduction

  • What is a Spreadsheet?

    Getting Started with Excel
  • Starting Excel; Excel Opening Screen
  • The Title Bar; The Menu Bar; Toolbars

  • Scroll Bars; Active Cell, Column and Row Headers

  • Sheet Tabs; The Status Bar; Menus and Submenus

  • SpeedKeys; Dialogue Boxes; Exiting Excel

    Getting Assistance with Excel

  • Using the Office Assistant
  • Getting Help Without the Office Assistant
  • Manipulating the Help Window
  • Finding Out What is On the Screen

    Starting a Workbook
  • Creating a New Workbook
  • Moving Around the Sheet

  • Scrolling; The Mouse Pointer

  • Selecting Cells with the Mouse

  • Selecting Cells with the Keyboard

  • Spreadsheet Data Types

  • Entering and Editing Data
  • Editing Long Entries

  • Undoing Incorrect Edits
  • AutoFill; Custom Lists
  • Saving, Closing, Opening and Deleting a Workbook

    Working with Worksheets and Cells

  • Using Go To

  • Moving Data with Drag-and-Drop
  • Cut, Copy and Paste

  • Moving Entries (Cut and Paste)

  • Copying Cell Contents (Copy and Paste)
  • Using the Office Clipboard

  • Using Find and Replace

    Entering Basic Calculations
  • AutoSum; Entering a Calculation
  • Statistical Functions

  • Using Relative and Absolute Cell Addresses
  • Circular References

    Formatting the Worksheet
  • The Formatting Toolbar
  • Enhancements

  • Alignment

  • Formatting Numbers

  • Resizing Columns and Rows

  • Clearing a Worksheet

    Structuring the Worksheet

  • Inserting and Deleting Rows and Columns
  • Inserting and Deleting Worksheets

    Printing Worksheets
  • Print Preview
  • Changing the Page Setup; Printing

Additional information

Support: Pass training will help pay for individuals booking alone, or people on income support or other similar benefits. Discounts are also available to companies.
Payment options: All Courses can be held privately at our premises or otherwise.

Excel Introduction

£ 220 + VAT