Excel Training - Microsoft Courses

Microsoft Excel Training - London and UK wide

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: guaranteed.

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

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:

Excerpt from Microsoft Excel's Best Kept Secret

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

 

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