Public Classroom Training

officesIf you are an individual or only have one employee requiring training, you may wish to consider a public classroom-based course.

Discounted Rates

We act as trusted partners for some of the biggest public course providers in the UK and can secure big discounts on their normal prices. Prices vary depending upon the training required and it is always worth asking us for a quote before booking a course. Typically we could save you up to 25% on the listed course price.

Regular Courses at Local Venues

Public open Microsoft training events are regularly conducted at all the major cities in the UK.  For more details please visit our Public Courses page.

Excel Training Courses Nottinghamshire

Microsoft Office Excel training delivered onsite at your offices in Nottinghamshire from £55 per person

If you are a Nottinghamshire based business looking to train members of staff on Excel, we can help. Paul Brown Training Ltd are specialists in onsite training of Microsoft Office software. Our team of highly qualified trainers have many years of experience in delivering relevant Excel training to Companies right across Nottinghamshire.

Our courses are very ‘hands on’ and take the form of trainer-led demonstrations, followed by practical exercises using either your own equipment or laptops which we can supply. We concentrate on skills-based training and our courses have been designed and refined over the last 8 years to cover all the major features in Excel which will help your staff perform spreadsheet tasks more quickly and efficiently.

Microsoft Excel training courses in Nottinghamshire are delivered at three levels: Foundation, Intermediate and Advanced. To assist you in choosing the correct level of Microsoft training for your employees we can provide you with a training needs analysis service. This consists of a simple and quick tick-box form which can be completed in just a minute or two. We will then advice on suitable Excel training for each staff member. The needs analysis service is provided free of charge.

Please feel free to enquire without obligation using the ‘quick form’ at the top of the page. Alternatively you can call free to discuss your requirements on 0800 2922842, 8:30am to 5:30pm Monday to Friday.

Microsoft Project 2016 Introduction Training Course

Through our partners at QA we can now offer a public classroom based Microsoft Project Introduction training course at locations across the UK including:

  • Birmingham
  • Glasgow
  • Leeds
  • London
  • Manchester

During this 2 day MS Project course delegates will learn how to create new projects, work with different views, manage resources and track progress. Here is an overview of the course content:

Module 1 – Getting Started with Microsoft Project

  • Topic A – Introduction to Microsoft Project 2016
  • Topic B – Exploring the Microsoft Project 2016 Environment
  • Topic C – Displaying an Existing Project Plan in Different Views

Module 2 – Creating a Project Plan

  • Topic A – Creating a New Microsoft Project Plan
  • Topic B – Setting Project Working Time
  • Topic C – Project Information
  • Topic D – Creating Summary Stages or Phases
  • Topic E – Editing the Task List
  • Topic F – Defining the Activity List
  • Topic G – Creating and Applying Task Calendars
  • Topic H – Creating the Work Breakdown Structure

Module 3 – Creating the Project Schedule

  • Topic A – Task Durations
  • Topic B – Defining Milestones
  • Topic C – Manual Scheduling and Finish to Start Relationships
  • Topic D – Automatic Scheduling
  • Topic E – Task Relationships
  • Topic F – Adding Stages to the Timeline
  • Topic G – Identifying the Critical Path
  • Topic H – Working with Constraints and Deadlines
  • Topic I – Recurring Activities
  • Topic J – Adding Notes to a Task
  • Topic K – Referencing Other Files in Tasks

Module 4 – Managing Resources in a Project Plan

  • Topic A – Resource Types
  • Topic B – Working with Resource Calendars and Availability
  • Topic C – Adding Resource Costs
  • Topic D – Assigning Resources to Tasks
  • Topic E – Effort-Driven Scheduling
  • Topic F – Resolving Resource Overallocation
  • Topic G – Splitting Activities

Module 5 – Introduction to Project Tracking

  • Topic A – Setting a Project Baseline
  • Topic B – Entering Actuals
  • Topic C – Viewing Progress in a Project Plan

Module 6 – Viewing and Reporting Project Detail

  • Topic A – Filter, Group and Highlight Project Information
  • Topic B – Printing Views
  • Topic C – Using Standard Reports in Microsoft Project

