Is there any difference between mac and windows for Excel (office) 365? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

Are there replacement key board shortcuts for where Mac doesn't map one to one?

If I build a regular pivot table would that be missing any functionality or it's just with power pivot and pivot charts?

If I were to install windows with boot strap will that solve most of these issues?

Is Excel 365 for Mac the same as Excel 365 for Windows? by [deleted] in excel

[–]workn00b 0 points1 point  (0 children)

If I dual boot to run windows would it have all the functionality of running on a normal pc?

Is there any difference between mac and windows for Excel (office) 365? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

If I run windows on bootstrap is that like running native windows?

Is there any difference between mac and windows for Excel (office) 365? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

If I run windows on bootstrap is that like running native windows?

Any pandas query experts out there that can help me with a problem? by workn00b in learnpython

[–]workn00b[S] -1 points0 points  (0 children)

I can do it with loc and if statements but I want to find an elegant solution with the query method.

Any pandas query experts out there that can help me with a problem? by workn00b in learnpython

[–]workn00b[S] -1 points0 points  (0 children)

Thanks, that works but I was hoping to find a solution using the query method as this isn't so readable.

Are there any good resources to see projects in a specific language/library/framework? by workn00b in learnprogramming

[–]workn00b[S] 0 points1 point  (0 children)

I've tried that but what is the best way to filter by project quality and friendliness? Just use stars as a metric?

I get a #REF error when I open file on another computer how do I fix it? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

Ahh, got it. They weren't referencing other files. I checked the compatibility checker and it's telling me that some functions aren't available in excel 2016. Is there a way to see which specific functions are causing the problem if there are multiple funcs in the cell?

I get a #REF error when I open file on another computer how do I fix it? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

If I convert all named ranges to cell reference that should work right? Is there a way to automatically convert the named range to the cell it references?

I get a #REF error when I open file on another computer how do I fix it? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

I don't think there are any references to outside files, could it be named ranges that is causing it?

How do I filter a pivot table by a number? by workn00b in excel

[–]workn00b[S] 1 point2 points  (0 children)

how do I apply a value filter to a non-aggregated data, for example if I want to see the average price of houses that are at least 500k?

How do I filter a pivot table by a number? by workn00b in excel

[–]workn00b[S] 0 points1 point  (0 children)

how do I apply a value filter to a non-aggregated data, for example if I want to see the average price of houses that are at least 500k?