We recommend that all heavy users of PowerPoint learn the short cut keys. These speed up your work considerably as you don’t need to take your hands off the keyboard to then find the command that you want before resettling…
In Outlook MailTips are turned on by default, this guide shows you how to disable them. For advanced Outlook users, MailTips can get in the way without providing new information. For similar articles, read our Outlook Guide on the To…
The TRANSPOSE function inverts rows and columns. If you have ever had your data laid out and then realised it would be best the other way around: This is the function for you! It’s one of the best ways…
Transposing is rotating or rearranging your data. Paste Special Transpose is a simple way to change the orientation of your data. This gives you much better control of your page layout! Paste Special Transpose We have a sample sales…
Occasionally you may find that it’s necessary to clean up your data and part of that cleaning up, may involve removing blank rows or blank cells. In this post, we are going to show you how to remove blank…
The To Do Bar is the panel on the right of the Outlook screen. By default, it is not turned on – so let’s find out how to enable it. We always cover it on our Outlook courses, as…
Conditional Formatting formats a cell or group of cells based on your own conditions. There are a lot of options, but they are all simple to implement with this guide! On our Excel Courses, we teach a wide range…
Even expert excel users can sometime face issues with structuring data using the copy and paste function in excel. This is especially useful when you have tons of disaggregated data. To help with that, we’ve got the Excel concatenate function…
We are all familiar with Tables from common applications such as Microsoft Word or Excel. Those of us who are involved in printing or in publishing need to know how to create and manage tables in InDesign. This guide will…
Creating a Contact Group allows you to email a specific group of people easily at any time. This guide will take you through how you can set up these Contact Groups in Outlook step-by-step. If you are looking for more…
Creating a simple macro in Excel is easier than you think. Now, it may seem contradictory, but you do not need to learn Visual Basic for Applications (VBA) to record simple macros in Excel. VBA does, however, come in handy…
Send a lot of Excel links to colleagues? Here’s a quick tip to speed things up by doing without even opening Outlook! From within your file, all you need to do is go to the ‘File’ tab and hit…
