This page has 0 threads | Add post

Newsletters

Wise Owl's monthly (ish) news tweet | Issue 61 - October 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!

We've published our course schedule up to the end of June (and some other course summary pages too)

We've published our single-page diary of courses to the end of June 2023 (you can also see a single-page summary of the courses we give). We will be happy to add more classroom courses if demand warrants it (the majority of our training is still online for now): just ask! If you book a place on a course, we almost certainly will never cancel it; or if you can't see the course you want, ask us about running a tailored course at your company.

Leveraging hidden legacy Excel 4 functions to list out worksheets, range names and much more!

Did you know that you can use legacy Excel 4 functions like GET.WORKBOOK, GET.DOCUMENT and NAMES to list out worksheet names, range names, cell details and much more without using macros? We didn't either, until a client (thanks, Jenny M!) showed us that it was possible - here's why and how.

A taste of Power Automate: a flow to send you an email notification whenever someone updates a file

Our first Power Automate course is set for delivery at the start of November, so you may well see a series of blogs about creating flows to run in the cloud over the coming months. To give you a flavour of what's possible, here's an outline of how you can attach a flow to a OneDrive folder to send you an email notification whenever anyone modifies any file within it.

It's another small update to Power BI this month, contrary to Microsoft's published release plan

The September 2022 update to Power BI is small (contrary to the published released plan for changes to Power BI up to March 2023). You can now format reports independently for mobile view and show hierarchical charts properly by default (the default column titles for aggregated fields in tables also now include the aggregation method used).

The answer and winner for last month's word search, and some zombie advice

Congratulations to Sarah Middlebrough for being the primus inter pares of the 21 people who returned a correct solution to last month's word search competition (you can see the answer and 3 hidden film titles here). To compensate for the lack of a compettiion in this newsletter, we've included StackOverflow's useful advice for dealing with a zombie apocalypse.

Some gift ideas for the geek in your life (you?)

Is it too early to mention the C word? If you're struggling what to get someone with nerdy tendencies (a personality description which we suspect includes the majority of the readers of this newsletter, and all of the authors) here are 5 gift ideas to inspire you.

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 61 - October 2022

We've published our course schedule up to the end of June (and some other course summary pages too)

Leveraging hidden legacy Excel 4 functions to list out worksheets, range names and much more!

A taste of Power Automate: a flow to send you an email notification whenever someone updates a file

It's another small update to Power BI this month, contrary to Microsoft's published release plan

The answer and winner for last month's word search, and some zombie advice

Some gift ideas for the geek in your life (you?)

Head office

London

Manchester