Essential Functions and when formulas go wrong

A light-hearted discussion about Excel, Power BI and some other occasional tech.

Links mentioned:

Data Scotland: https://datascotland.org/

Chris Barber: https://www.starschema.co.uk/ 

Hosts Wyn Hopkins, Mark Proctor, Sue Bayes, and Giles Male.

🎧Podcast Episode: https://unpivot.podbean.com
Podcast also available on Spotify and Apple Podcasts. Just search for Unpivot

💓Like, Subscribe and leave some comments and questions.

Wyn: https://wyn.bio.link/
Mark: https://exceloffthegrid.com
Sue:   / suebayes  
Giles:   / giles-male-30643b15  


00:00 Introduction & Music
00:35 Hosts Introductions
01:00 Sue's Upcoming Conference and Discussion About Rankings
03:40 Giles on Financial Modeler's Podcast and Simplicity in Data
06:05 Excel Features and Trim Ranges Use Case
07:30 Discussion on GroupBy and PivotBy in Excel
07:54 Giles and Deb's Oasis Ticket Story
09:10 Wyn Discusses IntelliSense Issues in Power Query
10:35 Data Scotland Conference Mention
12:49 Jingle and Question of the Week
35:45 Discussion When Functions Don't Work