How can I limit a calculation to only show values between +/- 100%? I have a calculation showing thousands of percent and want to limit.

You are currently posting as works at PwC

What role is after Developer/Senior Developer?

Posting as :

works at EY

You are currently posting as works at EY

How is Big 4 client experience + actual technical skillsets/ experience viewed when interviewing with ServiceNow?

1 reactions

Posting as :

works at EY

You are currently posting as works at EY

Has anyone taken/ hold Snow CIS-Risk & Compliance cert? If so, what was ROI for your career (exam $, study hrs, career uplift/branding)? Looking to take a CIS cert soon and debating between 2 CIS exam I have competencies in (CSA, CIS).

1 reactions

Posting as :

works at EY

▸ Advisory

You are currently posting as works at EY

How do you rate ServiceNow GRC vs leading competitors, Archer eGRC, Diligent HighBond/RSAM, Zen GRC, etc.?

1 reactions

Posting as :

works at University Of British Columbia

You are currently posting as works at University Of British Columbia

What is the Base pay and Equity Pay range for L5 TPM in Vancouver area for Amazon?
Yoe 14
Past M at D
Also the Bonus they talk about - is it a joinjng bonus or thr annual bonus?

2 reactions

Posting as :

works at Infosys

You are currently posting as works at Infosys

Hey Fishes,

What is the "Amaze delivery project" in hexaware? Can someone give an overview on the same?

Posting as :

works at Thoughtworks

You are currently posting as works at Thoughtworks

Hello Data Sharks, Looking for new opportunity ?

Thoughtworks is actively hiring data engineers across location.

JD: https://drive.google.com/file/d/1wwWVLqT6TEswfC32njyX4SILIuogDb3F/view

Interested ? Fill in this Google form https://forms.gle/x8pJFxtqPpJHKmUF8

Note: You may be asked to signin into google for fill the form to avoid duplicate entries.

Tip: You can click on three dots and select open link in chrome to use the account which you already logged in you chrome browser.

1 reactions

Posting as :

works at ZS Associates

You are currently posting as works at ZS Associates

Hi all, Can you guys do me a favor I need 11 likes to start my DM

13 reactions

Posting as :

works at OpenText

Sprint estimations 🫐🍎🍋🍉 https://www.tiktok.com/t/ZTR4KWpSo/

You are currently posting as works at OpenText

Openings at OpenText

DM me or send a mail to referralhelp.op@gmail.com.

Please mention YOE, preferred location(blr/hyd), tech stack and the job id.

For other openings visit the career portal
https://careers.opentext.com/go/India/2619917/

4 reactions

Posting as :

a Tax Associate II

▸ tax

You are currently posting as works at Tax Associate II

Taxaccountantmemes in the house!

Posting as :

works at EY

▸ Advisory

You are currently posting as works at EY

How do I classify my property for tax purposes if I received rental income for exactly 15 days this whole year? Primary?

1 reactions

Posting as :

works at Oracle

▸ Sales

You are currently posting as works at Oracle

What are some Entry Level jobs at AWS in Project Management/Implementation Consulting?

2 reactions

Posting as :

a Lead Product Manager

▸ Digital

You are currently posting as works at Lead Product Manager

Coach

3 reactions

Posting as :

works at Anna University

You are currently posting as works at Anna University

CCTC: 17
YOE: 8.3

Got 2 offers:
Lucidworks - 33
Boeing - 35(Verbal offer after countered them with lucidworks offer).

Now with freshworks, last round is pending.
Let me know what would be better.

From interview perspective, I enjoyed lucidworks interview as the interviews taken by quality people compared to other two companies. But it is a startup.

Btw, I have been interviewed for 6 rounds in Citrix and waiting to hear from them.

2 reactions

Posting as :

Annabelle Fernando

▸ Insurance

You are currently posting as works at Annabelle Fernando

Is there anyone from Canada here? I’m looking for some information on working out of the country, but selling insurance.
Thanks

3 reactions

Posting as :

a Document Control Specialist

You are currently posting as works at Document Control Specialist

🙄 😂 I’m sure the customer ordered it on the spot haha

5 reactions

Posting as :

works at Cognizant

You are currently posting as works at Cognizant

I everyone,
I have been selected for the associate position but till know I have not received my offer letter from legato company please suggest when can I except my offer letter discussion has happened on jun 27?

Posting as :

a Producer

▸ production

You are currently posting as works at Producer

A production I worked on is $250k in the hole and owes a bunch of crew members money including myself. Looks like they just missed a big deadline to keep from going belly up. What should we do?

Posting as :

an Associate Auditor

Hi everyone,
Any HR from HCL?
Urgently need some help
Please help
HCL Technologies HCL Technology

You are currently posting as works at Associate Auditor

Hi,

I am going through psychological stress, mild depression and anxiety issues due to recent workload and have lost all motivation to continue. I am planning to quit but afraid will i get a job post that. What shall i do?

1 reactions

Posting as :

works at Capgemini

▸ Data Science

You are currently posting as works at Capgemini

1 reactions

Additional Posts in Excel Genius

Posting as :

a Project Manager

▸ Human Capital & HR Consulting

You are currently posting as works at Project Manager

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

1 reactions

Posting as :

a Consultant

You are currently posting as works at Consultant

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

5 reactions

Posting as :

a Senior Data Analyst

You are currently posting as works at Senior Data Analyst

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

6 reactions

Posting as :

works at Deloitte

You are currently posting as works at Deloitte

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

14 reactions

Posting as :

a Consultant

▸ strategy

You are currently posting as works at Consultant

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

1 reactions

Posting as :

a Master Production Scheduler

You are currently posting as works at Master Production Scheduler

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 🙏

2 reactions

Posting as :

a Tax Associate

▸ Tax

You are currently posting as works at Tax Associate

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?

2 reactions

Posting as :

works at Strategy&

▸ Advisory

You are currently posting as works at Strategy&

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

2 reactions

Posting as :

works at KPMG

▸ tax

You are currently posting as works at KPMG

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

7 reactions

Posting as :

a Patent Paralegal

▸ Law

You are currently posting as works at Patent Paralegal

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

3 reactions

Posting as :

a Senior Audit Associate

▸ audit

You are currently posting as works at Senior Audit Associate

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

2 reactions

Posting as :

a Technology Consultant

You are currently posting as works at Technology Consultant

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?

6 reactions

Posting as :

a Producer

You are currently posting as works at Producer

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

10 reactions

Posting as :

a Global Head, Corporate Strategy

▸ Financial Services

You are currently posting as works at Global Head, Corporate Strategy

Sharing in case this is of interest:

2 reactions

Posting as :

a Consultant

You are currently posting as works at Consultant

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

4 reactions

Posting as :

an Assurance Senior Manager

▸ Assurance

You are currently posting as works at Assurance Senior Manager

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?

6 reactions

Posting as :

works at IBM

You are currently posting as works at IBM

Visual Storyteller

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

1 reactions

Posting as :

works at The University of Texas at Austin