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 3
  • 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 Reviews17
    "Really enjoyed this!"

    R. Labour, Excel Level 3

    "All of the course gave me new knowledge"

    C.B. CMR UK Ltd, Excel Level 3

    "All aspects greatly improved my knowledge."

    P.T. Bruker JV UK Ltd., Excel Level 3

    "The tutor was excellent, patient and clear."

    S.D. Ground Control, Excel Level 3

    "Lovely stuff!"

    M.K. Durham County Council, Excel Level 3

    "This course will change the way we format and present data in the department, saving us time and giving us a much better overview of our workload, budgets, and monthly stats."

    G.B. The Labour Party, Excel Level 3

Overview
This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.
Prerequisites
    • Before attending this course, we recommended that you have attended our Microsoft Excel Level 1 and 2 courses or have equivalent knowledge.
Objectives
    • Create a PivotTable to manipulate and extract data, then create a chart to display the results.
    • Create a spreadsheet that will display multiple groups of records that can be updated from a single source.
    • Create a formula that will only add up or count records that match specific criteria.
    • Record a Macro that will automate a repetitive task and then assign it to a new button on a new toolbar.
This course is suitable for:
Microsoft Excel 2007, 2010, 2013 and 2016
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
    • Using Absolute and Mixed Referencing TEST
      Difference between Relative and Absolute References
      Absolute Reference and Dollar Signs
      Why use Absolute References
      Applying an Absolute Reference in a formula
      Using a Mixed Reference
    • 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
    • Complex Functions
      Using Complex Functions
      IF Function
      Nested Ifs
      SUMIF function
      COUNTIF function
      COUNTBLANK function
      Using Wildcards in functions
    • Lookup Functions
      Understanding Lookup Functions
      Using VLOOKUP
      Approximate and Exact Matches
      Fixing Common Lookup problems
      Using HLOOKUP
    • 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
    • Pivot Tables
      Creating a pivot table
      Fields to create row headings
      Fields to create column headings
      Data in the summary area
      Dynamically building a pivot table
      Rearranging fields in a pivot table
      Number formatting of the data area
      Moving pivot tables from one sheet to another or around the same sheet
      Deleting a pivot table
    • Summarising Pivot Table Data
      Managing subtotals and grand totals
      Changing the data field calculation (Sum, Count, Average etc.)
      Sort and Filter
      Drilling down to the raw data
      Building and using Report Pages
    • Grouping Pivot Data
      Grouping Date Fields
      Including Years when Grouping by Months
      Grouping Date Fields by Week
      Multi Grouping
    • Pivot Charts
      Building Pivot Charts
      Editing Pivot Chart Layouts
      Editing Pivot Chart Styles
      Using the built in chart filter buttons for presentation
    • Macros
      Recording a Macro
      Absolute References and Relative References
      Run a Macro
      Delete a Macro
      Assign a Macro to a Button
      Viewing the Code behind a Macro
      Macro Security

 

Latest Course Reviews
"The tutor was excellent, patient and clear."

S.D. Ground Control, Excel Level 3

"Brilliant once again."

M.K. Durham County Council, Excel Level 3

"Lovely stuff!"

M.K. Durham County Council, Excel Level 3

"All of the course gave me new knowledge"

C.B. CMR UK Ltd, Excel Level 3

"All aspects greatly improved my knowledge."

P.T. Bruker JV UK Ltd., Excel Level 3

"All of the course was great"

L.T. The Labour Party, Excel Level 3

"[The trainer] was great, he explained everything really well and was very helpful when anyone was struggling"

L.T. The Labour Party, Excel Level 3

"Really enjoyed this!"

R. Labour, Excel Level 3

"All informative, but pivot tables extremely useful"

G.B. The Labour Party, Excel Level 3

"This course will change the way we format and present data in the department, saving us time and giving us a much better overview of our workload, budgets, and monthly stats."

G.B. The Labour Party, Excel Level 3

"Really useful course thank you!"

L.O. Labour Party, Excel Level 3

"Very well presented"

A.C. Engie Fabricom, Excel Level 3

"Great course thank you!"

H.T. HKA, Excel Level 3

"Thank you for an excellently presented training day :)"

E.C. Nissan, Excel Level 3

"Superb course. Possibly the best course I have been on in 22 years in the Fire Service."

J.W. Durham & Darlington Fire & Rescue, Excel Level 3

"Pivot Tables - I'm going to have fun with this when I return to work!"

K.T. PX Group, Excel Level 3

"Great practical examples, with extra focus on sections tailored to individual areas of interest"

S.K. Nissan, Excel Level 3

 

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

Printed: 22 Apr 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