98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Customer training history
The following represents an example of training history information available online to all our customers.
All training data shown is actual. (Customer details have been altered for confidentiality).
Company summary:
- Customer has approximately 3000 staff worldwide and sales of over $5Bn
- STL has trained London based staff since October 2010
- Total spend to date: £30,564
- Staff training days: 191
STL on-site/closed company training events delivered (36)
| Date | Course | Location | Delegates |
|---|---|---|---|
| 2015 Apr 22 Wed | Multiple applications | On-site | 10 |
| 2015 Apr 21 Tue | Excel Advanced | On-site | 10 |
| 2014 Dec 4 Thu | Multiple applications | On-site | 10 |
| 2014 Dec 3 Wed | Excel Advanced | On-site | 10 |
| 2014 Sep 22 Mon | Multiple applications | On-site | 10 |
| 2014 Sep 19 Fri | Powerpoint Intermediate Advanced | On-site | 10 |
| 2014 Sep 18 Thu | Excel Advanced | On-site | 10 |
| 2014 Apr 22 Tue | Multiple applications | On-site | 10 |
| 2014 Apr 9 Wed | Powerpoint Intermediate Advanced | On-site | 10 |
| 2014 Apr 2 Wed | Excel Advanced - Formulas & Functions | On-site | 10 |
| 2013 Dec 19 Thu | Multiple applications | On-site | 10 |
| 2013 Dec 18 Wed | Powerpoint Intermediate Advanced | On-site | 10 |
| 2013 Nov 22 Fri | Excel Advanced - Formulas & Functions | On-site | 10 |
| 2013 Nov 8 Fri | Excel Introduction | On-site | 10 |
| 2013 Sep 25 Wed | Excel Intermediate | On-site | 10 |
| 2013 Jul 11 Thu | Multiple applications | On-site | 10 |
| 2013 Jul 10 Wed | Powerpoint Intermediate Advanced | On-site | 10 |
| 2013 Jul 9 Tue | Excel Advanced - Formulas & Functions | On-site | 10 |
| 2013 Jan 30 Wed | Powerpoint Introduction | On-site | 10 |
| 2012 Sep 21 Fri | Excel Intermediate | On-site | 10 |
| 2012 Sep 20 Thu | Excel Introduction | On-site | 10 |
| 2012 Sep 11 Tue | Excel Intermediate | On-site | 10 |
| 2012 Sep 10 Mon | Excel Introduction | On-site | 10 |
| 2012 Aug 23 Thu | Excel Intermediate | On-site | 10 |
| 2012 Aug 22 Wed | Excel Introduction | On-site | 10 |
| 2012 Aug 3 Fri | Excel Intermediate | On-site | 10 |
| 2012 Aug 2 Thu | Excel Introduction | On-site | 10 |
| 2011 Nov 8 Tue | Excel Intermediate | On-site | 10 |
| 2011 Nov 7 Mon | Excel Intermediate | On-site | 10 |
| 2011 Nov 3 Thu | Excel Intermediate | On-site | 10 |
| 2011 Sep 28 Wed | Excel Introduction | On-site | 10 |
| 2011 Sep 27 Tue | Excel Introduction | On-site | 10 |
| 2011 Sep 9 Fri | Excel Intermediate | On-site | 10 |
| 2011 Sep 8 Thu | Excel Intermediate | On-site | 10 |
| 2011 Sep 6 Tue | Excel Introduction | On-site | 10 |
| 2011 Sep 5 Mon | Excel Introduction | On-site | 10 |
Public scheduled courses attended (4)
| Date | Course | Location |
|---|---|---|
| 2012 Nov 28 Wed | Effective Communication Skills | Limehouse |
| 2012 Nov 28 Wed | Effective Communication Skills | Limehouse |
| 2011 Jul 28 Thu | Excel Intermediate | Bloomsbury Room 1 |
| 2010 Oct 25 Mon | Excel Intermediate | Bloomsbury Room 1 |
Order history (14)
| Type | Order # | Date | Total ex VAT(£) |
| onsite | 12345 | 2015 Feb 16 | 1,869 |
| onsite | 12346 | 2014 Oct 17 | 1,969 |
| onsite | 12347 | 2014 Jul 22 | 3,108 |
| onsite | 12348 | 2014 Jan 21 | 3,208 |
| onsite | 12349 | 2013 Nov 6 | 2,874 |
| onsite | 12350 | 2013 Aug 22 | 1,510 |
| onsite | 12351 | 2013 May 22 | 2,874 |
| onsite | 12352 | 2012 Nov 14 | 620 |
| public | 12353 | 2012 Nov 12 | 0 |
| onsite | 12354 | 2012 Jul 16 | 5,770 |
| onsite | 12355 | 2011 Sep 5 | 2,200 |
| onsite | 12356 | 2011 Aug 1 | 4,347 |
| public | 12357 | 2011 Jul 11 | 0 |
| public | 12358 | 2010 Oct 21 | 215 |
| Total: | £ 30,564 | ||
|---|---|---|---|
Post-course feedback given by delegates (103 total)
| Course | Ratings | Feedback | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
John Smith
Date: Wed 9 Apr 2014
|
|
Great training, and the lunch was good. | ||||||||||||||||||||||||||||||
|
Jane Jones
Date: Wed 18 Dec 2013
Requested more info on: |
|
Found the trainer to be very helpful and patient. Thank you for a great day. I look forward to my VBA course. | ||||||||||||||||||||||||||||||
|
Alexander Johnson
Date: Wed 3 Dec 2014
|
|
Couldn't fault the training today. It was better than the last course we had. Feel like I can use what we've learnt today back in the office. Please send me a certificate. | ||||||||||||||||||||||||||||||
|
Alice Tallus
Date: Thu 4 Dec 2014
|
|
No comment. Please arrange Word Advanced training with my HR Manager. |
Powerpoint Intermediate Advanced
Excel Advanced
Multiple applications(This sample report is truncated to save load time)
30 forum questions asked by delegates in your company, and resolved by Microsoft Qualified trainers at STL
(All forum questions are usually answered by Microsoft Qualified Trainers within 24 hours
Free 24 month forum access when a question is posted on the day of training, for every delegate).
| Date | Post |
|---|---|
| 3 Dec 2014 | pivot charts: can I have 2 sets of data on a y axis with a single set of data on an x axis? Eg. X axis GBP£, Y axis geographical region and department. |
| 3 Dec 2014 | Tables: I am always being asked to create graphs and tables, i find that excel is very sensitive to information and the format of the above do not incorporate my data the way i would like. Is there a tutorial available to show all the different graphs and table layouts and options also showing how to modify them or your inputted information so that they work together? |
| 22 Apr 2014 | Waterfall charts / Bridge Charts : I would love to learn more about Waterfall charts, is there an easier way to create them> Also how can I incorporate a Macro to create them. |
| 30 Jan 2013 | -: no questions at this stage, thanks |
| 21 Sep 2012 | Excel rows: how do you insert many rows rather than insert a single row into a list of exsiting data on a work book rather than insert at the end of the list of data |
| 28 Aug 2012 | Line Chart: I am trying to create a line chart. I have selected my data and when I press insert then chart, line it creates a chart that doesn't reflect the dates that I have listed in one of my columns. The dates that I need to run along the horizontal axis aren't in sequence and for some reason it is pulling a date in January for every year. Please help. Thanks Alice |
| 3 Aug 2012 | Lists - Data - Text to Columns: Is it possible to separate the vintage (year) from the following example: Ch. Mouton Rothschild 1982 if stored in one column? |
| 3 Aug 2012 | if commands: Hi. I am trying to create a command that comes up with the following words: "ok", "pending" and "due", where more than 5 days from the given deadline is "ok", less than 5 days is "pending" and less than 2 days is "due". This is my formula: =IF(D2-C2>5,"ok")=IF(D2-C2<5,"pending")=IF(D2-C2<2,"due"). The result I get is "true" or "false". Also, I tried to create conditional formatting, so "ok" is green, "pending" is yellow and "due" is red. I think I've done this, but as the words aren't appearing, I can't check. thanks Giles |
| 3 Aug 2012 | Colour Stirpes: How do I make say ten - twenty lines colour automatically |
| 10 Jan 2012 | Excel Formulas: Hello, I have an Excel spreadsheet with 2 tabs, 1st tab has a column with country names and their respective zones, i.e. Europe, Asia, etc in the 2nd column. The 2nd tab has a list of countires, is there a formula I can use to automatically enter the correct countyr zone on the 2nd tab? Many thanks |
| 10 Nov 2011 | Excel: Imagine we have a column of numbers (say in £s) in column A - say cells A3 down to A10 At the top we have a cell with exchange rate for £s to $s in say cell C1 - which today has say 1.5967 in it. Now I want to create a set of equivalent numbers in column B of my A values but in $s (a) So the manual version is to do a formula in B3 that reads "=A3*C1" but if I left that as is and copy it down to B10 the C1 would change. (b) SO what I need to do manually is put in "=A3*$C$1" which then when copied down the B column will be correct. Instead of actually doing (a) above I could go to cell B3 and type "=" and then click on cell A3, type "=" and click on C1, which would give us the same as (a) which is "=A3*C1" BUT as I need an "anchored cell" $C$1 instead of C1, I currently have to type it out like in (b) above. But there must be something I can do as a shortcut so that when I click on C1 it puts "$C$1" in the cell as an anchored cell address rather than just "C1"? |
| 8 Nov 2011 | formulas: Is there a formula in XL where you can select a random value from a list of text values? |
| 8 Nov 2011 | changing order of worksheets: is there a way of changing the order of worksheets quickly rather than dragging and dropping |
| 8 Nov 2011 | pasting values and not hidden rows/columns: when pasting values into a new spreadsheet how can I make it not paste hidden rows |
| 8 Nov 2011 | pasting values and not hidden rows/columns: when pasting values into a new spreadsheet how can I make it not paste hidden rows |
| 5 Oct 2011 | Excel 2010: how can you lock particulars cells in one table so they are not editable by users of the table, for example locking the first three columns only on a table, the others columns can be edited |
| 5 Oct 2011 | Highlight results of Excel find function: Please could you tell me if there is a way to immediately highlight cells that contain certain text using the find function? A conditional format won't work as this will be used to check names off a list of 3000 at a party (taking place on Friday) as guests are coming in, and it needs to be fast. The find function works, but it is not instantly obvious where the cell is thank you |
| 30 Sep 2011 | Excel: Is it possible to merge 2 excel spreadhseets so that the one spreadsheet can be produced taking the date from a number of spreasheetd? |
| 29 Sep 2011 | VBA insert image in comment: In Excel training there was a mention of inserting an image into Comment via VBA. It would be great if somebody could start me with vba code (assume that image link already exists in a cell that needs to be passed to a Comment) Many thanks |
| 29 Sep 2011 | inserting rows: How do I add multiple rows at the same time? thanks! |
| 28 Sep 2011 | Formulas: Hi, How do Match and Index formulas work? Many thanks, Olivia |
| 28 Sep 2011 | printing spreadsheets: how do you freeze the labels so they print at the top of each page |
| 28 Sep 2011 | Text and cases: How do you change the text in a whole spreadsheet from lower case to upper case and vice cersa? |
| 13 Sep 2011 | Heading Locking: Having created a table for listing PAT tests, how do I lock line1 with the headings on so that the other lines pass up under it |
| 9 Sep 2011 | Pictures: How can I embed a picture so it is part of a spreadsheet and not overlaping the data? |
| 9 Sep 2011 | Excel: How do you short cut the following function: File;Excel options;Save;Colours;Copy colours from Thanks |
| 9 Sep 2011 | Macro: How do you record a formula in a macro without copying the values? I want to use a macro to sort a list and divide a cell by 10%. However, when I record the macro, it saves my values. I want to be able to insert any values. |
| 6 Sep 2011 | Formula: I'd like to know if there is a way to copy a formula down vertically, but using the data running horizontally. |
| 6 Sep 2011 | MACROS: I would like to take a macro and update it, but I've never worked with MAcros in the past. Is it possible to update a marco, or must they be started from scratch? Basically I would like to run a macro to calculate foreign exchange rates. |
| 6 Sep 2011 | Charts: How to make charts and possibilities with the data |
