Unpivot

What features would you add to Excel or Power BI & Starting your own business

• Mark lays down a challenge to who has the easiest dependent drop down list technique
• Giles is glad not to be in charge and has become a Lambda Lover
• Sue has run ANOTHER marathon!
• Wyn has an embarrassing rant online.
  
  

QotW: What Features would you add to Excel? 

Main Topic:  Motivations and Challenges of starting your own business

 

Mark’s video on Easiest Dependent Drop Downs

Wyn's video on Easiest Dependent Drop Downs

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

 

Watch
https://www.youtube.com/@Unpivot

#Excel #PowerBI

When are you an expert and are technical books still relevant?

🙏🏻 Special Guest: Rick De Groot ( Gorilla.Bi )  (  Power Query How - Home of the M Language )

QotW: When are you an expert? 

Main Topic:  Are technical books still relevant in the world of AI?

 

Join the conversation on LinkedIn
https://www.linkedin.com/company/the-unpivot-show


Hosts  Giles Male, Mark Proctor, Sue Bayes, and Rick de Groot

Late to the Party and Presentation Tips

QotW:  What features were you late to discover but now love

Main Topic:  Presentation Tips and tricks 

 

Join the conversation on LinkedIn
https://www.linkedin.com/company/the-unpivot-show


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

 

Watch
https://youtu.be/LNgzqrepyic

#Excel #PowerBI

Giles MVP Award and advice to your 20-year-old self

We also discuss Best Practice 

Links mentioned:

1️⃣ Giles MVP award video

2️⃣ Spreadsheet Best Practice Rules

3️⃣ Question Of the Week on LinkedIn

Hosts Wyn Hopkins, Giles Male, Mark Proctor and Deb Ashby

 

YouTube

Essential Functions and when formulas go wrong

Links mentioned:

Data Scotland: https://datascotland.org/

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

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

 

YouTube

Excel and Power BI Dangerous Features and what to learn?

Welcome back Mark!

Training Resources:
https://pbi.guide/resources/
https://learn.microsoft.com/en-us/?WT.mc_id=M365-MVP-5002589  https://exceloffthegrid.com/ 
https://www.fullstackmodeller.com/ 
https://skillwave.training/ 
https://www.w3schools.com/python/default.asp 

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

 

YouTube

 

Excel v Power BI and what would you change about them

🙏🏻Thanks to special guest Cristian Angyal
https://www.linkedin.com/in/cristian-angyal
Romania Power BI and Modern Excel User Group | Meetup

🔗Links mentioned in show

Ideas: Power BI https://ideas.fabric.microsoft.com/ideas/

Ideas: Excel  https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472

 

 

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

 

YouTube

 

TikTok, Training, and Top Voice

🙏🏻Thanks to special guest Deb Ashby
https://www.tiktok.com/@cellmates_

https://www.linkedin.com/in/deborahashby/

 

🔗Links mentioned in show

PowerToys: https://learn.microsoft.com/en-us/windows/powertoys/install

Forums:

Mr Excel: https://www.mrexcel.com/board/

Power BI Community: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi

Excel Tech Community: https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral

Reddit Excel: https://www.reddit.com/r/excel/

Reddit Power BI: https://www.reddit.com/r/PowerBI/

Stack Overflow: https://stackoverflow.com/questions/tagged/excel

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

 

YouTube