I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

Hi guys,
Do we need to carry printed affidavit stating no criminal offence notarized on stamp paper on joining date of TCS ?

Are there any disadvantages of joining a C2H role purely on the basis of high CTC even though it is for a big client of the contractor company?

Public library near to river north?

Tiger Analytics - Senior Software Engineer(Data Engineering), [WFH]

Fractal Analytics - Azure Data Engineer, [WFO]

Airtel Africa - Big Data Developer, [Currently WFH]

Which one to choose, the compensation is more or less the same.

Looking for a learning environment.

YOE - 2

Which one I should join TCS or Virtusa? Virtusa is offering 3 Lacs more than TCS?

What will be the avg hike for progressing rating for manager (32-2)...joined in Feb 2022.

Share the best news you've seen today please!!
I haven't had a good week, but I'm sure this community can make it better :)

I've recently went to a restaurant and saw a robot waiter, I thought that was the coolest thing. What do you all feel about this shift in the restaurant industry?

What is considered a “large” caseload in employment litigation? I work at a large L&E boutique law firm and handling about 14-15 active litigation cases in state/federal court or arbitration. Some of these matters are multi-plaintiff and multi-defendant cases, but none are class actions. This does not include any matters I am handling in the charge stage or in pre-litigation. Not sure if that’s a typical caseload or not?

Did anyone from INFOSYS after accepting got their CTC revised by showing them a higher offer? Infosys

Does anyone have any company recommendations for where I could reasonably expect to earn $80,000+ in a remote role in the US? I recently finished my MBA and have several YOE, and I’ve been targeting analyst/consulting roles after completing the Google Data Analytics certificate. Any input is appreciated.

Advice needed - final interview last Friday at one place, heading into final interview at other place next week. If I get an offer at one before final travel interview at other, any suggestions Cont'

What is the last date to get H1-B approval decision ?

Just wanted to confirm if we have an option for buyouts during the NP,is it normally negotiable to 30 days,how does it work?

So finally when all this rush of V day is over, lemme know if any female ZSer from ND ofc in age bracket of <25 is interested for a pizza connect !

I’m super happy and excited to exit out of consulting job.
I met all the check marks every appraisal cycle but still I was given the same reason every year. Need book of business or sales experience. Finally, I’m out of that cycle. I’m joining one of the FAANG!

Cheers

Hi everyone, I will be highly obliged if someone can share the interview questions for data scientist/decision consultant role in fractal

How much I can expect from SAP LABS or ask them in HR round for product specialist role at T2 level already have an offer of 21 fixed.
YOE :8

How about comcast developer role in Chennai - Sky project.
Job security?
Career growth?
Work life balance?

Please give suggestion

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

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 😭

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

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.

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

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?

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.

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).

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)