Posted by
Andy Brown
on 25 August 2020
What IS Power Apps? In this blog we try to convey the essence of this enjoyable product, so you can make the decision of whether to invest in it.
Posted by
Andy Brown
on 08 August 2020
Sadly we do occasionally make mistakes in our training, but when this happens we always try to correct them. Here, we explain that Power BI report page tooltips can in fact be any size.
Posted by
Andy Brown
on 15 November 2023
This month's modest update allows you to use Excel financial functions in DAX, show a gradient legend and change your slicer header, among other minor changes.
Posted by
Andy Brown
on 03 July 2020
Did you know that Outlook doesn't include your Deleted Items folder by default when you search? This owl didn't until today!
Posted by
Andy Brown
on 26 June 2020
Windows now lets you retrieve up to the last 25 things you've copied. It does this by keeping a clipboard history, from which you can paste items with a single keystroke.
Posted by
Andy Brown
on 28 April 2020
Clients can now sign on to our website to see a full record of everything they've booked. Wondering if Anna in Accounts has been on an Excel course? Log on to find out!
Posted by
Andy Brown
on 27 April 2020
The ComicGen custom visual allows you to show one of two characters (Dee or Dey) in a variety of poses, and with a range of emotions. Excitingly, the poses and emotions can depend on your data, making these the most human of KPIs. Find out more in this blog!
Posted by
Andy Brown
on 13 March 2020
A website which includes help messages which don't, a password with ridiculous rules, an unhelpful timer, annoying default options for almost everything - thoroughly recommended!
Posted by
Andy Brown
on 13 March 2020
We receive a fair few requests asking us to publish the answers to our exercises. We have now decided to do this, on the understanding that they are for your personal use only.
Posted by
Andy Brown
on 13 March 2020
What happens when you combine the magic of speech recognition with the power of VBA? A user form which you can fill in without a keyboard!
Posted by
Andy Brown
on 12 March 2020
This modest blog explains how you can tell Power BI to show all of the members of a dimension table (even the ones which have no corresponding data).
Posted by
Andy Brown
on 14 February 2020
Dynamic arrays are a new feature being rolled out in Excel 365. This blog explains how they work, and why they will make so many things in Excel easier.
Posted by
Andy Brown
on 13 February 2020
Simple Talk provide excellent how-to guides on any aspect of Microsoft software. We are proud to have contributed a series of articles explaining how to create DAX calculated columns and measures within Power BI.
Posted by
Andy Brown
on 07 July 2023
Microsoft have completely rewritten their Edge browser. The result is (by design) very similar to Chrome - you can even use Chrome extensions -but is probably even easier to use than Google's browser.
Posted by
Andy Brown
on 16 January 2020
Microsoft have brought out a new SQL editor called Azure Data Studio, to act as a substitute for SQL Server Management Studio, but this owl cannot see any justification for its existence!
Posted by
Andy Brown
on 10 January 2020
From SQL Server 2016 onwards you can choose to CREATE OR ALTER a procedure, trigger, view or function, as this blog explains.
Posted by
Andy Brown
on 10 January 2020
When we find new features which we didn't know about, we try to share them! Did you know that you can turn preview off when getting data? Or that you could left-click to drill-through? We didn't!
Posted by
Andy Brown
on 10 January 2020
After a huge investment of time and expertise, we're proud to announce that our first full online training course is now live on our website! The course shows you how to program in VBA in Excel, and is completely free (you don't even have to log in to follow it).
Posted by
Andy Brown
on 25 November 2019
If you're working with different time zones, the AT TIME ZONE keywords introduced in SQL Server 2016 will make your life much easier - this blog explains how they work.
Posted by
Andy Brown
on 18 October 2019
Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.