Forum

Workspaces in a Premium capacity can be shared with other users without a license. Workspaces created in a Pro capacity can only be shared with other ...

Hi Abid, I'm curious as to why you would upgrade to Excel 2016 when Excel 2021 is about to drop. In fact, the best license to upgrade to is 365 as ...

Hi Derek, Welcome to our forum! Please upload your sample Excel file shown in the screenshots so we don't have to recreate your data to help you. ...

Hi Jim, Thanks, but that file only contained one data set because you saved it as a CSV file and they can only contain one sheet. It needed to be s...

Hi Simon, What do you mean by "and then linking to that sheet through File/ Info/ Copy path"? Are you linking to the data using formulas? Mynda

Hi Jim, Welcome to our forum! Would you kindly put the data from the 4 CSV files into one Excel spreadsheet (on separate sheets is fine) and then u...

Great to hear, Vinh!

Hi Ying, You can't conditionally format chart data labels, sorry. The best you could do is create separate labels for each colour set. If you're us...

Hi Vinh, Welcome to our forum! Your data must be in a tabular format to work in Power BI. You can use Power Query to unpivot it when you import ...

Hi Tim, Start with an IF(ISBLANK([Previous period transactions]), Blank()... Mynda

Hi Tina, Thanks for sharing your file. It's not clear, but I presume you want to group the receipt amounts. If so, please see attached. To create t...

Hi Robb, Please see this tutorial on getting started with APIs. Mynda

Hi Sakshi, Welcome to our forum. Some of your question isn't clear e.g. see section underlined "I should be able to keep track of each day performa...

Hi Marc, Later versions of Excel open in separate but related windows by default. I'd say the issue you're experiencing is due to the heaviness of ...

Hi Doug, The way to do this is to add an index column to your final merged query called South_Southeast. Then in a separate table create a list of...