Author: Ian Pettit

Tech’ top tips – #28. Here’s looking up you kid

Tweet This tip is provided by the Centre for Enhancing Learning through Technology (CELT). The images in this post will enlarge when clicked – use the Back button to return to the post. It seems as though the Excel tips of recent weeks are being well received so in-keeping with the theme, today’s tip is about the Lookup functions in Excel and Absolute references. Using the lookup functions we can get Excel to search for values within a range and return a result based on a fixed set of criteria. This can be useful when have a large sheet of ... read more

Tech’ top tips – #27. I’ll format that on one condition

Tweet This tip is provided by the Centre for Enhancing Learning through Technology (CELT). The images in this post will enlarge when clicked – use the Back button to return to the post. The way we interpret and respond to data can be linked to how the data are presented. For example, a long list of numbers ordered largest to smallest may not be the best way for everybody to see a pattern but using Conditional Formatting we can apply other visual techniques to help make our data easier to interpret. Using colours in this way, while thinking about ... read more

Tech’ top tips – #26. Update for safety and security

Tweet This tip is provided by the Centre for Enhancing Learning through Technology (CELT). One of the easiest ways to stay safe online is to make sure your devices are up to date. Whether it be an iPhone, Windows PC or any internet connected device; ensuring the latest software updates are installed will help to keep you and your data safe. And remember, it’s not just about the operating system. Applications often require updating and running out of date applications on your device can introduce a security risk. Picture credit www.gotcredit.com read more

Tech’ top tips – #25. It’s not all online – come meet CELT at a drop-in

Tweet This tip is provided by the Centre for Enhancing Learning through Technology (CELT). The weekly Tech’ top tips are brought to you by the Centre for Enhancing Learning through Technology (CELT). Each week CELT holds staff and student drop-in sessions where you can meet the team and get help with the learning technology at DMU. The drop-ins take place in the Kimberlin Library Collaboratory; the same venue as the Maths Learning Centre, opposite Gateway House. Students can drop-in between 12 and 1pm on Wednesdays and staff between 2 and 3pm Tuesdays ... read more

Tech’ top tips – #24. Excel when it comes to data

Tweet This tip is provided by the Centre for Enhancing Learning through Technology (CELT). Currently, my two favourite tools in Microsoft Excel are ‘Text to Columns’ and the ‘Concatenate’ function. Both of these tools really help when we have long lists of data and we need to either sort them or maybe merge data from different cells into one string. Text to Columns enables us to split long strings into individual cells for sorting. For example, a database export containing addresses produces one string per address. By using Data>Text to Columns we ... read more