by - 5/5/2019

Selecting cells in Excel

There are various ways in which you can select cells in Microsoft Excel, using the mouse, keyboard or a combination of the two. There are also short cuts you can use, if you are selecting cells which contain data.


by - 5/5/2019

Introduction to Excel VBA Part 1

This article is aimed at users who have a basic knowledge of Excel VBA.


by Mandy Doward - 10/8/2016

PTR Training Courses Now Running in London

We have launched selected courses running at our new London Location.

Our most popular courses will now be offered at both our Wokingham Training Centre and our new London location in Ealing, just 30 minutes away from Covent Garden and the many attractions that London has to offer.

For more information please give us a call or email us at info@ptr.co.uk. More information and course dates will appear on our website soon.

 


by Mandy Doward - 22/8/2016

Working with Multi-Table Queries That Only Require Columns From One Table

In July I published Part 1 of this series of blogs which explores the many ways of tackling a multi-table query. 


by - 5/5/2019

Microsoft Word Tables

Welcome to Part 2 of Working with Tables in Microsoft Word. (If you missed Part 1, click here)

In Working with Tables in Microsoft Word - Part 2 we will look at:


by Mandy Doward - 20/7/2016

SSMS 2016 New Feature – Compare Query Execution Plans

Management Studio in SQL Server 2016 has introduced a great new feature: Compare Showplan.


by Mandy Doward - 15/10/2024

Customised, bespoke training designed for you and with you!

We offer more than just a schedule of courses. You tell us what you want and we do our best to put it together for you.

We have been busy over the last few months!

We offer you:


by Mandy Doward - 20/8/2018

SQL Queries to Retrieve Records from Multiple Tables

Relational databases store data in tables and we can retrieve information with SQL SELECT statements accessing one or more tables.


by Mandy Doward - 9/6/2016

Display SQL Server Index Details – Type, Key Columns, Included Columns

Have you ever wanted a query that would give you a list of all the indexes that exist in your database along with details of the index type and all the columns that are a part of the index key and all included columns?

Well have a look at this query. It might help:


by Mandy Doward - 9/6/2016

In this article “Excel is more than a calculator! - Part 2” we will be looking at Pivot Tables, Pivot Charts and Filters. If you have never used these before prepare to be impressed!

Microsoft Excel Pivot Tables & Pivot Charts

Pivot Tables and Pivot Charts enable you to explore your data and analyse business measurements in different ways, for example:


Pages