Search

Home > Power Query Magic > The One with Celia Alves
Podcast: Power Query Magic
Episode:

The One with Celia Alves

Category: Technology
Duration: 01:10:01
Publish Date: 2022-06-12 05:14:48
Description:

As always I thoroughly enjoyed chatting with my guest.  Thank you Celia.

Celia has a very different backstory to many guests, such a twisting tale of chance and hard work coupled with a dedication to automate everything and find a better way.

Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot tables 

https://youtu.be/JCNSVWY2NYw

https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/

 

And her most popular here

https://youtu.be/OQE9qMbofCw

https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/

 

You can also find Celia here:

https://www.linkedin.com/in/celiajordaoalves/
https://twitter.com/celia_excel


The Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)



 

Total Play: 0