This week’s Quick Tip shows you how to make use of simple formulas to quickly change text into UPPER, lower or Proper case, both in Microsoft Excel and Google Sheets.
If you’d like to see more hints and tips on how to get the best out of the software and apps you use every day, take a look at our YouTube channel. Follow us for regular updates!
In our quick tip this week we show you an easy way to ensure that your shapes and lines stay regular and in proportion in PowerPoint and Google Slides, simply by using the Shift key.
Think you know Gmail? There are many features within the settings menu that help you manage your mailbox efficiently, many of which are seldom used but can be of great benefit. In this week’s quick tip we show you how to find and use some of these.
In today’s quick tip we show you some different methods to make reading a document a little more user-friendly in Word and Docs, by hiding the whitespace and showing more text on screen.
In this week’s quick tip we show you how to select multiple spreadsheet tabs in in either Word or Sheets, and apply an action to all of those tabs at once.
In this week’s quick tip we show you how to get more creative with images in PowerPoint and Google Slides, by using built-in tools to crop them into shapes such as circles, arrows, stars and more.
In this week’s quick tip we show you how it’s possible to see overall project summary statistics from within the Gantt chart view in Microsoft Project by adding the project summary task.
In today’s top tip we show you a very simple and fast way to translate your document into another language, which can be used no matter whether you’re using Microsoft Word or Google Docs.
Today’s quick tip shows you how to use the SORT function to keep your dropdown list items in A-Z sort order in Excel and Sheets. This video assumes prior knowledge of Data Validation for dropdown lists!
In this quick tip we show you how to make use of the powerful TOROW and TOCOL functions that allow you to combine data from a range of cells into a single row or column. The process is exactly the same in Google Sheets and Microsoft Excel.