Excel Training Courses
London and UK wide
Our Excel training courses are delivered by Microsoft Qualified trainers for all versions of MS Excel.
Each course is one day in duration (except VBA which is 2 days).
We offer seven levels of training: Introduction, Intermediate, Advanced, VBA (Visual Basic) Introduction, VBA Advanced, Pivot Tables and PowerPivot. See course details.
We run the UK's most regular MS Excel scheduled courses.
Public Schedule Excel courses in London are held at one of our 6 training centres. You can expect small class sizes in a modern, comfortable air conditioned training suite.
Additionally, we offer training services for closed company, on-site, one-to-one, near site and consultancy. Tailored Excel training courses can be adapted from our course syllabus to meet your individual needs and requirements.
Quality and Pricing
Our live on-line schedule benefits from using an "easyJet" style of pricing - so the further ahead you book, the lower the cost! Further to this, we have a highly competitive pricing policy of beating any like for like written training quotation.
Our Excel training courses are never cancelled: guaranteed.
Visit our pricing policy page to see how you can save money on your course.
Quality management system
We believe in continuous innovation and improvement in all aspects of our business model. This leads to reduced costs, increased efficiency and ultimately delivering more competitive course pricing. We evaluate all delegate feedback daily and ensure the careful preparation of all elements relating to training.
The feedback is available for review by the management, trainers, delegates and members of the marketing team. This ensures a high standard of course delivery during our Excel courses.
Trainer vouchers are available for Excel course in London. Buying in bulk ensures a reduction in purchasing costs and administration time. These are often favoured by high volume or corporate clients. You can use training vouchers for excel+training.
Customer testimonials for Microsoft Excel training courses
MS Excel articles
Excerpt from Flexible uses for Excel at Home:
Excel has earned its reputation as a solid business application, and rightly so. The attraction is that most home users have heard of it, and often have it in their home office, too. The problem is that when people are asked to find a use for it outside of business or number crunching, most people are stumped. It's such a flexible application, there's really no need to pigeonhole it into the realms of something you just do at work with spreadsheets. Spread your Excel training courses wings! You and your family will probably find it could do a lot more for you than you thought. Here are some suggestions on how you can use Excel to help you in daily life.
After you have spent some time collecting figures and transforming them into a Microsoft Excel training spreadsheet you may need to present your workbook to clients and colleagues. Thanks to the huge array of features offered by the programme, you can design your workbooks in many different forms.
Some entrepreneurs prefer information to be presented in straightforward tables, while others benefit from the varied functions of the software and they create coloured pie charts to reflect the data. Whichever way you choose to present information, you are likely to find that Microsoft Excel training is the backbone of many workplace documents that require analysis and presentation of data.
A great feature of the product is that is has been designed to help you produce workbooks that can be easily moved to other applications. For instance, if you have recently put-together a spreadsheet that shows which departments are under performing, you may wish to transfer information to other MS products.
Excerpt from How to start using Excel 2007 Functions:
You may have used calculations in Microsoft Excel 2007 for example to add two cell values by typing something like =D4+e4 into a cell, or to multiply two cells by typing this formula =D5*E5. You can build calculations like this using an "=" followed by a mixture of cell references and the symbols +, -, *, and / to add, subtract, multiply and divide values in different cells, with the answer showing in the cell containing the formula.
Excel takes this a step further by using preset calculations called functions built into the software. You may have already used the SUM function by clicking on the AutoSum button or you may have typed =SUM(D4:D10) into a cell below some numbers. Excel knows from the "=" that you are starting a calculation, and from "SUM" that you want to use the inbuilt SUM function to add cells, and the brackets tells Excel which range of cells you want to add - in this case, the values in cells D4 to D10 inclusive.
There are a total of 347 functions built into Excel 2007. Everyday examples of functions include AVERAGE (to find the average value of a range of cells), MAX (to find the highest value of a range of cells) and MIN (to find the lowest value of a range of cells). Other functions are for more specialised use, for example for use in financial calculations.
[Find out more with Computer courses London]
Some hints and tips for Microsoft Excel
Taken from our Excel hints and tips page.
To manually rotate a 3D chart:
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you don't get it right first time, don't worry, the manoeuvre is a little bit tricky. Or try a course on Excel.
In Excel you may wish to find cells that contain a specific formatting such s colour.
Select Edit > Find, click on Options and then Format... choose the formatting that you want found and click on OK
Choose one of the Find buttons to find.
Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.
The shortcut key combination to select an entire row is Shift+Spacebar.
The shortcut key combination to select an entire column is Ctrl+Spacebar.
These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.
I've attended some computer courses london. When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.
Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.
Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.
You can freeze rows and columns in your worksheet so they don't move.
This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.
Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)
Click on the 'Windows' menu and select 'Freeze Panes'.
Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.
To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.
This is taught on our Excel courses in London & UK wide.
Sample forum questions from an Excel-training-course
Taken from our Microsoft Excel support forum - an included extra as part of your Excel course.
Specific conditional formatting (click to see the answer)
I work for a medical diagnostic scanning company and work with an invoice log. We have specific scanning fees based on type of scan and number of body areas. We also have a team of doctors who report on our scans and receive a fee for each scan reported.
In most cases the fee is a simple 20% of the total scanning fee (for MRI's, XRAY's etc). However, for PET and PET/CT scans we have to deduct £340 before calculating the 20%.
We have a column in our invoice logs for scanning fees but are having to work out the PET and PET/CT report fees separately as we haven't been able to come up with the correct conditional formatting formula which will automatically calculate the additional £340 deduction.
I know this is going to be an =IF calculation and the logical test is "PET" or "PET/CT" but after that I'm coming unstuck.
Can you come up with a formula for me?
[Delegate attended Excel courses in London]
Cursor direction in text box reversed (click to see the answer)
When working in Excel 2007 with a spreadsheet that was created in Excel 2003 the existing and newly created (in Excel 2007) text boxes have the left/right polarity of the cursor inverted i.e. pressing the right arrow key moves the cursor left and the left arrow moves it right. Is a fix for this known?
Converting a negative figure to a positive (click to see the answer)
I am currently working on a spreadsheet were i am using the formula =Sum( and clicking on various cells in another folder. The total comes back as a negative figure which is correct but i want the figure to be shown as a positive and recognised as a positive as it adds into a total . hope you can help.
Unprotect options (click to see the answer)
I have a workbook which contains protected s/s.
When I right click on one of the s/s, all the options of Insert / Rename / Move or Copy / Delete / Hide / Unhide / Tab colour options are disabled. The only options available are View Code & Protect Sheet.
How do I enable the Insert / Rename / Move or Copy et al options?
What is Microsoft Excel?
Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.
We offer Microsoft Office Specialist (MOS) certification examinations.
NB. Excel, excel advanced training and Microsoft+excel+training+course are sometimes mistyped as excell, exel or exell.
A lot of people who search for us using Training courses in excel, Excel+courses, Microsoft excel training courses, Excel computer courses london or Excel training uk find this page. They are really looking for information on Excel courses London Bloomsbury, Excel courses in London, computer courses london or just Course excel in London. We suggest taking a look at our Excel overview page if you have arrived using those searches.
See also: Microsoft excel training