Posted by
Andrew Gould
on 01 November 2024
You may be familiar with using pivot tables in Excel to group and aggregate a list of data. Did you know that you can now do the same thing using simple functions? This blog shows you how to use the new GROUPBY and PIVOTBY functions to quickly summarise data.
Posted by
Andrew Gould
on 07 September 2024
Not every set of data you want to import from a web page is considerate enough to exist as an HTML table. Fortunately, you can give examples of the information you want to import to have Power BI infer a table from the data on the page.
Posted by
Andrew Gould
on 01 August 2024
In Excel VBA it's pretty easy to create event procedures which apply to a single worksheet or workbook. But what if you want an event to work in every workbook you open? This blog explains how to create application level event procedures in Excel VBA. You'll learn how to create a class module, how to declare application variables which support events and how to enable and disable application level events.
Posted by
Andrew Gould
on 05 June 2024
We've recently published a new set of exercises for our SQL training courses based on a database of concert tours. This blog provides a brief tour of the database and how to tackle the exercises on our website, even if you haven't attended a Wise Owl training course.
Posted by
Andrew Gould
on 09 May 2024
It's my 20th anniversary at Wise Owl this month! I'm celebrating in style with a Power BI data model and report summarising some statistics from the past two decades of teaching IT courses.
Posted by
Andrew Gould
on 08 May 2024
It's the BASIC programming language's 60th birthday this month! Some of the Owls have been reminiscing about their first forays into programming and I wrote this blog as fun look back on my own experience.
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
Andrew Gould
on 29 June 2023
Until recently, if you wanted to automate a Microsoft Excel workbook your only real choice was the VBA (Visual Basic for Applications) programming language. Now, there's a new option for adding code to Excel: Office Scripts for Excel. There are many similarities between Office Scripts and VBA, as well as some significant differences. This blog provides a comparison of the two systems.
Posted by
Andrew Gould
on 31 January 2022
Have you played Wordle yet? You should, it's great! We're a bit obsessed with it at Wise Owl so Andrew, Andy and Sam have all been working their own versions of the game in VBA, Python and Power BI(!) respectively. Check out this quick intro to Andrew's VBA version.
Posted by
Andrew Gould
on 19 July 2021
Confused about the difference between Power BI Reports and Power BI Paginated Reports? Allow this blog to clear up the confusion!
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
Andrew Gould
on 07 July 2023
Power BI encourages you to publish reports to an online service so that you can share your beautiful reports with the world. If you'd rather keep them a secret you can use Power BI Report Server to deploy your reports to an on-premises server, as this blog series shows you.
Posted by
Andrew Gould
on 26 November 2015
You can give your VBA code a performance boost by simply turning off screen updating while your code runs. This blog explains how to achieve this and how to create a basic timer to test the results.
Posted by
Andrew Gould
on 31 October 2014
This blog serves as the main index for our complete tutorial on programming in Visual C#. You'll find links to all of the articles, videos and files that you'll need to follow the tutorial.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial explains how to add sounds to the game using a Windows API function.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial implements a state system to make it easier to determine what actions to perform each time the game updates.
Posted by
Andrew Gould
on 24 April 2014
In this part of the tutorial you'll learn how to make the game detect collisions between the bird and the obstacles.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial shows you how to add obstacles to the game and how to make them move across the screen.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial explains how to generate a game worksheet using code to define the playing area.
Posted by
Andrew Gould
on 24 April 2014
This part of the tutorial introduces the concept of class modules and shows you how to use them to organise your code.
