BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl Blogs - Home (page 1 of 29)
Showing blogs 1-20 (out of 572)
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!
A new type of Power BI licence: Premium per user
Posted by Andy Brown on 05 January 2021
Microsoft have announced a new type of licence for Power BI called Premium Per User, which sits halfway between the current Pro and Premium licences.
New Office 365 skills assessment tests now available
Posted by Andy Brown on 05 January 2021
We've published 5 new skills assessment tests, for Access, Excel, PowerPoint, Word and general Office 365, allowing you to test people's knowledge of the latest version of Microsoft Office.