Author: Paul

Microsoft Excel training courses delivered at your own offices in Worcestershire from only £55 per person.

With Microsoft open public courses costing an average of £300 + VAT  per person, running closed training at your own offices makes a lot of sense, particularly at these prices:

• 1 – 3 delegates: £450
• 4 – 6 delegates: £500
• 7 – 10 delegates: £550

Our training rates are per group, not per person and include personal Microsoft Excel training manuals and course certificates. If you need laptops we can supply these for a small hire charge of £15 per person. All prices are + VAT.  We do not charge extra for travelling expenses anywhere in the UK.

For more information on Microsoft Excel training courses in Worcestershire please call us free on 0800 2922842 or alternatively email info@pbatraining.co.uk

Microsoft Excel training courses delivered at your own offices anywhere in Gloucestershire for the following daily rates:

• 1 – 3 delegates: £400
• 4 – 6 delegates: £450
• 7 – 10 delegates: £500

Please note that these rates are per group and include personal Microsoft Excel training manuals and course certificates. All prices are + VAT.

Onsite training can work out far cheaper than sending your employees on a public course. With the average Microsoft training course costing around £250 per person, you only need 2 delegates to start saving money. In addition, onsite training can be tailored to suit you exact requirements. Also, a wider range of abilities can be accommodated on a closed Company course.

For more information on Microsoft Excel training courses in Gloucestershire please call 0800 2922842 for a discussion about your requirements, or alternatively email info@pbatraining.co.uk.

We are delivering Microsoft Excel Training Courses in Yorkshire at Foundation, Intermediate & Advanced levels and in all versions from 2000 – 2010. The training is delivered at your own offices anywhere in Yorkshire and we provide all the equipment required to quickly convert any room into an IT training suite for a day. This includes a projector, screen and also laptops if you don’t already have your own. You may wish to take a look at what some of our clients have to say about our training services on the Testimonials page.

Here is a brief overview of the three levels of  Microsoft Excel training courses. Please keep in mind that we can tailor any course to fit your personal training requirements:

Foundation Excel Overview

• Introduction to spreadsheets
• Overview of the Excel menus and toolbars
• Entering & editing data and text
• Saving workbooks
• Formatting spreadsheet data & text
• Calculating using AutoSum
• Modifying spreadsheet (resizing & inserting columns, rows etc)
• Constructing basic formulas
• Copying formulas
• Understanding absolute cell references
• Introduction to Excel functions
  • The SUM function
  • The MIN function
  • The MAX function
  • The Average function
  • The COUNT & COUNTA functions
• Working with the date and time functions
• Highlighting data with Conditional Formatting
• Managing large workbooks (freezing rows, columns & panes etc)
• Printing workbooks & selected spreadsheet data

• s

Intermediate Excel Overview

• Excel overview refresher
• Linking workbook data
• Protecting workbooks & cell ranges
• Advanced conditional formatting techniques
• Finding data records with VLookups & HLookups
• Filtering data with the Auto & Advanced filters
• Macros and their uses
• Calculating Subtotals and working with Levels
• Sorting data using Pivot Tables & Pivot Charts
• Consolidating data in multiple spreadsheets
• Linking worksheets with 3D formulas
• Using the Watch Window
• Data validation & creating drop-down lists
• Creating and applying custom styles
• Creating spreadsheet templates
• Embedding & linking spreadsheets in Word documents & PowerPoint slides

Advanced Excel Overview

• Using advanced functions
  • Conditional Logic: using the IF function
  • Using Not, AND, OR functions
  • Nested IF functions
  • The IFERROR function
• Using maths & statistical functions
  • The SUMIF function
  • The COUNTIF function
  • The AVERAGEIF function
• Introduction to the new 2007 Excel functions: SUMIFS, COUNTIFS, AVERAGEIFS
• Working with data
  • Speeding Data Entry with Excel Forms
  • Tidying the database with the TRIM function
  • Extracting text & data using FIND and MID functions
  • Using the VALUE function
• Working with advanced database functions
  • The DSUM function
  • The DAVERAGE function
  • The DCOUNT function
• Creating a Dashboard with PivotCharts & Slicers
  • Using Goal Seek
  • Creating & merging Scenarios

Excel Training Course Prices

Our current onsite training rates are as follows:

• 1 – 3 learners – £400
• 4 – 6 learners – £450
• 7 – 10 learners – £500

These rates are per group, not per person. All prices are + VAT, we do not charge extra for travelling expenses or any other hidden costs. Included in the price are personal Microsoft Excel training manuals, which learners keep as a reference after the course, along with a course certificate.

If you would like further information regarding Microsoft Excel Training Courses in Yorkshire, or indeed anywhere in the UK, please call or phone using the details below.

We can announce that we’re now available to deliver half-day Microsoft Excel training courses in Kent. Due to a large number of requests from clients we have produced half-day versions of all our most popular courses including Microsoft Access, Excel, Outlook, PowerPoint, Project & Word.

These new courses focus on the key skills required in a busy office and can be customised to suit you particular requirements. There are clear advantages to a half-day training session, particularly for those who are largely self-taught: your employees are not taken out of the workplace for an extended period, but still benefit from a structured Microsoft course which ‘fills in the gaps’ in their knowledge. Being self-taught is perfectly fine and many advanced users have learned in this way. However, the old adage that “you don’t know what you don’t know” was never more true than when applied to Microsoft Office applications! There are so many tools & techniques that only a structured training course can give the knowledge needed to unlock the potential of the software and your employees.

For more details about half-day Microsoft Excel training courses in Kent, or indeed anywhere in the UK, email info@pbatraining.co.uk of call us free on 0800 2922842.

We are available to deliver Microsoft Excel Training Courses in Norfolk including Cromer, Great Yarmouth, Hunstanton, Kings Lyn & throughout the County. As onsite Microsoft training specialists we offer Excel courses at Foundation, Intermediate & Advanced levels, delivered at your own offices anywhere in Norfolk. We provide all the training equipment, including laptops if required. All you need is a suitably sized office and we can turn it into an IT training room for the day. For an overview of our Excel courses please visit the Microsoft Excel Training page. You may also be interested to see what our clients say about our training services on the IT Training Testimonials page.

For more information about Microsoft Excel training courses in Norfolk, call free on 0800 2922842 or email info@pbatraining.co.uk

We are currently onsite delivering Microsoft Excel training courses in Hampshire. Training can be arranged at your offices in Andover, Basingstoke, Farnborough, Portsmouth, Southampton, Winchester & throughout Hampshire. We specialise in onsite training and provide all the equipment needed, which means that you can turn any appropriate office into an IT training suite for the day.

All our tutors are both Microsoft Certified and qualified as trainers. This means that you are assured of a tutor who is both technically knowledgeable and skilful in delivery; a combination which is not commonplace. You may be interested in reading what clients say about our training services on the testimonials page.

Our Microsoft Excel training courses in Hampshire are delivered at Foundation, Intermediate & Advanced levels. We can provide you with a quick training needs analysis form which will help you to choose the right level of Excel training.

Your Excel training can be secured simply by completing our course booking form; we do not require a deposit and you will not be invoiced until after the training has been delivered. For more information about Microsoft Excel training courses in Hampshire please call 0800 2922842 or email info@pbatraining.co.uk