Last seen: Jul 23, 2026
Hi Sarfraz, Please see this tutorial on converting numbers to words with VBA in Excel: Note: this is outside the scope of the Excel Expert course...
Hi Mat, I wasn't able to replicate this issue testing with Power Query getting data from inside the workbook and loading it to the data model. i.e....
Oh, by the time we got the question and example clear I'd forgotten you didn't want to use a PivotTable, sorry. You need Microsoft 365 or Excel 202...
Hi Priscilla, The formula you're using the generate the title must be affected by the filter on the State slicer. It's hard to say without seeing a...
Hi Stephanie, Thanks for clarifying. You can use a PivotTable (with data added to the data model) to do this. You need to include the 'Items' field...
Great to hear! The files didn't get attached. After selecting the file you need to press 'Start upload' and then wait for the grey check mark before s...
Hi Valerie, It's very difficult to follow without a sample file. The KPI visuals require a date dimension, so maybe you haven't given it enough inf...
Hi Stepahnie, Thanks for sharing the file. I'm a bit confused as you say you want the value for those with an amount of zero. How would I be calcul...
Hi Sebahattin, Yes, you can add more conditional formats (one for each project) that colours the cells, but if you have a lot of projects, then it'...
Hi Adam, Glad you've found our site helpful! Unfortunately, you can't add conditional formatting arrows to a Pivot Chart. Here's an example of a...
Hi Bouskila, Please provide a sample Excel file of your data and desired result so I can understand what you're working with. Mynda
Hi Max, It sounds like you're not using a tabular layout for your source data. If you were, then you could create a PivotTable report from the data...
Hi Laura, I can't see the very bottom of your screen. There should be an arrow there which is 'get data'. Mynda
Hi Ayal, To find the address of a cell, you can use the CELL function like so: =CELL("address",B2) Alternatively, the current cell address is...
Hi Chris, I think what Velouria is alluding to is to clear all filters, then set the formatting, then reapply the filters as required. This will ap...