QA’s normal price for this comprehensive 2 day course is £735 + VAT. As trusted partners we’re able to offer the training at the discounted rate of £635, representing a saving of £100 per person.

For further information or to book a place on this course, please call 0800 2922842 or visit our contact page.

Discounts on QA Public Training Courses

As official partners with QA, we are able to offer a wide range of public courses at discounted rates. QA are the biggest providers of classroom-based training in the UK, with centres right across the Country. As resellers for QA’s courses, we can typically obtain 10% – 20% discounts on their usual rates. As an example,  a 1 day classroom Microsoft Excel course would normally costs £330. However, booking training through us brings the price down to £280, saving £50 per person.

You can see an overview of training venues and courses on our Public Classroom Training Courses page.

For a public training quote, call 0800 2922842 or visit our contact page.

10% Discount on Microsoft Word Training

Throughout July and August 2016 we are offering a 10% discount off all Onsite Microsoft Word training courses. Group training rates are as follows:

  • 1 – 3 delegates: normally £450 – discounted price £405
  • 4 – 6 delegates: normally £500 – discounted price £450
  • 7 – 10 delegates: normally £550 – discounted price £495

These rates are per group, not per person. All training prices are plus VAT.

This offer applies to completed course booking forms received in July and August. Please note that training must be delivered by 31st December 2016.

For more details or to book a course, please call 0800 2922842 or use our contact form.

Tutorial 2: Working with the PMT Function

The PMT function is a financial function that you can use to calculate periodic payments for loans based on constant payments and a consistent interest rate. For example, you can use this function to calculate car, mortgage, or any other amortized loan payments.

The syntax for a PMT function requires three arguments, each of which must be preceded by =PMT and enclosed within parentheses:

  • Interest Rate (Rate): the rate at which the money is being borrowed.
  • Pay Period (Nper): the total number of payment periods in an annuity.
  • Amount Borrowed (Pv): the present value or the total amount of the loan.

Optional information includes:

  • Future Value (Fv): your goal for the loan, usually set at 0 (default).
  • Type: whether your loan payments occur at the beginning (1) or the end (0 or default) of each payment period.

It is critical that all argument information be expressed in comparable units. For example, if you are computing monthly payments on a four-year loan based on a 12 percent annual interest rate, use 12%/12 for Rate and 4*12 for Nper. If you make annual payments on the same loan, use 12% for Rate and 4 for Nper. Although you can do the division and multiplication yourself, it’s easier to let Excel take care of it. If you use a cell reference for any of these arguments, they also must be of comparable unit. For example, if you intend to use the formula above, the % symbol must be in the cell containing the interest rate.

The payment returned by PMT includes principal and interest only. These calculations do not include any taxes, reserve payments, or fees associated with loans.

When you open the Formula Palette, you will see a Collapse Dialog button at the end of each argument box. Use these buttons to collapse the dialog box temporarily, to help you select cells and ranges in the worksheet as arguments. When done, click the toggled Collapse Dialog box button in the collapsed dialog box.




To work with arguments using the PMT function:

First select the cell where you want to enter the function.

  1. On the Formulas tab, click the Insert Function button.
  2. In the Function category list box, select Financial.
  3. In the Function name list box, select PMT.
  4. Choose OK.
  5. In the Formula Palette, enter the following arguments:
    1. For Rate, the interest rate.
    2. For Nper, the number of payment periods.
    3. For Pv, the amount of the loan.
    4. For Fv, the goal amount, or omit it. (optional)
    5. For Type, 1 or 0, or omit it. (optional)
  6. Choose OK

Note: Arguments may be numbers, formulas, or cell references. You can enter arguments by typing them or by selecting them with the mouse in the worksheet.

Tutorial 1: Working with Excel Page Breaks

When printing multi-page spreadsheets in Excel, you may have come across page breaks which appear to be in the wrong place. For example, the default page break may force a particular row onto the next page. These breaks are set automatically by Excel and can be seen as horizontal and vertical dashed lines in Normal View.

In these situations, manual page breaks can be set to override the defaults and give you more control over how the spreadsheets looks when printed.

