Excel Hacks & Tips

30+ MS Excel Hacks & Tips That Even Your Grandma Would Love

Microsoft Excel is without a doubt the best spreadsheet program on the market and the one most used by businesses, students and individuals. Excel allows you to store data, dates and numeric values. You can create formulas, charts and graphs to help you analyze your data better. Microsoft has built in many shortcuts to make it easier for those using …

Microsoft Access Lookup Wizard

Microsoft Access Lookup Wizard

The Microsoft Access Lookup Wizard is a very useful feature. It appears as one of the field data types, and is used for fields which have a restricted list of possible values. This may be either if the field is a foreign key (in which case the appropriate value is usually drawn from the list of values in the matching …

Microsoft Excel Tricks Tips

5 More Really Useful Excel Tricks & Tips

Excel Tricks Tips and More Goodies This article contains 5 extra Excel Tricks Tips and more sage advice on using Microsoft Excel. 5 – Driving your Computer – Shortcuts (Excel Tricks Tips) During our training courses it is very apparent that Delegates all have their preferred methods of driving their computer and I find it interesting just how committed Delegates are …

Microsoft Excel Time Resolution

Microsoft Excel Time Resolution

Can We do Precision Timing in Microsoft Excel? As I watched the Olympic Games I was reminded of the importance of accurate timing. So how precise is Microsoft Excel time resolution and what tricks and limits are to be found? In our blog “Automatic Data Type Conversion Problems in Excel/ Dates – The Big Issue” we explain how Excel stores …

Microsoft SharePoint Office 365

7 Essential Productive Office 365 SharePoint Techniques

This article presents 7 essential productive Office 365 SharePoint techniques. One of the things we get asked about when speaking to customers about SharePoint is what is the difference in the two product editions of SharePoint? The On Premises edition, which you are probably most familiar with is SharePoint Server which is run on a physical server at your premises …

Excel tips and tricks

5 Really Useful Excel Tricks & Tips

These really useful Excel tricks and tips can increase your productivity and save you time. 1 – Repetitive Operations Repeat Last Action F4 or Ctrl + Y Life is full of repetition and most of the time not only is that boring but we are not always consistent. Using function key F4 (When the mode indicator = READY) will repeat …

SQL Union Query

Use SQL Union Query to Merge Different Data Sources

How to Use SQL Union Query Background Where is the SQL Union query used? Well, one of our regular SQL support topics is where an organisation’s data is spread across different data sources and there is a need to combine the results into a single report. A supplementary issue is to identify in the results set just where the data …

SQL pattern matching

SQL Pattern Matching Issues with Unicode Datatypes

How to use SQL Pattern Matching When doing SQL pattern matching as you perform Select Queries in SQL it’s frustrating enough that data is often not quite what is expected with rogue characters and extra spaces that we hadn’t planned for. But there is another little twist with regard to trailing spaces which waits to trip you up in Microsoft …

Microsoft Excel Data Entry

Microsoft Excel Data Entry Techniques

This article describes various Microsoft Excel Data Entry techniques and gives different methods for data entry that may be a useful alternative to entering data manually or moving/coping. Microsof Excel Data Entry Autofill When a cell is selected, it is surrounded by a border, the “cellpointer”. In the bottom-right of the cellpointer is a tiny box, the autofill handle. Moving …

Microsoft Excel Range Selection

Microsoft Excel Range Selection

Microsoft Excel Range Selection Techniques. This article describes various Microsoft Excel Range Selection techniques and shows different methods for selecting one or more ranges in an Excel worksheet. SHIFT key Many Excel features require the user to pre-select a range, possibly of many cells in size. An obvious method is to click and drag over the required range, but this …