Excel

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

Explore some of the 9000 video courses available through the LinkedIn Learning Pilot trial

Tweet Boost your skills or feed your curiosity by exploring some of the video courses available through LinkedIn Learning. Develop and improve ‘the most’ in demand business, technology and creative professional skills by accessing online over 7000 online courses and around 300k videos with LinkedIn Learning. Courses ranging from ‘soft skills’, design to programming and much more in this continuous evolving library of courses. Make the most of the opportunity to access to LinkedIn Learning for free as part of our pilot ... 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