In Excel 2010 and later, setting manual page breaks is easier than ever. Using the Page Break Preview button shown below, you can add and remove page breaks as well as drag page breaks to new locations.




To access Page Break Preview:

  1. On the Workbook Views group of the Views tab, choose Page Break Preview.

To exit Page Break Preview:

  1. On the Workbook Views group of the Views tab, choose Normal.

To add a page break(s) in Page Break Preview:

  1. Right-click a cell below and to the right of the new page break(s).
  2. From the shortcut menu, choose Insert Page Break.

To remove page break(s) in Page Break Preview:

  1. Right-click the cell below and to the right of the page break(s).
  2. From the shortcut menu, choose Remove Page Break.

To move page breaks in Page Break Preview:

  1. Drag the page break to its new location.

Note: You can only drag page breaks when the double-headed arrow mouse pointer appears.

Microsoft OneNote Training Courses

Microsoft OneNote 2013 training courses at your offices anywhere in the UK from £55pp

Microsoft OneNote 2013 gives you the ultimate place to store and share your notes in a single, easy-to-access location. Capture text, photos, and video or audio files with OneNote 2013 to keep your thoughts, ideas and important information readily available. By sharing your notebooks, you can quickly swap notes with other people on your network, keeping everyone in sync and up-to-date.  You can use OneNote 2013 for Personal, Business or School use.


OneNote 2013 uses containers and they can contain the following:

  • Typed notes – just click and type
  • Lists i.e. bullets or numbered
  • Images such as clipart, digital photos etc
  • Information copied and pasted from the Internet or other programs on your PC
  • Ink notes for use with a Tablet PC
  • Diagrams
  • Screen shots again from your PC or the Internet
  • File attachments

Once created, notes can be moved around simply by clicking and dragging.  Press the Shift key while dragging if you want to merge note containers.  Containers can be moved to different pages, pages can be moved to different sections, sections can be moved to different notebooks.  Sections can also be grouped together to create a multi-level hierarchy.

  1. Module 1 – Introduction
    1. Objectives
    2. What is OneNote?
    3. What Kind of Notes can I Keep?
    4. The OneNote 2013 Environment
    5. Other Features of OneNote 2013
    6. Searching OneNote 2013
  1. Module 2 – Getting Started
    1. Objectives
    2. Creating a New Notebook
    3. Saving Notebooks
    4. How Information is Stored in OneNote 2013
    5. Sections
    6. Colour Coding Notebooks and Sections
    7. Navigation
    8. Quick Notes
  1. Module 3 – Working with Pages
    1. Objectives
    2. Working with Pages
    3. Subpages
    4. Using Page Templates
    5. Managing Pages
    6. Modify the Page Setup
    7. Adding Information to Pages
    8. For Typewritten Notes
    9. For Lists (Bullets & Numbering)
    10. For Handwritten Notes
    11. Adding Text from a Document in Word
    12. Send to OneNote
    13. Adding Tables to a Page
    14. Adding Files
    15. Graphics
  1. Module 4 – Keeping Track
    1. Objectives
    2. Tasks and To-Do Lists
    3. Tagging a OneNote 2013 To-Do List
    4. Sharing Notebooks online

The Microsoft OneNote training course is over 1 day and can be delivered onsite at your own offices anywhere in the UK.  Prices start from just £55 per person (based on a group of 10 delegates onsite). For further details or a quotation please call 0800 2922842 or use the contact form at the top of the page.

New Features in Microsoft Office 2013

Overview of the new features in Microsoft Office 2013

New Workspace Environment

Office 2013 applications share a common user interface, as with previous versions. So, when you’ve learned how to navigate around one application, you can apply the same concepts and a lot of the commands to the other applications in the suite. But the workspace environment has changed dramatically in version 2013.

SkyDrive – save and share files in the ‘Cloud’

Office 2013 makes it easier to save your workbooks to your own online location, like your free SkyDrive or your organization’s Office 365 service. It’s also simpler to share your worksheets with other people. No matter what device they’re using or where they are, everyone works with the latest version of a worksheet— and you can even work together in real time.

Access 2013

The new version supports PDF and XPS support. This is quite important. With Office Access 2013 you can save a report as a Portable Document Format file (PDF) or in XML Paper Specification (XPS) format for printing, posting, and e-mail distribution. By saving your report as a PDF or XPS file, you can capture report information in a form that retains all of your formatting characteristics yet does not require others to have Access 2013 to print or review your report.

Excel 2013

Create professional-looking charts more easily with a completely redesigned charting engine. Apply rich visual enhancements to your chart, such as 3-D, soft shadowing, and transparency. Create and interact with charts the same way, regardless of the application you are using, because the Office Excel 2013 charting engine is consistent in Microsoft Office Word 2013 and Microsoft Office PowerPoint 2013

Office Groove 2013

When you create a Groove ‘workspace’, everyone can share information and work together. You can participate by posting messages and responses, sharing files, and tracking projects and meetings on your shared space. There are three kinds of workspaces:

  1. File sharing, which is a workspace for synchronizing a selected Windows folder across computers.
  2. Standard workspace, which is a workspace with a Files tool and a Discussions tool.

Template workspace, which offers a workspace with tools you select from a list, such as Calendar, where you can mark important dates and build collaborative schedules with workspace members; Sketchpad (where you can use drawing tools); and even Chess Game.

Office InfoPath 2013

Gather information using Microsoft Office Outlook 2013 e-mail messages. With Office InfoPath 2013, you can complete forms without leaving the familiar Office Outlook 2013 environment, helping you complete your forms quickly and efficiently.

OneNote 2013

Two-way, automatic task synchronization with 2003 and 2013 versions of Outlook, which lets you keep your busy life well ordered and highly productive.

Outlook 2013

RSS! You can now fully subscribe to and interact with Really Simple Syndication (RSS) feeds right from Office Outlook 2013, the most natural place to manage this kind of information. No more hunting around for just the right kind of client to get your RSS content. Get your daily dose of news along with your daily dose of e-mail.

PowerPoint 2013

Dramatically modify shapes, text, and graphics with new tools and effects. You can now manipulate and work with your text, tables, charts, and other presentation elements in much richer ways than ever before. Office PowerPoint 2013 makes these tools readily available through the streamlined user interface and contextual tabs, so that in just a few clicks, you can add impact to your work

Microsoft Project 2013

There are a couple of important new features:

1) You can use Top-Down Budgeting to define a budget at a high level (entire program or project) so the project manager can allocate funds and track costs against the budget, and…

2) Planned and actual costs can be assigned to a task with Cost Resources, which also supports integration of Project with accounting systems. Both these items make dealing with costs and accounting a whole lot simpler.

Publisher 2013

The addition of PDF capability. You can now save Office Publisher 2013 files in a fixed file format, such as Portable Document Format file (PDF) or XML Paper Specification (XPS), for easy sharing. PDF settings within Office Publisher 2013 include options for online viewing, desktop printing, and commercial press-ready printing.

Visio 2013

Connect shapes without drawing connectors. New connector functionality in Office Visio 2013 connects shapes, distributes them evenly, and aligns them for you — with only one click. When you move the connected shapes, they stay connected and the connectors automatically reroute between the shapes.

Word 2013

In a phrase: Building Blocks. This new feature is a way to add frequently used content to your documents. Select from a predefined gallery of cover pages, pull quotes, headers, and footers to make your documents look more professional. You can even create your own Building Blocks to simplify the addition of custom text, like legal disclaimer text or other frequently used materials.

Associate Microsoft Trainers Required for Access, Excel, Outlook, PowerPoint, Project and Word

Microsoft trainers required in the South West, Wales, Scotland and across the UK

As part of our continuing expansion, we are looking for further Microsoft trainers to join our team. We welcome enquiries from all over the UK, but particularly the South West, Wales and Scotland. You will need a suitable adult teaching qualification such C&G 7303 or higher and Microsoft accreditation in you chosen field. We need trainers to deliver Microsoft Access, Excel, Outlook, PowerPoint, Project and Word. If you would like to join our team, please use the contact page in the first instance detailing your specialties and preferred working location.