Forum

You're welcome 🙂 You shouldn't need to clean the table before loading it to Power Query. That's Power Query's raison d'etre! P.S. thanks for y...

Hi Dieneba, Please see the file attached. Note: you will have to edit the file path to reference the budget file on your own PC as it's currently r...

Hi Dieneba, Looks like the menus have changed in the last week or two. I’ll have to update the video, but in the meantime, you can ‘get data’ us...

Thanks so much, Hans!

I don't have a video demo for this, but I am considering doing one, but it won't be for a while.

Hi Dieneba, The attachment is an Excel file, not a PDF. Please upload the pdf again and let me know if you want me to remove the spreadsheet attach...

Hi Dieneba, The Change Type step doesn't convert currency, it simply converts the data type, so you should be choosing the locale that the file/sou...

Hi Victoria, You can either manually drag them away from one another so they have more space, or you can use this technique to give the labels more...

Hi Dieneba, Comments or Threaded Comments is their official name are the new improved notes. They kept notes in Excel for backwards compatibility, ...

Hi Bayar, If it's my Excel Project Management Dashboard, then there isn't any password protection on it. Mynda

Hi Dieneba, You can try loading the 'Document' that comes up when you connect to a web page. This is the HTML code for the page and from there you ...

Hi Dieneba, What if scenarios are covered in our Excel Analysis Toolpak course, but there is a written tutorial here on our blog: What If Analysis ...

That's the correct way to learn, but sometimes due to regional settings we need to use other techniques, so don't be afraid to reach out if you get st...

Hi Dieneba, Thanks for sharing your file. Riny is correct, this is most likely a locale issue. You need to use Change Type Using Locale as explaine...

Hi Dieneba, Can you please share your Excel file that has the error? Mynda