Forum

Hi Bree, Thanks for your kind words! It's great to know you're enjoying the course and even better that you're putting the techniques to work. I...

Hi James, If you use the Power Pivot option then the other users also need a version of Excel that supports Power Pivot, and preferably the same ve...

Hi James, You have a few options. 1. Use Power Pivot to store the data. In fact, put the source data in a separate file and get it with Power Pi...

Hi Mai, The good news is you don't need VBA. The bad news is you shouldn't really use this type of chart. Data visualisation expert, Stephen Few, d...

Hi Kelly, In session 1.03 I cover the differences between the different Excel versions and there is an image below the video that maps the differen...

Hi Ahemed, Try this tutorial: The Power Pivot solution requires much more explanation and with no sample file we don't really know what you're wo...

Hi Arun, Add an index column to your data. Then Pivot the Part no. column and choose the Description column as the 'Values' and in 'Advanced Option...

Hi Carolyn, Thanks for the update. It is very odd. I'd have to see some sample data so I can try to replicate it myself. At least you have a workar...

Hi Ahemed, In the attached file all of your dates were in the last 12 weeks so I changed the date in row 2 to show the formula works. Mynda

Hi John, The problem is caused by the incorrect data layout for a PivotTable. PivotTables require tabular data, and that means, among other things,...

Hi Ahemed, In the attached file your formula references cell S2, but this cell is empty so it's interpreted as 0 by the formula. Cell S2 should con...

Hi Ahemed, No file attached, but you just need to change the value 365 in the formula to 84, representing the number of days in 12 weeks, and modif...

Hi Anne, Got me stumped! There is no pattern that I can see that you can exploit. I think you need a lookup table that maps the departments to the ...

Hi Arun, You can create another query that contains just the disposal dates. Then merge this query with your original data to bring in the disposal...

Hi Ahemed, Welcome to the forum and thanks for sharing an example file. You can use an INDEX formula to find a partial match to the values in co...