Communication / Collaboration · Data literacy · Excel · Working with Data

#402 Muddled data in Excel? Sort it out!

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!

Digital collaboration · Digital communication · Digital creation · ICT proficiency · Images · Internet Explorer · Top tip · Working with Data

#401 Greenshot [1/3]: Free and open source tool for making screenshots on your PC or Mac

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

Classroom technology · Digital creation · Media literacy · Microsoft Office · PowerPoint · Timesavers · Working with Data

#364 Sway [8/8]: Create outline from Sway or Powerpoint

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

Classroom technology · Digital creation · Media literacy · Working with Data

#358 Sway [7/8]: Remix and Re-style

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

Classroom technology · Digital creation · Media literacy · Working with Data

#356 Sway [6/8]: Adding image groups

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

Data literacy · Digital research and scholarship · Excel · Timesavers · Working with Data

#350 Use SumIF in Excel to add conditions to your additions!

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!