Forum

Hi Sheralee, Welcome to our forum. I can't tell much from the screenshot, but it looks like the PivotTable may be already returning the results ...

Hi Michael, Welcome to our forum! Power BI is the tool designed for sharing specific data with different users as you describe above. The only a...

Hi Anita, Answers to your bullet points below: There are 6 channels (column B). 3 for AC load net and 3 for PV site net. The data needs to b...

Hi Alicia, From what you describe above, you're on the right track. However, you shouldn't be splitting the transaction data up into separate queri...

My bad, Mohamad. I misread your question...it was early! You can copy cells in Excel and then go to Word and right-click > paste as link. By def...

Hi James, Glad we could help. Yes, please start a new post with this question. I will be away for the rest of the week, so don't address it to me s...

Hi Mohamed, If you insert these descriptions in the Excel cell Comments/Notes, you can print them (to PDF) by selecting the setting in the Page Set...

Hi Jennifer, I think you need to add another column to your Youth Age table that converts their age based on the first incident of the month. You c...

Hi Kevin, You can use this formula: =INDEX(T,COLUMNS($A:A),COLUMNS($A:A)) Mynda

Hi Robert, Welcome to our forum! It's tricky without an example file. If you have a Microsoft 365 license, you can use this formula: =FILTER(...

Hi Valerie, Great to hear you're making progress. Well done! It's very difficult to visualise all this information and help without seeing your ...

Hi Mattias, You can get import the climate zones using the csv, Excel, JSON or PDF file types on the ggis.un site. As for the issues you're expe...

Hi Anita, I've moved this question to the Excel Expert course members forum so that it gets answered promptly. Can you please upload a sample of yo...

Hi David, You're on the right track. If you prefer to have actuals, you'll need to remove the duplicate data on 23rd August at 6:23PM, 8:30PM, 9...

Hi David, Welcome to our forum! Yes, you can structure your data into a 3 column table. Use a PivotTable to summarise the data by date and time ...