Posted by
Andy Brown
on 03 July 2024
Microsoft are introducing two new functions to Excel: TRANSLATE (to translate passages of text into another language) and DETECTLANGUAGE (to determine the language in which a particular passage of text is written).
Posted by
Andy Brown
on 03 July 2024
You can now add a checkbox to a cell with a single mouse-click. They look good, although it's hard to ensure that only one checkbox in a range is selected.
Posted by
Andy Brown
on 20 June 2024
In computing it's enough to solve a problem, but as a bonus it's nice to do so in the most elegant way (although elegance is a subjective quality). This blog gives my 3 favourite ways to solve last month's Excel desert island competition.
Posted by
Andy Brown
on 20 June 2024
This month's update to Power BI Desktop adds some seriously arcane functions to DAX, but it's the roll-out of the Power BI Home feature which most people will notice.
Posted by
Andy Brown
on 06 June 2024
This month we ask you to travel to the terrifying Skull Island and find the hidden treasure buried there, armed only with some - unlikely - Excel clues
Posted by
Andy Brown
on 05 June 2024
Apologies for making this word search slightly harder than usual - you can see the answer in this blog, as well as discover who was the lucky win of the month's prize
Posted by
Andy Brown
on 05 June 2024
StackOverflow and OpenAI have announced a partnership, but I think it's fair to say that not every StackOverflow user is sold on the idea ... !
Posted by
Andy Brown
on 05 June 2024
If you love Excel and are also a fan of regular expressions, your Christmas has come early! And if like me you don't know how to create regular expressions, you can just get an AI tool to build them for you ...
Posted by
Andy Brown
on 05 June 2024
The Northwest Computer Museum not only has a vast array of old hardware, software, documentation and games on displays, but allows you to interact with much of this. Time to brush up your BBC Basic programming skills?
Posted by
Andy Brown
on 04 June 2024
The PQ How site contains both a reference guide to the M language and lots of links and resources for articles which will help you to learn it.
Posted by
Andy Brown
on 04 June 2024
We thought it might be useful to share the theme that we use for some of our reports, with some annoations, to give you an idea of what's possible when setting default Power BI formatting
Posted by
Andy Brown
on 04 June 2024
This month's bigger than average update sees new pivot table style matrix layouts, the emergence of modern tooltips, calculation groups and the DAX query pane from preview and a couple of other smaller changes.
Posted by
Andy Brown
on 08 May 2024
You can now add Copilot to your 365 licence, although it isn't cheap - this review looks at whether the benefits outweigh the costs.
Posted by
Andy Brown
on 07 May 2024
The April 2024 Power BI update includes a new 100% stacked area chart visual and some minor new line chart formatting options - but still none of the big beasts lurking in preview!
Posted by
Andy Brown
on 03 May 2024
Congratulations to Samantha Wareham of Mid Cheshire Hospitals NHS Trust for winning our Easter quiz (out of the 47 answers received, hers was the entry chosen by our randomised Excel sorting hat). You can see some further analysis of the answers in this blog.
Posted by
Andy Brown
on 03 May 2024
Our grid contains 24 hidden thematic treats. Once you've found them all, the unused letters will spell out a message. Email this to us and you have a change of winning a £50 voucher!
Posted by
Andy Brown
on 03 May 2024
We've created two new sections in our website: to house full-blown tutorials and (at the other extreme) short tips.
Posted by
Andy Brown
on 04 April 2024
On-object interaction remains stubbornly in preview in Power BI, but it's been steadily updated since we last blogged about it, so we felt it was time for this catch-up.
Posted by
Andy Brown
on 03 April 2024
The Ajelix Excel AI tool claims to help you generate formulae in Excel - so we put it to the test
Posted by
Andy Brown
on 03 April 2024
Microsoft would much prefer it if everyone switched to a subscription model for Office licensing, but they aren't abandoning the sale of standalone software applications just yet.