Forum

Hi Chris, Please see attached. Mynda

Hi Howard, Great question! I'm not aware of any course specifically on budgeting and forecasting using Excel. We have a Financial Modelling course,...

Hi Eithan, Welcome to our forum! I'm not quite clear what you're asking, but I suspect you want to use SUMPROUDUCT: =SUMPRODUCT(H3:H47,E3:E47...

Hi Mike, Sorry for the slow reply. We had a power cut due to a severe storm! It's not clear if your original dashboard source data was the resul...

Hi Mike, No, this is a "feature" of the Pivot Charts. Mynda

Hi Allwyn, Welcome to our forum! I answered your question in the comments. Here it is again: Label position can be a problem in cases like yo...

Hi Blanka, I don't see why you can't use the Claim Type field from the Claims table. Please provide an example of the error and what the correct re...

Hi Cheryl, Thanks for taking the time to create a mock-up file. There is no way I would have understood the issues without it, so it has been worth...

Hi Gary, If the column is in the raw data then I'm assuming you've deleted it along the way after import, or you didn't expand that particular colu...

Hi Cheryl, It's very difficult to understand and help without seeing the data structure, even screenshots would help, but a mockup of the data in a...

Not sure, Lee. Can you share a sample file that contains your query and a mock up of the desired result?

Hi Mike, I would add columns for the country and state information you also need to capture. You could hide the columns and use formulas to link th...

Hi Cheryl, You can do this in the GUI instead of the advanced editor, just select the 'Promoted Headers' step > click in the formula bar and typ...

You're welcome! I just typed the values in, but you could use a lookup table that lists the status and the value in a corresponding column. Or you ...

Hi Mike, You can use Conditional Formatting to create the data bars (microchart) effect. You might also consider adding a numeric scale to some of ...