Excel Training - Microsoft Courses

Microsoft Excel Training - London and UK wide

• Courses never cancelled: Guaranteed!
• Last minute rescheduling
• £75 1-day courses (from)
• UK's most regular courses (instructor led) - Market leader
• Microsoft qualified trainers
• 12 month delegate support forum
• Quick on-line order and customer account system
• 3264 public scheduled Excel places over the next 12 months (8464 last 3 years)
• 776 total Excel training events over the next 12 months

• Go to Excel syllabus pages

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.	Training from £75 Visit our pricing policy page to see how you can save money on your Excel training course. Prices for our quality, instructor-led training courses really do start from £75, no 'bulk buy' is required.
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.

Microsoft Excel course events running soon...

Excel Introduction 1 day course
Version	Date	Location	Places available	Book	Next place rate (£)		List price
					Pay by Card	Pay by Invoice
2003	Tue 7 Sep 2010	Bloomsbury	6		£207	£212	£235
2007	Fri 10 Sep 2010	Limehouse (Docklands)	4		£215	£220	£235
2003	Mon 13 Sep 2010	Limehouse (Docklands)	5		£198	£203	£235
2003	Mon 20 Sep 2010	Bloomsbury	7		£198	£203	£235
2007	Thu 23 Sep 2010	Bloomsbury	2		£200	£205	£235
Full Schedule: See all 78 Excel Introduction course dates. Bookings currently available until 30th September 2011.

Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Next place rate (£)		List price
					Pay by Card	Pay by Invoice
2003	Mon 6 Sep 2010	Bloomsbury	6		£207	£212	£235
2007	Wed 8 Sep 2010	Limehouse (Docklands)	4		£215	£220	£235
2007	Fri 10 Sep 2010	Southwark	0	FULL			£235
2007	Fri 17 Sep 2010	Bloomsbury	4		£215	£220	£235
2003	Fri 17 Sep 2010	Southwark	9		£188	£193	£235
Full Schedule: See all 146 Excel Intermediate course dates. Bookings currently available until 30th September 2011.

Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Next place rate (£)		List price
					Pay by Card	Pay by Invoice
2003	Fri 3 Sep 2010	Bloomsbury	3		£240	£245	£245
2007	Mon 6 Sep 2010	Southwark	0	FULL			£245
2007	Tue 7 Sep 2010	Limehouse (Docklands)	0	FULL			£245
2010	Wed 8 Sep 2010	Bloomsbury	0	FULL			£299
2003	Thu 9 Sep 2010	Limehouse (Docklands)	3		£240	£245	£245
Full Schedule: See all 123 Excel Advanced course dates. Bookings currently available until 28th September 2011.

Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Next place rate (£)		List price
					Pay by Card	Pay by Invoice
2003	Wed 8 + Thu 9 Sep 2010	Southwark	7		£450	£455	£495
2003	Tue 21 + Wed 22 Sep 2010	Southwark	5		£475	£480	£495
2007	Wed 29 + Thu 30 Sep 2010	Bloomsbury	3		£490	£495	£495
2003	Mon 4 + Tue 5 Oct 2010	Southwark	8		£450	£455	£495
2003	Tue 12 + Wed 13 Oct 2010	Bloomsbury	9		£345	£350	£495
Full Schedule: See all 43 Excel VBA Intro Intermediate course dates. Bookings currently available until 28th September 2011.

Training Vouchers

Trainer vouchers are now available. 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.

For pricing and availability information about a public scheduled Microsoft Excel training course, please check online or alternatively call us.

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 training to help you in daily life.

Excerpt from Microsoft Excel provides the building blocks of shared information:

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 underperforming, 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.

Some hints and tips for Microsoft Excel

Taken from our Excel hints and tips page.

Manually rotating a 3D chart

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 dont get it right first time, dont worry, the manoeuver is a little bit tricky.

Find cells that match a format

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.

Use shortcut keys to select rows or columns

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.

Return to the active cell after scrolling

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.

Freeze Rows and Columns to keep lables displayed

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 selct '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'.

Sample forum questions from an Excel-training-course

Taken from our Microsoft Excel support forum

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?

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 recongnised 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 color 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? Thanks

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.

NB. Excel, excel advanced training and microsoft+excel+training+course is 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 when they are really looking for information on excel courses London Bloomsbury or just course excel in London, so we suggest taking a look at our Excel overview page.

See also: Microsoft excel training