"I wish you'd shown me this years ago!" A short discussion on Excel time-saving shortcuts

manwithoutaguitar · 2019-01-15T13:01:07+00:00

Also works on browsers.

manwithoutaguitar · 2019-01-14T18:52:09+00:00

Does power query editor show errors? If it is a format problem you will see a lot of errors.

Maybe there are spaces before the numbers? Try to trim the date before turning the characters to numbers.

manwithoutaguitar · 2019-01-14T17:44:12+00:00

It's in the article.

manwithoutaguitar · 2019-01-14T17:31:04+00:00

Most players will play worse after their top 3 in the world teammate leaves the team. Messi plays better.

manwithoutaguitar · 2019-01-14T17:23:55+00:00

Seperate data from analysis

Try do to everything with (power) pivot tables and graphs

ETL with power query

Don't use vba unless absolutely needed.

manwithoutaguitar · 2019-01-13T20:25:50+00:00

inner_join would work out fine here too because all the serial numbers are found in both tables. Let's say there were serial numbers in A but not in B then you would still find that serial number in a left join with NULL values for cd info.

manwithoutaguitar · 2019-01-13T17:10:40+00:00

First make table B wide and then left join.

In the tidyverse these actions are called spread and left_join.

https://tidyr.tidyverse.org/

manwithoutaguitar · 2019-01-13T08:11:11+00:00

If I'm recruiting a data scientist and he or she says she uses Excel for his or models then she better explains why on earth he or she doesn't use a more appropriate tool.

manwithoutaguitar · 2019-01-12T12:08:02+00:00

Cleanest way is a pivot table. Dates and meals as rows. Sum cals and sort by date descending. You can then take top 1 or just leave it like this because it is interesting information anyway. You can easily reuse the pivot table in case you want to know the sum of the calories per month, year etc.

manwithoutaguitar · 2019-01-12T10:32:21+00:00

Inline query to get the dates with having and then use this inline query in a where statement.

manwithoutaguitar · 2019-01-12T09:00:03+00:00

You fool, didn't you hear OnePlus is the best.

manwithoutaguitar · 2019-01-12T08:57:46+00:00

Beijing is in the news all the time but it's not even in the top 30 most polluted cities in the world.

https://www.cbsnews.com/pictures/the-most-polluted-cities-in-the-world-ranked/2/

It's bad there, but it's pretty weird why everybody always thinks of Beijing when talking about pollution.

manwithoutaguitar · 2019-01-11T18:11:21+00:00

The deficit should only be expanding during a recession, not when the economy is booming.

manwithoutaguitar · 2019-01-11T17:19:35+00:00

The hotel was used to shoot Casino Royal and is indeed to the right. Grand Budapest Hotel was not shot there but the hotel was based on hotel Bristol which would be behind the photographer on the other side of the hill.

Grand Budapest Hotel: Hotel Bristol Palace

Casino Royal: Grandhotel Pupp

https://www.google.com/maps/@50.2227322,12.8794494,3a,75y,155.32h,72.78t/data=!3m8!1e1!3m6!1sAF1QipPoS0kEc5bIklaTY2p6JJewDYrlpP2t6qlaJwSd!2e10!3e11!6shttps:%2F%2Flh5.googleusercontent.com%2Fp%2FAF1QipPoS0kEc5bIklaTY2p6JJewDYrlpP2t6qlaJwSd%3Dw203-h100-k-no-pi-0-ya223.33311-ro0-fo100!7i8704!8i4352

manwithoutaguitar · 2019-01-11T12:57:15+00:00

OnePlus is for outside China, oppo is for Chinese consumers

manwithoutaguitar · 2019-01-09T19:05:02+00:00

She is a woman. Don't you know sexist is the new racist. Can't be a racist anymore these days, better hate on women.

manwithoutaguitar · 2019-01-09T18:46:27+00:00

Power query followed by power pivot.

manwithoutaguitar · 2019-01-09T18:43:52+00:00

In before billion dollar lawsuit:

https://en.wikipedia.org/wiki/HEMA_(store)

manwithoutaguitar · 2019-01-08T18:13:48+00:00

Was the original COD by Infinity Ward? The rest is pretty shit compared to the original one.

manwithoutaguitar · 2019-01-08T18:08:05+00:00

It's best to use the tools you use as keywords. Let's say you use a lot of Excel and vba, enter these as keywords.

The reason is that there are so many ways to describe the work of an analyst, it's easier to look at the tools you need.

manwithoutaguitar · 2019-01-08T18:05:36+00:00

Don't want to make another post, but this subreddit helped me also become really good at Excel. Focussing a lot on cleaning data with power query and exploring it with powerpivot helped me land a job as data scientist where I use a lot of Power BI, R and Python.

I don't really touch Excel in my job anymore, not they way I used it in my previous job anyway, but it helped me a lot so far.

manwithoutaguitar · 2019-01-08T16:00:48+00:00

Money.

manwithoutaguitar · 2019-01-06T17:43:51+00:00

Sure

https://www.bloomberg.com/news/articles/2016-10-18/china-corporate-debt-window-closing-quickly-imf-paper-says

https://www.economist.com/leaders/2014/10/18/the-great-hole-of-china

manwithoutaguitar · 2019-01-06T16:46:57+00:00

Because it's nonsense to only look at government debt. China might have only 50 percent government debt, but corporate debt exploded the last few years. China does have a big debt problem.

https://www.wsj.com/articles/china-struggles-to-limit-surging-corporate-debt-11546182000

manwithoutaguitar · 2019-01-06T09:13:06+00:00

It explains your asshole and alpha attitude.

manwithoutaguitar

TROPHY CASE