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.
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.
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: