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.

Tags:   Power BI | Updates

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!

Tags:   Excel | 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.

Tags:   Power BI | Measures / DAX

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.

Tags:   Websites | Wise Owl website    |    Training | General training

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?

Tags:   Power BI | Measures / DAX

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.

Tags:   Power BI | Measures / DAX

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!

Tags:   VBA macros | General

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!

Tags:   VBA macros | General

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.

Tags:   Power BI | Measures / DAX

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!

Tags:   Power BI | Measures / DAX

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!

This page has 0 threads Add post