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 2
  • 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 Reviews29
    "Helped me to improve my skills and find quicker ways to do things. All the material outlined on the course description was covered, exactly as I expected. The training material was very thoughtfully l..."

    C.W. Nissan, Excel Level 2

    Which part of the course did you find particularly valuable?"Learned some quick, simple ways that I didn't know were there"

    C.P. Egger Uk, Excel Level 2

    "Learned a lot from today's course that I can take into my workplace"

    C.D. nissan nmuk, Excel Level 2

    "An all round great course, thanks once again."

    S.F. Nissan, Excel Level 2

    Following this training what are you going to do differently?"Use the formulas and implement them into reports on BO analysis "

    N.S. Egger Uk, Excel Level 2

    "Trainer was excellent, very enthusiastic and knowledgeable."

    A.M. Nissan, Excel Level 2

Overview
In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.
Prerequisites
    • Before starting this course, we recommend that delegates have attended the Microsoft Excel Level 1 course or have equivalent knowledge.
Objectives
    • Use the IF function to automate tasks using tests.
    • Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data, eg. an expenses sheet that takes the monthly totals and displays them on a summary sheet.
    • Filter a spreadsheet to show only the records that meet a specific criteria, eg. all surnames beginning with A.
    • Display data in various graphical formats that can be easily understood by anyone not using Microsoft Excel.
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
    • RECAP of Performing calculations
      Adding and Subtracting Numbers
      Multiplication and Division
      Understanding BODMAS
      Cell references
      SUM function
      AUTOSUM
      Useful Basic Functions AVERAGE, MIN, MAX and COUNT
    • Using Absolute Referencing
      Difference between Relative and Absolute References
      Absolute Reference and Dollar Sign
      Why use Absolute References
      Applying an Absolute Reference in a formula
    • Tables
      Creating Tables
      Advantages of using tables
      Adding data to tables
      Table Options
      Slicers
    • Naming Cells (Ranges)
      Giving text to cells and ranges of cells
      Create Names from Selection
      Create Names using the Name Box
      Names in formulas
      Name Manager
    • Linking within a workbook (3D-Referencing)
      Linking within a workbook
      Simple referencing in a worksheet
      Calculating across multiple sheets using 3D-Referencing
    • Calculating Data with Logical Functions (IF Function)
      IF functions
      IF function criteria
      Using IF’s to test or check your data
    • Conditional Formatting
      Conditional Formatting Types
      Highlight Cells different colours based on their value
      Top Bottom Rules
      Icon Sets
      Data Bars
      Colour Scales
      Customising Conditional Formatting
    • Performing Date and Time Calculations
      Date Shortcuts
      TODAY and NOW functions
      DATEDIF function
      YEAR, MONTH, DAY, TEXT functions
      NETWORKDAYS function
    • Comments
      Adding, Editing and Deleting Comments
    • Data Validation
      Specifying Validation Criteria
      Controlling entry into a cell
      Types of Validation Criteria
      Creating a Drop-down List
    • Security
      Protecting a worksheet and a workbook
    • Presenting Data Using Charts
      Creating a chart
      Modifying charts
      Formatting charts
      Advanced Chart Features
      Multi-Axis charts
      Quick Analysis Tool

 

Course Dates

Latest Course Reviews
"The trainer was very helpful. Took the time to explain things to individuals who needed it."

A.B. Nicholsons Sealing Technologies, Excel Level 2

Any other comments or recommendations?"Very good and informative. The trainer was good and not reading from a book, very knowledgeable and approachable. "

S.R. Edinburgh Woollen Mill, Excel Level 2

Which part of the course did you find particularly valuable?"Learned some quick, simple ways that I didn't know were there"

C.P. Egger Uk, Excel Level 2

Following this training what are you going to do differently?"Use the formulas and implement them into reports on BO analysis "

N.S. Egger Uk, Excel Level 2

Following this training what are you going to do differently?"This will speed up and improve appearance of charts which I produce in reports "

P.B. Egger UK, Excel Level 2

"The course has shown me the easier way to do things I was doing before so I will put that into practice."

L.P. Egger UK, Excel Level 2

"Course was delivered well to someone with limited knowledge and confidence"

L.P. Egger UK, Excel Level 2

Following this training what are you going to do differently?"Increase technical ability and streamline my work. Use more of the functions rather than typing out formulas. "

D.S. Home Office, Excel Level 2

"The overall course was a great reminder about certain features. I particularly found data validation and conditional formatting very useful."

A.G. Home Office, Excel Level 2

"I was happy with all of it as it will allow me to use Excel more confidently "

L.G. Home Office, Excel Level 2

Which part of the course did you find particularly valuable?"Learning short cuts and filters"

M.C. CMR UK Ltd, Excel Level 2

"Enjoyable course"

D.S. CMR UK Ltd, Excel Level 2

Following this training what are you going to do differently?"Use Excel in different and easier ways"

P.C. CMR UK Ltd, Excel Level 2

"I enjoyed learning about graphs and tables as this will help me within my job."

S.B. FM Coatings, Excel Level 2

"Really enjoyable"

B.S. Direct Rail Services, Excel Level 2

"Great that lunch is provided and snacks/brews"

S.L. British Gypsum, Excel Level 2

"Great course, easy to follow, would recommend"

B.M. Direct Rail Services, Excel Level 2

"All parts relevant with good training materials"

C.L. Direct Rail Services, Excel Level 2

"Excellent training"

S. Nissan, Excel Level 2

"Learned a lot from today's course that I can take into my workplace"

C.D. nissan nmuk, Excel Level 2

"Everything was useful"

N.R. Northern Powergrid, Excel Level 2

"Very informative practical course."

T.W. Stobart Rail Ltd, Excel Level 2

"An all round great course, thanks once again."

S.F. Nissan, Excel Level 2

"Helped me to improve my skills and find quicker ways to do things. All the material outlined on the course description was covered, exactly as I expected. The training material was very thoughtfully laid out."

C.W. Nissan, Excel Level 2

"I recently attended the Level 1 course, so this was a perfect and relevant next step in my Excel training. Picked up some tips which will assist me everyday back in the office. Great course, much appreciated."

H.M. Nissan, Excel Level 2

"Excellent course, well worth doing."

A.P. Siemens, Excel Level 2

"[The trainer] made me feel very settled and explained everything in detail. Fantastic Course"

P.C. Hodgson Sayers Ltd, Excel Level 2

"Our trainer was always open to questions and was always clear on explaining the main objectives and tasks to do. Was very easy to follow and we covered all I expected for this level. Brilliant!"

M.S. Nissan, Excel Level 2

"Trainer was excellent, very enthusiastic and knowledgeable."

A.M. Nissan, Excel Level 2

 

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

Printed: 16 Sep 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