Forum

Hi David, You should be able to upgrade your Office 365 account to ProPlus so you have Power Pivot. I suspect they either didn't understand the que...

Great question, Paul. In the case of negative values you can't use the log scale or indexed results charts. The options are to use the secondary ax...

Hi Cele, In my Power Query course, for which you are a member, session 6.11 I cover Error Trapping in formulas, and session 4.08 covers removing er...

Well done, Sunny. I tried a few cells to copy, cut and paste but didn't get the error. Mynda

Hi Chris, I wasn't able to recreate the issue you describe in the file you shared. Are you able to tell me the steps you're taking in this file so ...

Hi Celeste, Like Catalin said, we can't see the image, however I suspect what you mean is to have folders in the Queries pane so you can group and ...

Hi Mey, Appears ok to me. Interesting approach. I've not seen it done like that before. Perhaps you can ask your colleague for an example of ...

Ok, can you please email the session 23 file to me so I can see what you're referring to. [email protected] Thanks, Mynda

Hi Chris, I've never had that happen. Next time it does, can you see if you can reproduce the problem in a table you can share so we can test it? ...

Hi Goutham, We must be looking at different files. Supporting file (named: excel_2013_23.xlsm) has a Menu page at the very front with links to all ...

Sure, but unless you already know how to use Power Query I think you're going to need to learn how to use it first. Mynda

Hi Gary, Power Query can eat that job for breakfast. This link talks about how to get your data from SharePoint: You can then perform the necessa...

Hi Goutham, The syllabus for the Excel 2013 version of the course has different numbering. For Excel 2013 the PivotTable lessons are in session 23 ...

Hi Dritan, I've uploaded it again here. Hopefully that one works. Also, in future please don't insert the prior posts as quotes. Just reference ...

You're welcome, Budu. You're absolutely right about 1 and 2 🙂 Just note for future, if you post your question on multiple forums then it is forum...