BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl blogs written by Andy Brown (page 1 of 23)
Showing blogs 1-20 (out of 451)
The view from the other end for an online training course
Posted by Andy Brown on 26 February 2021
You know what an online course looks like as a delegate, but what happens at the Wise Owl end? We thought we'd shed some light on what goes on from a trainer's point of view.
Changes to Power BI in the February 2021 update
Posted by Andy Brown on 26 February 2021
After no update in January, February sees just a couple of small changes to Power BI, but there's a big logjam building up in preview.
How to build an Excel word search without even using VBA
Posted by Andy Brown on 23 February 2021
Details of an impressive new Excel word search system which allows you to recreate a randomised grid every time you recalculate your formulae!
Microsoft seem to be planning a big upgrade to Windows in the second half of 202
Posted by Andy Brown on 23 February 2021
There's a minor update to Windows due in Spring 2021, but a much bigger one in the offing in the second half of the year
Microsoft Office 2021 should be released in the second half of 2021
Posted by Andy Brown on 23 February 2021
Microsoft have confirmed that they will release another standalone versoin of Office in the second half of 2021 - this should include dynamic arrays, the XLOOKUP function and a new dark mode, among other things.
Showing DAX Studio and Tabular Editor as external tools in Power BI
Posted by Andy Brown on 23 February 2021
Power BI automatically creates an External Tools ribbon when you install the Power BI, Tabular Editor and ALM Toolkit add-ins.
You can now view our reviews by course type, software and industry sector
Posted by Andy Brown on 23 February 2021
We've changed the way we store and present client testimonials: you can now search by the type of course (classroom or online), the software taught or the industry sector.
DAX.DO - a replacement for DAX Studio?
Posted by Andy Brown on 22 February 2021
The legendary Marco Russo has launched a new web-based DAX editor, but can it compete with or even replace DAX Studio?
Errors when you delete a primary key in Power BI
Posted by Andy Brown on 22 February 2021
Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.
Buying pre-payment vouchers for Wise Owl training
Posted by Andy Brown on 05 February 2021
This blog explains how you can create a pre-payment account for Wise Owl training, as well as how you can then buy and spend pre-payment vouchers.
Having fun with online Teams meetings
Posted by Andy Brown on 02 February 2021
Did you know that you can apply Snapchat filters to your Teams background? Or show a test card? Or send customised stickers? Read this blog to find out more ...
Distinction between online and classroom training feedback
Posted by Andy Brown on 02 February 2021
Our reviews pages now allow you to see for each testimonial whether it was for an online or classroom training course.
Building a word search system in Excel VBA
Posted by Andy Brown on 02 February 2021
My aim in this blog is to show how you can go about building any computer system from scratch (and not just a word search in Excel VBA). Along the way I've included lots of hints and tips!
Using the WOWSER Excel VBA system to build a word search
Posted by Andy Brown on 01 February 2021
Follow this blog to construct your own word search, complete with a missing phrase spelt out by the unused letters!
This month we invite you to complete our word search and find the missing item!
Posted by Andy Brown on 01 February 2021
This month's competition is a word search grid containing 47 missing (related) items - plus one more hidden in the unused cells.
Results and winner of our January 2021 Newsletter Quiz Competition
Posted by Andy Brown on 01 February 2021
Congratulations to Amanda Wilding of ReAssure for winning last month's competition - see which question people found easiest (and which they found most difficult), and how many people got all of the questions correct
Our three-day fast track courses are now available as scheduled courses
Posted by Andy Brown on 01 February 2021
To cater for the needs of the select few who can cope with them, we've now published dates for our three-day fast-track courses (previously these were only bookable as in-company tailored courses). Book with care!
How to use DAX to show for each row of a table its share of the maximum value
Posted by Andy Brown on 22 January 2021
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.
Using a DAX query to show a table in Power BI
Posted by Andy Brown on 14 January 2021
Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!
A book, a board game and a box set to get you through lockdown
Posted by Andy Brown on 05 January 2021
It's not often that you find a brilliant book, board game and box set over Christmas all of which you can recommed without reservation, but this blog is proof that it can happen!