Posted by
Jenny Brown
on 22 November 2019
The story of Wise Owl starts in a basement in Chorlton-cum-Hardy in 1992, at a time when WordPerfect for DOS was still widely used and Lotus 1-2-3 ruled the spreadsheet roost.
Posted by
Shaun Wantling
on 22 November 2019
People become trainers for many different reasons. In this blog, Shaun explains his journey from being an accountant to training people in IT.
Posted by
Sam Lowrie
on 08 November 2019
This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.
Posted by
Sam Lowrie
on 28 October 2019
The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!
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.
Posted by
Andy Brown
on 14 October 2019
It's fairly easy to create a simple Excel worksheet to chart your weight, but this master class shows you lots of tips and tricks to make the final result quicker to create and easier to use.
Posted by
Andy Brown
on 20 September 2019
The CONCAT function makes it much easier to join columns together, while the STRING_AGG and CONCAT_WS functions make it easier to create things like comma-delimited lists.
Posted by
Andy Brown
on 20 September 2019
How to create a new app to view your Google Analytics data in Power BI Service.
Posted by
Andrew Gould
on 19 August 2019
Lots of our training material uses examples related to movies but did you know that Wise Owl has several tenuous connections to famous films?
Posted by
Andy Brown
on 14 August 2019
In addition to the Power BI preview features dialog box, Andy Gould has discovered two excellent new sources of information on forthcoming changes for Power BI, as this blog explains.
Posted by
Andy Brown
on 14 August 2019
Want to make a worksheet inexplicably change colour, and display strange text in cells? This blog explains how you can do this using the Normal style.
Posted by
Andy Brown
on 14 August 2019
The previous blog listing great OOH moments in Excel omitted one of the biggest - the absolute quickest way to create a chart.
Posted by
Andy Brown
on 05 August 2019
For nearly all new Microsoft software updates Wise Owl are prepared to wait before commenting, but the new Office 365 icons are much harder to read and distinguish than the old ones!
Posted by
Andy Brown
on 05 August 2019
Most people will be on either the monthly or semi-annual update channel for Office 365. This blog shows how you can find out which channel you are on, and how to change your channel.
Posted by
Andy Brown
on 02 July 2019
Did you know that you can view the SQL for a query in Power BI's Query Editor? Me neither!
Posted by
Andy Brown
on 17 June 2019
This month it's Shaun's turn to nominate the five best short-cut tips in Excel.
Posted by
Andy Brown
on 17 June 2019
If you want to spice up your emails or reports, use this Windows shortcut to insert emojis.
Posted by
Andy Brown
on 17 June 2019
This short blog highlights a quick way to copy the full path (including the file name) of a file in Windows Explorer.
Posted by
Andy Brown
on 17 June 2019
Some people are experiencing problems when trying to suppress screen updates while macros are running in Excel VBA, under Windows 10. This blog gives one possible solution.
Posted by
Andy Brown
on 17 June 2019
When you discover a new short-cut key, should you share it? This blog shows a way to bring up Intellisense for the arguments to user-defined functions in Excel VBA.