I remember back to doing dissertations and digitising tables was a long hand task of manually creating them using Excel and extracting data from books or journals and typing it in. Now with the Excel mobile app you scan a printed table or a screen table and the app scans and digitises the data directly… Continue reading #646 Digitise printed tables in Excel (or from screens)
This top tip helped me recently when adding up the duration of a number of videos for a project. The duration of the videos were in the 24 hour clock format and when I added the duration together the result was not as I expected. The answer was to change the format of the cells… Continue reading #496 Add up more than 24 hours in Excel
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!
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!
In the last couple of posts on Formative, we have explored how to create and share a quiz. In this post we will look at how you can view and export the results (and mark any free-text answers). Featured Image: “Old Trafford score board” by Cheekablue licenced under CC BY-NC-ND 2.0
We saw in an earlier post just how easy it is to filter data in Excel. Filtering is a great tool, but what if you also want to count your filtered data? This is where this handy formula comes into play… Featured Image: “Counting 2” by The Shopping Sherpa licenced under CC BY-NC-ND 2.0
A fixed cell reference allows you to use make use of the auto-fill feature in Excel, whilst ensuring any cell references you want to keep static, remain so. So if you ever find yourself frustrated that Excel isn’t completing your formulas as you’d like, this one is for you! Featured image: ” Red Cells”by Alias… Continue reading #318 Excel formulas behaving weirdly? Try a fixed cell reference
In Excel we can find parts of things. So rather than looking for a chuck of text line “Jones” or “Johnson”, we can find both using wildcards. Wildcards are characters that tell Excel how to search. The asterisk (*) finds any number of characters, while the question mark (?) finds a single character. If you want to… Continue reading #268 Excel wildcard search
Have you ever found that you want to add a line break in an Excel cell rather than adding text to another cell? If so, then this one minute video will show you how through the power of ALT + ENTER… Featured image: “Lines” by 4rj4n is licenced under CC BY-NC-ND 2.0
This Excel tip is particularly handy if you are trying to tidy up a list of email addresses copied from Outlook, or if you have imported in data from another source and need to split it into separate columns. For more hints and tips with Excel, check out our other #1minuteCPD videos. Featured image: “Split… Continue reading #250 Split your text into Columns in Excel