Wise Owl Blogs - Home (page 4 of 32)

Showing blogs 61-80 (out of 632)

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 version 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!

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.

Tags:   Power BI | General

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.

This page has 0 threads Add post