Forum

Hi Peter, I agree, this is very inefficient, and a lot of INDIRECT functions used like this can slow Excel down. I would use Power Query to gather ...

Hi Peter, This functionality is only available in Excel 365 or in Excel Online. You would need to save the file on OneDrive to enable sharing of th...

Hi and welcome to our forum! It sounds like your data is in the wrong layout. You shouldn't have separate sheets/tables for each month's actuals. I...

Hi Peter, Thanks for sharing your file. I'm not sure I follow what you want. I can see the formulas you've tried, but these don't show me what answ...

Hi Sarfraz, Yes, you can create a to-do list with Excel. You could use conditional formatting (lesson 5.13) to highlight due dates that are approac...

Hi Mesa, Welcome to our forum! Your file did not upload. After selecting the file, you need to click the 'Upload' button and then wait for the g...

Thanks for the file, but it's not clear what you want. Also, the data in the file is not in the correct layout for a PivotTable, which might be why yo...

Hi Tan, Your data is in the wrong layout which is resulting in the wrong approach. You should use Power Query to unpivot the month columns, then yo...

No, the link is explaining what a Pivot Cache is so that you have a better understanding of how PivotTables work in the background. There's no solu...

Great to hear you've found my videos helpful! You can add a calculated field and only use it in one PivotTable. However, calculated items will be a...

Hi Saliha, In Excel dates are numbers too. They're stored as date serial numbers, so it's not as simple as identifying which values are dates vs nu...

Great to hear, Alan!

Hi, Thanks for sharing your file and video explanation. Each row label in the PivotTable acts as a filter. When you have the main category field...

Hi Kent, I don't have any tutorials on that specifically, but I found this tutorial that might help. Mynda

Hi Dieneba, Thanks for sharing your file. The good news is your PivotTables share the same dataset. The issue is that you haven't connected the Sli...