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!
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.
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.
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!
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).
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.
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.