We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course Excel Level 1
  • Public Scheduled Price£195 +VAT
  • Course Duration1 Day
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
  • Latest Reviews6
    "Fantastic. Easy to follow. Excellent venue and trainer"

    D.G. SPIE UK, Excel Level 1

    "Very well explained, it was so easy to follow. All excellent, lovely venue."

    M.N. MAN Diesel & Turbo UK Ltd, Excel Level 1

    "Ideal for entry level"

    M.Q. Nissan, Excel Level 1

    "All of the course gave me a wide insight into Excel and its capabilities."

    M.W. Litterboss Ground Control, Excel Level 1

    "Very enjoyable course"

    W.M. Gestamp UK Ltd, Excel Level 1

Overview
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
Prerequisites
    • Delegates should be familiar with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.
Objectives
    • Create a spreadsheet containing data, navigate using keyboard shortcuts, add new columns and rows and save the spreadsheet.
    • Create and format a spreadsheet using the main features of the formatting tools,
    • Perform the following calculations on a range of numbers: addition, subtraction, multiplication and division.
    • Use: sum, average, count, min and max on a range of numbers.
    • Present the data in a chart and print the spreadsheet
What's included
    • Laptops are available for training delivered at client's premises
    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support
Course Content
    • Exploring the Microsoft Excel environment
      Exploring the user interface
      Exploring the ribbon
      Obtaining help
      Customising the quick access toolbar
    • Understanding Workbooks and Worksheets
      Creating a new workbook
      Saving a workbook
      Opening a workbook already created
      Navigating in Microsoft Excel
      Selecting and entering data
      Saving a workbook
    • Entering and Editing Specific Data
      Entering text and numbers
      Entering numbers as text
      Inputting dates and times
      Editing the contents of a cell
      Manipulating data
      Using the undo and redo buttons
    • Using and Understanding Cell Formats
      Using the Cell Formats options
      Understanding the General Format
      Date and Time Formats
      Currency and Accounting Formats
      Text Formats
      Clearing and Resetting Formats
    • Ranges
      Selecting a range of cells
      Selecting more than one range
      Selecting an entire column and row
      Highlighting the entire worksheet
    • AutoFill
      Using Autofill to automate data entry
      Text AutoFill
      Number Autofill
      Date AutoFill
      Custom Lists
      FlashFill
    • Columns and rows
      Inserting and deleting cells, columns and rows
      Changing column widths and row heights
      Auto-fitting a column to its contents
      Changing back to standard widths
      Hiding and un-hiding a column or row
      Searching for data in a worksheet
      Freezing and unfreezing rows and columns
    • Developing a workbook
      Formatting worksheet tabs
      Repositioning worksheets in a workbook
      Inserting and deleting worksheets
      Copying and pasting worksheets
    • Formatting a worksheet
      Modifying fonts
      Merging cells
      Aligning cell contents
      Finding and replacing formats
      Applying borders to a selection
      Deleting borders around a selection of cells
      Changing the alignment of the contents of a cell
      Using the format painter
      Clearing cells (removing formats)
    • Cut, Copy and Paste
      Understanding Cut, Copy and Paste
      Using Shortcuts
      Copying and Pasting to different sheets
      Understanding the Paste Options
    • Performing calculations
      Adding and Subtracting Numbers
      Multiply and Division
      Understanding BODMAS
      Using the cell references
      SUM function
      AUTOSUM
      Useful Basic Functions AVERAGE, MIN, MAX and COUNT
    • Basic Sorting and Filtering Data
      Sorting data in a spreadsheet
      Filtering data in a spreadsheet
    • Basic Charts
      Chart types
      Simple Chart Customisations
    • Spelling and Printing
      Starting the spell checker
      Viewing a print preview
      Printing the spreadsheet
      Printing a section of a worksheet
      Clearing a print area

 

Latest Course Reviews
"I feel much happier after sitting the course"

D.G. Stobart rail, Excel Level 1

"All of the course gave me a wide insight into Excel and its capabilities."

M.W. Litterboss Ground Control, Excel Level 1

"Ideal for entry level"

M.Q. Nissan, Excel Level 1

"Very enjoyable course"

W.M. Gestamp UK Ltd, Excel Level 1

"Fantastic. Easy to follow. Excellent venue and trainer"

D.G. SPIE UK, Excel Level 1

"Very well explained, it was so easy to follow. All excellent, lovely venue."

M.N. MAN Diesel & Turbo UK Ltd, Excel Level 1

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 16 Jun 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields