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.

Microsoft OneNote Training Courses

Onsite OneNote training courses at your own offices anywhere in the UK

OneNote was designed by Microsoft as a handy tool for note taking, information gathering and multi-user collaboration. Yet despite the versatility of the application, relatively few people are using it regularly. This is perhaps down to a misunderstanding of the software and our new OneNote course has been designed to make it easy to get get the most from this useful business application.

What is OneNote?

OneNote is essentially an electronic notebook where you can write down notes, thoughts, ideas, scribbles, reminders and all kinds of other information. Unlike traditional document page formats, OneNote offers a free-form canvas where you can type, write or draw notes in the form of text graphics and images, wherever and however you want them. You may be wondering why you need to bother with another program when you can take perfectly adequate notes in Word, Outlook, even Notepad — or on paper. But imagine the convenience of having all your notes together in one place, with no need to remember file names or locations — and of being able to create a task in Outlook directly from your notes.

How Does OneNote Work?

OneNote uses ‘containers’ which can include  a variety of different data types:

  • Typed notes – just click and type
  • Bulleted and numbered lists
  • images such as photos, clipart etc.
  • Ink notes for use with Tablets, smart phones etc.
  • Screenshots from PC or Internet
  • information copied and pasted from other sources e.g. Internet or other applications
  • 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. For extra space on a page, simply click the Insert Extra Writing Space button to extend the page.

For further information on OneNote training courses delivered at your own offices anywhere in the UK, please use the quick contact form at the top of the page. If you would like to discuss your requirements with one of our advisers, please call 0800 2922842. Calls are free from a UK landline.

Microsoft Project Training Courses in Doncaster

Microsoft Project Training Courses Onsite at Your Doncaster Premises

MS Project remains the application of choice for most project managers, however successive versions have not made the software any easier to learn. To get the best from Microsoft Project it’s necessary to understand a few basic principles on which the software is based.

One frequent mistake made by new users is that of inserting Start and Finish dates into the Task Sheet. One would be forgiven for doing this as the layout of the interface suggests that this is what is required. However, in order to get the most out of the software’s ability to reschedule tasks, we should never do this. Instead, the task start and finish dates are usually arrived at by creating task linkages (or dependencies). When set-up correctly, the project plan can be updated much more easily should there be any variance in the future.

MS Project is characterised by such ‘quirks’, earning it the reputation of being the most difficult of all Microsoft applications to learn. This is where a structured training course can save both time and money. In just one day, we can show you how to set up your project plan correctly in order to gain the most from the software’s time-saving features. We will visit you at your own premises and can train up to 10 staff members together, maximising your time and investment.

Our onsite Microsoft Project training courses start conveniently at 10am and finish around 4pm. We can supply laptops if required with MS project pre-installed and our trainers carry projectors and screens, so that virtually any office can be used as a training room. Please call free on 0800 2922842 to discuss your requirements, or alternatively use the Quick Form at the top of this page.

Onsite Specialists for Microsoft Project Training Courses in Doncaster, Leeds, Sheffield, Rotherham, Barnsley, Wakefield and throughout Yorkshire

Microsoft Excel Training Brought to Your Offices in Liverpool

Microsoft Excel has become the most trusted and effective spreadsheet application in use across the globe today, being used by companies for everything from basic data processing to applying complex mathematical formulas.

Many people have a rudimentary understanding of what Excel can do, though their knowledge is often self-learnt and only scratches the surface of Excel’s capabilities. Did you know, for example, that in Microsoft Excel 2010, PowerPivot enables you to import countless rows of data from numerous data sources into one Excel workbook? From here, you can construct PivotTables and PivotCharts, enabling you to carry out further analysis of your data, so that you can easily make important decisions about your business without seeking outside IT support. Another useful but under-utilised tool allows you to select unique records only, such as specific names or numbers, from a large quantity of data. And there are many, many more tips and shortcuts which can make your use of Excel more efficient, more cost effective and deliver quantifiable improvements to your business.

