What's your go-to Excel shortcut that saves you time? Let's create a collective list of shortcuts to boost everyone's productivity. Share your favorites!

Are there any pharmacists here who transitioned out of retail?

Hello 🐠-
I recently started in a sales role. Have a heavy consulting background (20 years) imagine big four and SI experience. Question - from here how easy or difficult is it to move internally. What areas within SalesForce value the consulting skill set. I have managed large teams and P&L of $20M annual. Big name client experience and complex professional services sales and delivery experience with global teams (India, UK, Latin America).

Hey how is appraisals in altimetrik ??

What has been difficult for you in the endeavor to complete half your deen?

I'm a servicenow developer, which company should I join? Globant or workday?

Hearing of layoffs with some Chicago agencies. MSL...Porter...Ketchum...others? Sign of bad economy coming? Hate to sound skittish, but I lived through 2008

I am interviewing for a clinical specialist position with Haemonetics. Does anyone have any experience working for them?

How is the onsite opportunities in the coforge..?

HR called me and said this position is for onsite once the border gates are open...? Can i believe HR words..?
I am interested in Onsite opportunities.

Hello Fishes,

Any idea when we get relieving letter/service certificate from TCS?

My LWD was 16th September and I received FNF 10 days before. Also got initial release letter on my LWD.

I see so many issues in this organisation.
When I joined TCS after 5 days of joining they used to mail me every week for 5 continuous weeks and asked me every time for previous organisation relieving letter.
But they themselves don’t share it and delay a lot.


Anyone please advise.

So what's the deal with read receipt requests? Are they timing people once they have that notification? 🙄

As variable pay tenure in #EY is from July to June so if we are in notice period and my last working day is last day of August, so will i will be able to get the VPB for this year?

About to go in house from biglaw for the first time! Made this group for everyone like me and those who have more (or less) experience to share! Already at 100 members in several hours!!! 😎😎😎

What is one classic that you have substituted with a more cultural relevant text?

Has anyone here considered obtaining citizenship by investment in one of the caribbean countries? Seems like a relatively low investment (100-200k) and you get a new passport in 6 months. Why isn't this option talked about more?

🚀How much salary range for VP - K grade in bnym ( Bank of New York Mellon) technology department? Skills - Java microservices Expr - 13+ yr

@bny Mellon technology

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

If an employee files a complaint about workplace behavior, do you treat them differently? I'm faced with reporting an SM for bullying and finding it near imposible to believe that it won't (cont'd)

Anyone here worked at Goldman? How did you get your opportunity?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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)

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?

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?

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!

How do I compare two sheets to make sure they are identical?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

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.

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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 😭

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?