This page has 0 threads | Add post

Newsletters

Wise Owl's monthly (ish) news tweet | Issue 56 - May 2022

The items included in this newsletter are listed below. Our newsletter go out about once a month - if you'd like to subscribe, just let us know!

You wait ages for a new Excel function and then 14 come along at once

Excel is getting 3 new text functions, making it much easier to extract one (or more than one) string of text from another, as well as 11 functions to help you to resize, collapse, expand or join arrays. See whether your life will change by reading our full review of all of the new functions.

Also coming to Excel soon - the excellent new Navigation Pane

Excel is getting two new views. We don't work much on reviewing workbooks, but if you do Sheet View will let you suspend reviewing to work on a document in isolation. Of more interest is the new Navigation Pane, which lets you move between the worksheets, tables, ranges, charts and buttons in a workbook. You can see details of both new views here.

30th anniversary charity giveaway

Wise Owl is 30 years old in May. To mark the occasion we're giving 30 pounds to UNICEF to support Ukranian (and other) refugees for each of our bookings in May (we're expecting the total donation to be about £1,500). We've also got a glossy new 30th anniversary logo on our website!

A new Power BI update, a Power Platform roadmap from Microsoft and an exciting Power Query discovery

The April Power BI Desktop update had some new formatting options for matrices and chart legends, but that's about it. However, in developing our new Advanced Power BI (Data) course we discovered that you can get Power BI to extract just the external links from a table of website URLs - surprisingly easily. Finally on Power BI, we've unearthed a 146-page Microsoft PDF file online showing future changes over the next 6 months for all Power Platform applications (although it has to be said that we didn't read anything to quicken the pulse).

This month's picture quiz competition, and an embarrassing revelation

It's picture quiz time! In this month's quiz all of the 20 questions are about May, and you have 20 minutes to decide on your answers. Wise Owl quizzes are not for the faint-hearted, so don't be too despondent if you can't do some of the questions - everyone gets a chance to win this month's rollover 100 pound Amazon voucher, with your chances of winning greater the more questions you get right. Last month's logic puzzle sadly managed to contain a logical error, for which we apologise (the author has been sent to a retreat in Kazkhstan for a month). Because of this we felt unable to award last month's prize, so we've rolled it forward to this month.

A couple of slightly amusing software Easter Eggs

Easter Eggs (hidden features in software) aren't what they used to be, but you can still defy gravity in Python (if using Visual Studio Code as an editor), and inadvertently create Excel worksheets with foreign names. Both of these "features" are described here.

Two more geeky T-shirts to add to your collection

Following last month's collection of T shirts for nerds, here are two more T shirts ideally suited for the logician in your life.

Note that to keep our website content up-to-date we only publish newsletters from the last 3 calendar years.

This page has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

Wise Owl's monthly (ish) news tweet | Issue 56 - May 2022

You wait ages for a new Excel function and then 14 come along at once

Also coming to Excel soon - the excellent new Navigation Pane

30th anniversary charity giveaway

A new Power BI update, a Power Platform roadmap from Microsoft and an exciting Power Query discovery

This month's picture quiz competition, and an embarrassing revelation

A couple of slightly amusing software Easter Eggs

Two more geeky T-shirts to add to your collection

Head office

London

Manchester