Ok Excel heads… I’m trying to add up columns F and H into column I. I used a sum formula and it’s not working. What am I doing wrong? Is it not working cause it’s a time and not a whole number?

Network design exit opps? I love working on network design and optimisation project but I am a bit reluctant to specialise there because I am not sure what kind of exit opps exist.

Any Publicis PMs go to TBWA\Chiat\Day LA? How was your experience with that transition?

Looking to invest money with a Schwab brokerage to save for a down payment on a home. What ETFs should I invest in?

Anybody knows how much earns an average line cook in Orlando, Florida? And how many hours have to work to get a decent wage

Hi fishes,
I have been working as a business analyst for last 3 years and some how feel like saturated with mundane sql and reporting can some one please suggest me a fast track prep plan for Data Scientist transition. Good with sql and functional programming and basics of Machine learning.

Do you think $150K is less than average for software test lead in the USA? What do you recommend I should ask for?

Hi everyone

My current CTC is 4.1L

My skills: Manual, API, Performance testing

Yoe: 3

Thinking of joining another company, How much should I expect in my next package jump?

Kindly help me with your suggestions!

Can anyone explain why the Aston southend is so expensive ? 2.9k for a 1 bedroom?

What's a good base salary to live comfortably in the San Jose area for a single person? Thinking about interviewing/moving out there from East coast but seeing the rents is giving me sticker shock.

I’m currently doing IR work but would like to do something more on the technical side (ie: more forensics or technical). Does anyone know if forensics firms or any firm that offers a mix ? I have both a Cipp-Us and cyber/ Sec+ certs.

I get so frustrated and annoyed when people make stupid common sense mistakes and I think it’s starting to affect my relationships. Don’t really know what to do.

What are some of the things to keep in mind when leasing a new car? What are some add-on that can be negotiated on?

Recs on good rental insurance? 3 apts in my neighborhood were broken into and I’m looking for a good but not pricey option

Does anyone have experience managing an out of state property yourself? Are there any tips/services you use?

I am trying to justify house buying in HCOL city. The house cost is minimum 1.4m .monthly mortgage would be at least 7k(with just around 2k principal) rest goes to either int,tax. Not to mention regular house maintenance. How is it better than 3.5k rental. I understand appreciation and own house independence. But I am just trying to make numbers work.

Hi Fishes,

I want to set up a small business in Rajasthan (remote area) for my father, I don’t want him to leave home and stay with family.

Can you please give some ideas on what can be setup for consistent long term profit and also setup cost is not that high.
Thanks in advance.

I'll switch to a startup as the only data engineer and will closely work with all the Head ofs + the CTO.

Any advice/books/... on stakeholder management at that level? Especially when things fail/discussing budgets/new hires etc.

Working for a senior who is beyond horrible. She talks to you like you’re stupid and makes it sound like you’re absolutely terrible at what you’re doing. She’s made 5 other associates cry during her 5 year career. Got someone fired and made another person quit. It’s known around the office that she can no longer have a female associate, because she talks down to females more than she does males. I came along and thought I could deal with it but she literally makes me want to not log on tomorrow.

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)

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

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.

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

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

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

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

How long did it take you to become good at excel? Like fast?

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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!

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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