Posted by
Andy Brown
on 27 February 2023
Learn how to get individual Excel cells to contain sparklines to show trends, how to display column charts or win/loss charts instead, how to play about with grouped charts, how to change sparkline formatting and how to customise sparkline axes.
Posted by
Andy Brown
on 27 February 2023
If you turn on this experimental feature in Edge you can show two webpages side by side (you can even choose what proportion of the screen each side occupies).
Posted by
Andy Brown
on 01 February 2023
We're delighted to welcome Simone Tyler-Gould as our new part-time marketing manager!
Posted by
Andy Brown
on 01 February 2023
You've always been able to add images within worksheets, but now for the first time you can add them within cells - which is strangely satisfying!
Posted by
Andy Brown
on 01 February 2023
Microsoft have sneaked in a new short-cut key to invoke the Power Query Editor, but in the course of researching this we also unearthed 4 other key combinations which we suspect even diehard Excel users may not know about.
Posted by
Andy Brown
on 01 February 2023
Although we currently just train in T-SQL for SQL Server, there are many other dialects of this database language: such as MySql and PL/SQL, for example. Which ones would you like Wise Owl to run courses in?
Posted by
Andy Brown
on 31 January 2023
It's taken a long time, but you can now finally get a downloadable PDF file of your Wise Owl course manual, to go with the paper copy.
Posted by
Sam Lowrie
on 30 January 2023
How to use Radacad's clean-up tool to see which of the columns and tables in your Power BI data model you're not using.
Posted by
Andy Brown
on 30 January 2023
Can you remove all of the formatting that you've applied to a visual? Apparently you can, although this new feature was never announced in an update.
Posted by
Andy Brown
on 30 January 2023
This update make slicer formatting much more consistent (a welcome change), and introduces 3 fairly complex new DAX functions (OFFSET, INDEX and WINDOW).
Posted by
Andy Brown
on 06 December 2022
The Orb X gaming chair comes with a leather chair, support for 3 screens, surround sound and much more besides, and will be the perfect Christmas gift for the geek in your life when it becomes available for purchase.
Posted by
Andy Brown
on 05 December 2022
We've added sections on Power Apps and Power Automate to our two-day Advanced Power BI (Data) course, and downgraded 3 topics to be covered only if time allows to make room for these.
Posted by
Andy Brown
on 05 December 2022
Not sure whether to choose Report Builder paginated reports for printing or Power BI interactive ones for showing on screen? Now you don't have to choose, as this blog explains.
Posted by
Andy Brown
on 05 December 2022
This update includes the roll-out of field parameters, separate Y axes for small multiples and new DAX debugging functions - and a new colour for Power BI!
Posted by
Andy Brown
on 02 December 2022
What happened to our PyQt5 editor? Well - not much, sadly. We've given up on this approach now and are reverting to a website solution - this blog explains why.
Posted by
Andy Brown
on 02 December 2022
Wise Owl (and Sam specifically) presented a sample Power BI report that we had created to APSE in Blackpool - take your place in the audience!
Posted by
Andy Brown
on 02 December 2022
Words.Net is a utility which allows you to build and edit Microsoft Word documents in C# rather than VBA. Should you adopt it? Read this review to find out!
Posted by
Andy Brown
on 02 December 2022
Last month we sent out a survey - here are the results, showing a) how Microsoft Forms allows you to report on survey data and b) what people think of us!
Posted by
Andy Brown
on 30 November 2022
This blog gives the background to Microsoft's decision to roll out Office Scripts, and explains why you might want to learn how to automate Excel using scripts, rather than VBA (and how you'd then go about doing this).
Posted by
Andy Brown
on 29 October 2022
A separate blog lists the 5 worst things about Power Automate; this more positive blog lists its 5 best features!