Posted by
Andy Brown
on 29 October 2022
To try to show what developing Power Automate flows is like, we've created two blogs: one listing out its 5 best features, and one listing its 5 worst ones. This is the pessimistic one!
Posted by
Andy Brown
on 28 October 2022
Notepad is a well-known text editor, but is less well-known for its capacity to host games of Doom - with good reason.
Posted by
Shaun Wantling
on 28 October 2022
A simple way to ensure that SSRS allocates colours consistently to different charts in an embedded table
Posted by
Andy Brown
on 28 October 2022
Microsoft Forms is a joy to use! This blog will show you how to create and distribute a survey or quiz, and the type of whizzy features that you can build into it.
Posted by
Andy Brown
on 27 October 2022
Another small update, allowing you to reverse the stack order of column charts and edit DAX formulae in model view, but not much else.
Posted by
Andy Brown
on 06 October 2022
SQL Server 2022 is now in preview (you can download an evaluation copy). It includes new functions to split strings, trim text and truncate dates, among other things.
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!