This list of shortcuts is a good one to bookmark if you want them all in one place for quick reference. What's everyone's favorite Excel shortcuts?

I recently bought my 1st home in TX. I want to get into real estate and eventually own/rent out multiple homes. Are there any good recommendations/tips on books/articles/websites that others have used to get started?

I've read about HELOC and cash out refinance to get a 2nd home but articles are so scattered that it gets confusing which is better in terms of tax benefits and immediate costs, etc. Anything others have found helpful that summarized how to get started would be great!

Do you feel like you can be your whole self at work? If not, what parts of yourself do you leave at home?

Quarantine has really made me think about life. If I can’t scuba, then what’s this all been about? What have I been working toward?

What value do TPMs provide? In my company all they seem to do is tell other people to work on things they’re already working on, and incessantly nag people on slack for status updates and timelines which you’ve already provided.

Record breaking heat waves, half the world seems to be burning from forest fires. Why does no one seem to be concerned about this??

Any advice to find a job in Vancouver Area? I've been working in IT recruitment for over 2 years and I enjoy doing creative sourcing.

Anyone in philly?

What are some red flags you've noticed in the hiring process? I've finally landed an interview after weeks of applying. I think it went well on my end, but something about the managers I spoke with just feels...off.

Anyone work in NY state most specifically Jefferson County? I have a Q re: divorce case, but not sure if I can even private message on this thing.

What stocks are you adding in this dip.

I think there are a few folks interested in learning or practicing use of Sanskrit. Here is a publication if interested.
Samskrita daily newspaper - Sudharma - the only Samskrita daily in publication all across the world. They are running in a bit of loss right now and might have to shut down their work if people don't join hands to help them. Cont’d

Do you ever regret leaving agency life?

Google users! What are some of your favorite apps/extensions and add-ons for G Suite for Education products?
I LOVE -Draftback, -Screencastify, -Form Publisher, -Share to Classroom

Hi All,
Need your help for 11 Likes to unlock 🔓.

Hi Fishes, How is the WLB in FMR, Getting mixed reactions for this question and also bonus to too much in CTC, is it the same case with everybody. HM said that there is lot of work in AWS cloud , is it correct ?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Any book recommendations on excel modeling for real world business applications?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Hi there,
Which Excel courses you recommend for a beginner?

What are your top Excel ninja tricks? Ones that few people know...

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?