If you are trying to move grades from one spreadsheet to another, or cross reference your data, then it can be a real pain if the data is not sorted in the same way. In this short video we cover how to sort your data alphabetically or by custom fields. Featured image: ” Sorting” by… Continue reading #402 Muddled data in Excel? Sort it out!
If you liked #1 Snip it! you are going to love Greenshot. Greenshot is like Snip it but has loads more features to create that perfect screenshot. Whether you are a PC or Mac user, Greenshot is completely free and open source. Some of the key features for Greenshot includes (taken from the Greenshot website): Quickly create… Continue reading #401 Greenshot [1/3]: Free and open source tool for making screenshots on your PC or Mac
This is the final post in our Sway series. Do you like Sway so far? Why not leave a comment below? In this video we look at generating an outline in Sway either from a PowerPoint file or by adding a topic and letting Sway generate an outline for us. Once Sway creates the outline we… Continue reading #364 Sway [8/8]: Create outline from Sway or Powerpoint
This video is the 7th in our Sway series and demonstrates how you can edit your Sway’s layout and style. You can adjust the look and feel and adapt the font. You can hit the magic button and trust in a sway “Mix” or adapt that if you’re not happy with the result. This video… Continue reading #358 Sway [7/8]: Remix and Re-style
This video is the 6th in our Sway series and demonstrates how you can set up slideshows or video galleries. Sway allows you easily to group content together and present it in a gallery. With just a few clicks you can have an image gallery in grid, deck or sweep style and have it on… Continue reading #356 Sway [6/8]: Adding image groups
As we’re seen in previous posts on Excel, Excel is full of nifty little tricks to help make our lives much easier. In this post we take a look at the SumIF function. This function enables you to set conditions on what you want to add together. These conditions can come from another cell, for… Continue reading #350 Use SumIF in Excel to add conditions to your additions!
This is the fifth post in our Sway series. Do you like Sway so far? Why not leave a comment below? In this video we look at adding and formatting text cards in Sway. The text editor in Sway is very straightforward and requires little customisation. For the less confident, if you can format a Word… Continue reading #348 Sway [5/8]: Adding text cards