Forum

Hi Rob, Thanks for sharing the file. There is an easier way that will be more efficient for Excel to calculate: 1. Add the Value field to the Pi...

Hi Fred, No file attached. That said, you should use the Excel.Workbook function to get all sheets in the file excluding the sheet containing the q...

Hi Fred, Power Query gets all of the data in a table. If you want to only get some of that data then you would use filters to exclude the old data/...

Hi Rob, You lost me at "So my pivot table has 1st column Sale Item description - sub-divided into 3 cost/sale centres - each group is subdivided ...

Hi Lalu, Welcome to our forum! You can group the dates in the PivotTable by week i.e. right-click the date in the PivotTable > group by > day...

Hi Tina, You could use a logarithmic scale. Let's say it's a line chart, select the vertical axis > format axis > logarithmic scale. That sai...

Hi Faryal, It looks like it's working fine to me so you'll have to be explicit about why this is wrong and what you're expecting to see instead. Al...

Hi Farooq, Welcome to our forum! That error means you have a version of Excel that doesn't have the SEQUENCE function. In the YouTube video descrip...

The data for the pie chart must be in rows (as I laid out above). Right-click the chart > Select Data > Switch row/column. If you want the on...

So pleased to hear that, Rosa 🙂

Hi Faryal, Remove the data validation from column D in the 'To be used for data entry' sheet, then enter this formula (exactly): =INDEX(Table2[P...

Hi Scotty, Thanks for sharing the revised file. I can tell you that the 'one big table' isn't big at all, even if it has 100000's more rows than th...

Hi Fred, Welcome to the forum! It's great to see you're working through the course. The module name is missing from the Data sheet code in the s...

Hi Charlie, There's no single function. The calculation of accruals will depend on how your data is structured and how you accrue annual leave. If ...

You need to total the online sales and store sales so there are just two values and two labels e.g.: Total Online Sales 13,865.40 Total Store Sa...