How to unlock VBA macros from files received from the internet
The video below demonstrates the user experience to unlock macros from a file when security policies allow it: [...]
How to share workbooks with data resulting from Power Query without allowing other users to refresh the queries
Power Query is all about creating a refreshable connection to a data source and making it easy for us [...]
Women in Tech: Taking part of Office Insider Celebration of Women’s History Month
I was honored to be part of the group of women featured by Microsoft in this blog post, and [...]
Tips & Tricks of POWER QUERY in Microsoft Excel
On Feb 17, 2022, I presented Tips & Tricks of POWER QUERY in Microsoft for the meetup group organized by [...]
Parameters and Custom Functions in Power Query in Excel
On Jan 27, 2022, I presented to the Baku Meetup group organized by Ilgar Zarbaliyev. I looked at scenarios [...]
M Code Tips to achieve more with Power Query
On Nov 8, 2021, I had the pleasure to present to Shlomi Postelnik 's YouTube channel The Excel Studio. We went [...]