Excel Training - Microsoft Courses

Microsoft Excel Training - London and UK wide

• Courses never cancelled
• Last minute rescheduling
• UK's most regular courses (instructor led)
• Microsoft certified trainers
• 12 month delegate support forum
• Quick on-line order and customer account system
• 191 public scheduled Excel courses over the next 6 months
• 355 total Excel training events over the next 6 months

Our Excel training courses are delivered by Microsoft Certified trainers for all versions of MS Excel. Each course is one day in duration and we offer four levels of training - Introduction, Intermediate, Advanced and Visual Basic (VBA).

Public Schedule courses are held at one of our four London 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.

We are a Microsoft authorised testing centre and run the UK's most regular MS Excel scheduled courses. We also offer Microsoft Office Specialist (MOS) certification training and examinations.

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.

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				List price £225
Version	Date	Location	Places available	Book	Next place rate:
					Card	Invoice
2007	2008 May 12 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 12 Mon	Tooting	1	book now	£215	£215
2003/XP	2008 May 19 Mon	Tooting	0	FULL
2003/XP	2008 May 19 Mon	Bayswater	5	book now	£195	£205
2003/XP	2008 May 21 Wed	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 135 Excel Introduction course dates. Bookings currently available until 18th November 2009.

Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Next place rate:
					Card	Invoice
2007	2008 May 13 Tue	Bloomsbury	0	FULL
2003/XP	2008 May 13 Tue	Tooting	4	book now	£199	£207
2003/XP	2008 May 15 Thu	Southwark	0	FULL
2007	2008 May 19 Mon	Bloomsbury	3	book now	£224	£224
2003/XP	2008 May 20 Tue	Tooting	0	FULL
Full Schedule: See all 170 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

Excel Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	Next place rate:
					Card	Invoice
2003/XP	2008 May 14 Wed	Tooting	4	book now	£214	£230
2007	2008 May 14 Wed	Bloomsbury	4	book now	£240	£245
2003/XP	2008 May 16 Fri	Southwark	6	book now	£214	£230
2007	2008 May 20 Tue	Bloomsbury	7	book now	£218	£240
2003/XP	2008 May 21 Wed	Southwark	6	book now	£214	£230
Full Schedule: See all 156 Excel Advanced course dates. Bookings currently available until 24th November 2009.

Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	Next place rate:
					Card	Invoice
2003/XP	2008 May 15 Thu + 16 Fri	Bloomsbury	4	book now	£475	£485
2003/XP	2008 May 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Jun 5 Thu + 6 Fri	Bayswater	7	book now	£345	£399
2003/XP	2008 Jun 12 Thu + 13 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Jun 19 Thu + 20 Fri	Southwark	7	book now	£345	£399
Full Schedule: See all 66 Excel VBA course dates. Bookings currently available until 26th November 2009.

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.

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.

MS Excel articles

Excerpt from Microsoft Excel Training: Essential for Today’s Employees:

Over the years, the king of all spreadsheet programs has grown from a fairly simple calculator into an application with the ability to perform highly complex operations. The problem for most is figuring out where to start and how each of the functions can be used. Books are great reference tools if you already know what you’re looking for, but Excel training courses are where you’ll really grasp the full potential of Excel quickly. With the right instructional program, you can acquire a base foundation of knowledge with just one day of Excel training as part of a Microsoft+Excel+course.

Excerpt from Microsoft Excel's Best Kept Secret

Even after one day of Microsoft Excel training you're likely to walk away with countless ideas for streamlining your daily activities and enhancing the usefulness of your data. In this article, we'll scratch the surface of one of Excel's most ingenious capabilities that has the potential to revolutionize the way you conduct your tasks - the Excel web query. If the term "web query" makes you feel like you're treading dangerously close to complicated programming, rest assured that this is big name for something incredibly simple and unusually useful that you'll learn in Microsoft Excel training. An Excel web query simply means that you're telling Excel to go out and retrieve the most current information from a particular web page.

Excerpt from Take the Anxiety out of Domestic Finances with Microsoft Excel

Looking after domestic finances can cause much anxiety. Often you are anxious because you find it difficult to keep track of your finances and so do not feel you are in control. Using Microsoft Excel to record, monitor and control your domestic finances can go a long way to removing this anxiety. Some effort is required at the beginning to set up the systems but this is soon rewarded by providing you with a great time and labour saving device, which can also help you save money and stay in control of your finances.

Customer testimonials for Microsoft Excel training courses

"I found that the trainer was knowledgeable in all areas of the Advanced Excel course and he was friendly, pleasant and interactive throughout the day, including during the breaks."
- SS, Commission for Social Care Inspection [Excel Advanced]

"I was very pleased with my exce+training. Trainer was very clear with his explanations."
- HF, Big Lottery Fund [Excel Intermediate]

"I was very inpressed with the course. I did an Excel Course some 8 years ago and what I learnt today has built upon that and brought me up to date."
- MW, BTP [Excel Introduction]

"The trainer explained everything incredibly clearly, he used really relevant examples and was very knowledgeable about Excel"
- PG, Goodman Masson [Excel Advanced]

"The excel training course contained very useful and relevant information and was structured in a clear and simple way"
- SA, Education And Media Services Ltd. [Excel Intermediate]

Some hints and tips for Microsoft Excel

Taken from our Excel hints and tips page.

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in an excel spreadsheet, this can make you think that you've make some kind of mistake. This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell. All you need to do to see what is actually in the cell is to widen the column that the cell is in.

Reconciling a list to correspond with another

You may have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

Repeating headings on spreadsheets that print on more than one page

By default when you print an excel spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1. To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK. If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

Use the SUBTOTAL function in Excel

You can create subtotals in your excel spreadsheet using the SUBTOTAL function, which looks like this:
=SUBTOTAL(9,cell:cell)
9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using Excel's subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

Sample forum questions from an Excel-training-course

Taken from our Microsoft Excel support forum

Automatic importing from other worksheets

We have a spreadsheet for each job totalling costs and profit . Can we get the total for each project to be automatically sent to a central document for easy reference. At the moment we have to open each file and get figure and then close it and move onto the next one. Many Thanks
- See the answer

Sort data with different size cells

I have made a big data base with columns that are named after - Store - City- Country etc.

I would like to sort the data according to the country and normally that works but now, because some of the cells in column A have been merged - it does not seem to work.

Even after my excel-training-courses it would be good if you help me with this?
- See the answer

VLOOKUP function

I'm having some trouble with VLOOKUP. It doesn't seem to work unless the data table it is reading from is in alphabetical/numerical order.... but I'm sure this can't be right!
- See the answer

Look Up formula for designated details on another sheet

In regards to Microsoft+Excel+training+London, I have some data on hidden sheets (details page) and I have a front page where I input certain details for it then to bring up data from the details pages at the back fo my work sheet. I know that the formulas are "look ups" but when I type in the look up formula associating it with the data at the back it doesn't work. Can you help me? Perhaps explain to me the formula for "look up"? Thanks.
- See the answer

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