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. 😂🤯

11 likes please

Thank you!

What does the salary for a home health visiting nurse in the south look like?

Is a cover letter necessary?

Can anyone tell me about the ACN marketing operations business unit? I’ve been reached out for a role there and would like some intel about the organization. Thanks in advance!

Can we extend the joining date in sap labs because relieving date and joining date is overlapping on 22nd August 2022

Anyone from Amazon's finance division. Require an employee referral for a role.

Best books on entrepreneurship? Trying to find a good birthday gift for a friend thinking of starting his own company and exploring business ideas

Hey y'all, kind of a two part question:
1. I enjoy the people management more than individual contributor stuff. What career paths do you see in our industry for people who are managing support engineering teams?
2. What certifications are valued today? Seems like being a AWS Cloud Practitioner is a good general one, but are there others that stand out?

Question! I just moved(transferred) to another team of my company and received new title, graphic & creative services. I was a senior graphic designer at the previous team. What do you think about my new title? I know that title is not a big thing but why I feel like my title is downgraded here… Good thing is my jobs here at my current team are what I really wanted to do. This is amazing. I love my new team and people here! Super healthy working environment! But just curious about the title.

No new posts on this board for 5 weeks. Does this mean everything is great and we ended mansplaining for good? 🙌🏼🙌🏼🙌🏼

Career Sabbatical?

Can anyone who has taken a career sabbatical to travel/explore other interests share their experience with both leaving their jobs and returning to the legal field?
I really want to live in Asia for a year at least before I have to settle down and start a family. I’m not getting younger but don’t want to be reckless with my career.

Maybe a dumb question but if someone vests in a pension are they still able to rollover a lump sum into an IRA? Or is it too late? Have a client who keeps blowing me off to get documentation...CONT

How much are ESE paras paid in your district?

Fishes, Basically, I’m a front-end developer. I have work with most of the front-end technologies and frameworks. I want to learn back-end to get rid of the dependency from the other person who work with the the back-end for the common tasks.

It would be highly appreciated if you could give me some advice/resources/roadmap on the same.

Hi all,
Does anyone have any availability to case prep today? Based in ET and looking for someone relatively experienced. I’ve done/given around 20 cases

I rearrange my home office several times a year. Idk why but every 4 months I need to change it up. Anyone else do this?

My company has grown from 50 to 200, and my impact as an HR leader needs to grow from IC activities (recruiter, hr ops person) to.....hr leader. Any tips on doing that (and doing it well?)

Looking for a PwC referral. My current company has been great but we were acquired by a start up PE firm a year ago and I feel like the acquisition is starting to hinder my growth. I have 3 years experience in strategic sourcing and procurement transformation, initially starting as an intern. I want to continue advancing my career but feel stuck. Trying to give this company a chance but see an opportunity at PWC I think I would be a great fit for. Any advice?

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

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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?

I have 1 sheet with names and sheet 2 with a large list of names that may or may not be those names - which also have corresponding unique identity numbers. How do I easily match the names with the same names and keep the unique identity numbers for importing later?

What would you consider "Advanced" or "Expert" level Excel usage?

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?

Any weekend or online excel course recommendations?

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?

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

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

Would anyone be willing to teach me vlookup?

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.