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

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.
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 recommended 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, ie. 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, ie. 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
      Multiply and Division
      Understanding BODMAS
      Using the 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 Signs
      Why use Absolute References
      Applying an Absolute Reference in a formula
    • Tables
      Creating Tables
      Advantages of using tables
      Adding data to tables
      Working with Table Options
      Slicers
    • Naming Cells (Ranges)
      Giving text to cells and ranges of cells
      Create Name from Selection
      Create Names using the Name Box
      Using Names in formulas
      Using the 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
      Understanding the 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
      Using TODAY and NOW functions
      Using DATEDIF function
      Using YEAR, MONTH, DAY, TEXT functions
      Using 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

 

 

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

Printed: 20 Mar 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