Forum

Hi Brenda, Can you please share the file, or if it's confidential, please create a mock-up that illustrates the issue. Mynda

Hi Mohamed, It will depend on the type of database. If it's SQL, then you can connect to it using the From Database connector for SQL databases. ...

Hi Sham, Great to hear you're progressing through the course. The best/most efficient way to do this is with a lookup formula. You can use VLOOKUP ...

Hi Bax, I guess there are a few ways you can approach this depending on the information you have in the reports, but the simplest might be to separ...

Hold CTRL and left click on the outer edge of the text box, then press DELETE.

Hi Tracy, Make sure you clear all the filters in the Slicers for the Chart before formatting. The formats should then stick. However, if the slicer...

I would use Power Query to do this. Split by delimited and then in the Advanced settings choose 'by rows'.

Hi Bax, I used to do this exact task in my previous life as a management accountant. I'm pretty sure I demo a technique you can use to do this in l...

Hi Jim, Not using the new picture in cell feature. With this you can store a picture in a cell, but not also store text over the top. The only o...

Hi Hans, In column H add a heading for 'Category' in cell H15. In cell H16 enter this formula: =XLOOKUP([@[Sub-category]],TblCategories[Sub-cate...

Yes, you can just change the number format to whatever you prefer.

Hi Sam, You should use Power Query to import the data and then you can use the 'Change Type > Using Locale' menu to correct the date format. ...

Hi Dennis, The reason you're getting that error is because your formula is incorrect. Please see this tutorial on how to write an IF formula. If...

Hi Sheela, It doesn't appear so. This page uses JavaScript to serve up dynamic results. Power Query can't see this. You can tell it's serving up re...

Hi Sean, Cell formats are not the same as the data type being a date. You can format a cell containing text as a currency, but it will still displa...