visit our website www.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.

Onsite Microsoft Access training courses in Yorkshire including Doncaster, Halifax, Harrogate, Huddersfield,  Rotherham, Sheffield, Leeds, York & throughout the County. We deliver MS Access at Foundation, Intermediate & Advanced levels. Here is a brief overview of each course:

Foundation Microsoft Access Course

• Creating a new database
• Opening database files
• Creating tables
• Using table views
• Understanding data types
• Setting Primary keys
• Changing field properties
• Creating input masks
• Understanding table relationships
• Using sub datasheets
• Creating & using forms
• Using filters
• Creating queries

Intermediate Microsoft Access Course

• Controlling data entry
• Joining tables
• Creating flexible Queries
• Improving Access forms
• Customising Access reports
• Sharing data across applications

Advanced Microsoft Access Course

• Querying with SQL
• Writing SQL statements
• Attaching SQL queries to controls
• Creating parameter queries
• Creating crosstab queries
• Using action queries
• Creating and editing macros
• Importing and exporting objects
• Linking Access objects
• Synchronising and replicating the database
• Encrypting and decrypting databases

For more information about onsite Microsoft Access training courses in Yorkshire, please email info@paulbrowntraining.org or call us free on 0800 2922842 for a no-obligation chat about your needs.

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 now taking bookings for Microsoft Access training courses in Lancashire including including Blackburn, Blackpool, Bolton, Burnley, Bury, Chorley, Colne, Manchester, Oldham, Preston, Rochdale, Salford, Wigan & throughout the County. We are specialists in onsite training and can deliver Microsoft Access courses at your own offices anywhere in the UK from £400 per group. We supply all the training equipment and can also provide laptops if required.

For more information on Microsoft Access training courses at your offices in Lancashire, email info@pbatraining.co.uk or call free on 0800 2922842.

We are back running Microsoft Office 2010 training courses in Bury St Edmunds, Suffolk this week. Our Foundation level Microsoft Office 2010 course includes training on the following topics:

Introduction to Microsoft Word 2010

• The Ribbon
• The Quick Access Toolbar
• Live Preview
• Saving Documents
• Creating & Using Styles
• Creating a Table of Contents
• Updating a Table of Contents
• Navigating the Document using a Table of Contents
• Creating an Index
• Updating the Index
• Creating Envelopes and Labels
• How to Set Up a Mail Merge
• Creating a Mail Merge with a new List
• Creating a Mail Merge from an Existing Database
• Using Tables for Layout
• Inserting Graphics and Photos

Introduction to Microsoft Excel 2010

• Saving Workbooks
• Formatting Worksheets
• Selecting Cells, Columns and Rows
• Formatting Text and Data
• Adjusting Columns
• Merging Cells
• Formatting Numbers
• Calculating Totals using AutoSum
• How to Use AutoSum
• Moving and Copying Data
• Moving Data
• Copying Data
• Renaming Worksheet Tabs
• Inserting & Deleting Columns and Rows
• Constructing Simple Formulas
• Arithmetic Operators in Excel
• Formula Construction
• Editing Formulas
• Combining Arithmetic Operators 14
• Copying Formulas 15
• Freezing Panes 16
• Hiding Columns & Rows 16
• Using the Auto Filter 16

Introduction to Microsoft Outlook 2010

• Sending & Replying to Emails
• Searching for Messages
• Using the Search Tools
• Creating & Managing Appointments
• How to Create an Appointment
• Inviting Attendees
• Replying to a Meeting Request
• How to Change Meeting Times
• Cancelling a Meeting
• Email Rules
• How to Create a Rule
• Creating & Managing Tasks

For more information on Microsoft Office training courses in Suffolk, or anywhere in the UK, call free on 0800 2922842 or email info@pbatraining.co.uk

We are taking bookings for Microsoft Project Training Courses in Hertfordshire including Berkhamstead, Hemel Hempstead, Hertford, Potters Bar, Steveneage, Welwyn Garden City & throughout the County. Microsoft Project is the industry standard application for project management, but is notoriously difficult to teach one’s self. There are several elements of the programme where bad habits can easily be acquired.

One common mistake is the entering of Task start &  finish dates, something which should in fact not be done. When task relationships are correctly defined, start & finish dates are calculated automatically by Microsoft Project, leading to greater flexibility when a need to reschedule the plan occurs. Learning how to use Microsoft Project correctly through a structured, tutor-led course is the quickest way to increase your skills and will enable you to manage all your projects more efficiently.

We deliver Microsoft Project training courses at 3 levels: Foundation, Intermediate & Advanced. To help you determine the correct course for your needs you can download our Free Training Needs Analysis form. Just tick the boxes, email back to us and we will advise on the most suitable level.

Our onsite training courses include personal Microsoft Project training manuals, sample projects and course certificates. Prices for our 1 day courses are as follows:

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

These prices are the total amount for each training course, rates are + VAT.

For more information about Microsoft Project training courses in Hertfordshire & throughout the UK, call free on 0800 2922842 or email info@pbatraining.co.uk

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

We are delivering Sage Training Courses in Cambridgeshire including Chatteris, Cambridge, Godmanchester, Huntingdon, Soham, St. Neots & throughout the County. We can deliver Sage 50, Sage 100 and SageLine at your own offices for 1 – 10 learners for the following rates:

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

All rates shown are the total training price and are exclusive of VAT. We do not charge travelling or other expenses. We provide all the necessary equipment so that you can use any suitable office for your training.

For more information on Sage training courses in Cambridgeshire call free on 0800 2922842 or email sage@pbatraining.co.uk

Onsite Microsoft Project training Courses in Cheshire including Chester, Crewe, Macclesfield, Runcorn, Sandbach & Warrington are being delivered from just £50 per person. We are qualified to deliver Microsoft Project at Foundation & Advanced levels – for details please visit the Microsoft Project Training page.

Onsite training can often be far cheaper than sending your people on external courses. The average 1 day public Microsoft training course is now around £250 per person, plus travelling time and expenses. In contrast, our onsite training rates are:

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

Rates are plus VAT and include personal Microsoft Project training manuals & course completion certificates. We provide all the necessary training equipment, including laptops if required, so that you can use virtually any office.

For further information on Microsoft Project training courses in Chester, email info@pbatraining.co.uk or call 0800 2922842.