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.
Posted by
Andy Brown
on 03 April 2024
How one determined person embedded the published ChatGPT 2 source code and weightings within an Excel workbook to give an insight into how AI works
Posted by
Andy Brown
on 03 April 2024
Want a complete list of all of the AI tools available for you to use? Here's a website which lists 32 tools just for sarcastic conversations alone!
Posted by
Andy Brown
on 03 April 2024
Don't consider yourself to be musical? Think again! Now everyone can unleash their inner Taylor Swift, using the Suno plug-in within Copilot.
Posted by
Andy Brown
on 28 March 2024
There are updates to on-object interactions and visual calculations this month, but these major new features still remain in preview. This leaves small changes to data bar and data label formatting - and a new way of doing row-level security - as the only signficant changes in this month's update.
Posted by
Andy Brown
on 27 March 2024
While doing a thorough site audit we came across some pages which we no longer link to, but which we don't want to lose. This blog ensures that you (and Google) can still get to them!
Posted by
Sam Lowrie
on 04 April 2024
Despite the new flow designer in Power Automate going live several months ago, there are still “features” (read bugs) that can cause confusion. This blog covers 5 of these quirks, showing a way to deal with each.
Posted by
Andy Brown
on 04 March 2024
The only big change in the February 2024 update to Power BI Desktop is that "Power BI Home in Desktop" is now enabled by default, but the exciting new visual calculations feature is also now waiting in preview.
Posted by
Andy Brown
on 04 March 2024
Last month we asked you to identify 5 Abba songs from cryptic pictures. Out of 16 correct entries our randomised sorting hat chose the name of Alison Palmer of Devon Council, who wins a £25 voucher. An explanation of the answers follows!
Posted by
Andy Brown
on 04 March 2024
Two little tricks to change the order of columns in SQL Server Management Studio and Power BI Query Editor, which (to our shame?) we've only just discovered.
Posted by
Andy Brown
on 04 March 2024
The Azure map visual has been an official part of Power BI now for nearly a year, and the initial teething problems have now been ironed out. This blog shows how to use the Azure maps visual, and explains why you don't now need to use any of the other map visuals in Power BI.
Posted by
Andy Brown
on 01 March 2024
Power BI is a nightmare to teach, as it keeps changing! Our policy is to update our courseware roughly every 18-24 months; this blog contains details of our latest huge update, and how it will affect delegates on our Power BI courses.
Posted by
Andy Brown
on 01 March 2024
A review of websites whose UI is bad by design (and often very funny as a result), including hard-to-use Captchas, irritating volume controls and date-pickers designed to exasperate.
Posted by
Andy Brown
on 01 March 2024
There's a famous sentence which reads "Time flies like an arrow; fruit flies like a banana". It turns out that this is just one example of a sentence deliberately designed to lead you up the garden path ...
Posted by
Andy Brown
on 01 March 2024
Chat GPT now incorporates a range of mini GPTs dedicated to different tasks. We put a few through their paces, so that you don't have to!
Posted by
Andrew Gould
on 23 February 2024
The February 2024 update to Power BI has an interesting new preview feature: visual calculations. These allow you to create DAX calculations within individual visuals in a report. This blog shows why that's useful!
Posted by
Andy Brown
on 09 February 2024
A series of steps that you can follow to convert UK format postcodes into latitude and longitude data for use in Power BI Desktop visuals.
Posted by
Andy Brown
on 31 January 2024
We've discovered two (more) Windows short-cut keys which will help you work with multiple screens - and there's also a new Copilot key coming to your keyboard soon.
Posted by
Andy Brown
on 31 January 2024
This update includes lots of updates to the formatting of bar/column charts, even more data label formatting options and better clustered bubble chart formatting for Azure Maps.