Posted by
Andy Brown
on 28 September 2022
Sure, you often turn to StackOverflow to find why a formula isn't working, but are you missing a trick? The site can also help you design solutions to cope with a zombie apocalypse.
Posted by
Andy Brown
on 28 September 2022
You can now format reports differently for mobile view and display X axis labe`s hierarchically by default. One other tiny change is that default column titles in tables now include the summarisation method used.
Posted by
Andy Brown
on 27 September 2022
This blog shows how you can create a flow in Power Automate to send yourself a notification whenever someone makes a change to a file in a given OneDrive folder (the blog is designed to give you a good overview of what working with Power Automate is like).
Posted by
Andy Brown
on 15 September 2022
Did you know that you could combine range names and legacy Excel 4 functions to list out the worksheets or range names in your workbook - wthout using macros? I didn't either - here's how to do this, and much more!
Posted by
Andy Brown
on 02 September 2022
Four examples of using spill arrays to introduce elegance solutions into your spreadsheets.
Posted by
Andy Brown
on 02 September 2022
We review the new Wise Owl bean-to-cup coffee machine, and (at the other end of the scale) a £54,000 samovar for serving tea.
Posted by
Andy Brown
on 02 September 2022
Worried that you're having to type in your second language, English? Help is at hand, with these two specialist Lord of the Rings keyboards.
Posted by
Andy Brown
on 01 September 2022
There's a tiny change to conditional formatting of data labels this month, but that's about it!
Posted by
Andy Brown
on 26 July 2022
A new Excel feature allows you to get data from pictures (you can even review the suggestions before finally inserting the data into your spreadsheet).
Posted by
Andy Brown
on 26 July 2022
Microsoft have released a completely new version of Outlook to some beta channels, parts of which will look familiar to you if you already use Outlook.com. This blog shows you what you can expect to see!
Posted by
Andy Brown
on 25 July 2022
You can now display error bars in charts, as well as formatting them and adding error labels.
Posted by
Andy Brown
on 18 July 2022
Will you soon need to modify a downloaded file's before you can run macros contained in it? Yes … and then no (and now maybe).
Posted by
Andy Brown
on 18 July 2022
Andy B claims to be good at only two things in life: crosswords and time management. Having blogged about the first before, it's time to give some tips on how to make your working life more efficient.
Posted by
Andy Brown
on 05 July 2022
Watch Jacob Chandler from Oregon pick out each letter from a tin of alphabet spaghetti in a little over 2 minutes!
Posted by
Andy Brown
on 24 June 2022
If you’ve been following the saga of the weight-loss competition between Sam and Shaun, you'll be wondering whether the loser got a tattoo showing the winner's name. Wonder no longer!
Posted by
Andy Brown
on 22 June 2022
It's a tad confusing having two software applications from Microsoft with such similar names, particularly when they do such different things! This blog tries to clear up the confusion.
Posted by
Andy Brown
on 22 June 2022
This blog will be updated in the next few days.
Posted by
Andy Brown
on 21 June 2022
If you need to build a GUI system in Python, PyQt5 is probably the best choice, but don't take our word for it - read this blog and see what you think.
Posted by
Andy Brown
on 21 June 2022
An explanation of why our current HTML editor needed replacing, how we decided what technology to go for and the solution we ended up adopting.
Posted by
Andy Brown
on 20 June 2022
Following last month's high-level comparison between Power BI and Tableau, what aspect of these two popular BI software tools would you like us to focus on next?