Our Excel training can be tailor-made for any size of group and level of ability, and will be delivered onsite in your own office. We employ highly experienced tutors, whose expertise has been gained after years of practical, first-hand involvement in all aspects of using Excel in the work place. This gives them a unique insight into how to get the best out of Excel and your staff, and inspire and encourage your employees to develop their own skills. As a result, you will benefit by having a better informed and more motivated work-force who will appreciate the investment you make in their professional development.

All equipment required to deliver your training course, including laptops if required, is supplied by us, making our onsite training flexible and simple to facilitate, wherever your office is located.

For more information about Microsoft Excel training courses in Liverpool, call free on 0800 2922842 or use the enquiry form located at the top right of this page.

Microsoft Office 2016 Has Arrived!

Microsoft have released their latest version of the Office suite of applications and on first inspection it would appear that little of any major significance has changed. There are some cosmetic differences which are quickly apparent and anyone who subscribes to the Office 365 service may see similarities between Office 2016 and the current online applications. However, the changes are more than just cosmetic and here are a few of what we feel are the more useful functions:

One new tool which is sure to become popular is the shortcut for attaching recently opened documents to emails. When the ‘Attach File’ button is clicked the full list of recently accesses documents is displayed first, including all Word documents and Excel spreadsheets. This is a very handy time-saving feature and already we’re wondering how we ever did without it!

Another potentially handy feature is the ability to search the Internet directly from inside of a Word document, email or even Excel spreadsheet. Simply highlight a word or phrase which you wish to research, then right-click and choose ‘Smart Lookup’. A pane named ‘Insights’ will open on the right with text clips and links to Internet-based resources such as websites, blog posts etc. Perhaps a downside to this feature is that it unsurprisingly uses Microsoft’s own search engine Bing, which  might not yield as comprehensive a search as perhaps using Google would.

If you’re unsure how to go about a particular task in any Office 2016 application, you can now use the new search box facility called ‘Tell Me’. Situated on the Home tab of the Ribbon menu, simply type an instruction into the search box and a list of options will be presented. In Excel for instance, typing in the word Functions enables direct access to the functions menu, including shortcuts to the most recently used.

In conclusion, whilst there is nothing of major significance in this latest version of Microsoft Office which would cause users any issues, there are a number of productivity enhancing tools which do deserve closer inspection.  If you would like to know more about the training options available for Microsoft Office 2016, please call free on 0800 2922842. Alternatively you can email using the Quick Form situated at the top of this page.

MS Office Excel Training Courses in Oxfordshire

Excel training courses delivered onsite in Oxfordshire

The Microsoft Office suite is the world’s most widely used collection of applications for producing documents, spreadsheets, presentations and more, yet without specific training in each individual discipline, the full capability of the software can often go undiscovered.

Microsoft Excel is the first choice for businesses across the globe when a spreadsheet application is required, whether it is used to perform simple calculations or to create a database, or for more sophisticated uses such as performing complex mathematical formulas. An understanding of the basic concepts of Excel is often all a user has, either from being shown how to produce a table or graph and then simply repeating the process, or through the trial and error of teaching oneself.

We specialise in providing in-house training which can open up Excel and help your staff to use the software to its full potential. Working with any level of ability, our highly-experienced tutors can help beginners learn how to input data and carry out basic functions, while more competent Excel users can benefit from understanding macros and creating and using pivot tables. Excel has over 400 features designed to make office spreadsheet tasks easier.

Onsite training is a cost effective way of developing your employees’ skills, saving time by eliminating the need to travel to remote training centres. We bring with us all the training equipment needed, including laptops when required.

We offer in-house training throughout Oxfordshire, in all aspects of Microsoft Excel at foundation, intermediate and advanced levels, from as little as £55 per person. For more information about Microsoft Excel training courses throughout the county & UK, call free on 0800 2922842 or email using the quick form at the top of the page.