If you had a table of customer experience/satisfaction survey responses for several questions (non-numeric but discrete possible answers, no free text; 1 question per column and 1 responder per row), how would you approach determining significant insights within the data? Excel's "Analyze Data" feature doesn't really suggest things that make sense in the real world. Is there something you would try with correlations somehow, or would you use a non-Excel tool entirely?

I’m in big law and on the cusp of making the jump to in-house. It sounds like the company I just interviewed with is getting ready to make me an offer. It’s definitely going to be a pay cut coming from big law but I do get some nice equity in the company. Is the jump worth it? I’m so burnt out by big law and this seems like an awesome opportunity to help shape a newish company. Any tips on how to figure out if this is the right move for me?

I’m currently a Grade 11 at Cisco. With the recent pay structure changes my annual comp will be $150k + 12% bonus. I live in a large metro area in the middle of the US. I’m looking to move around the company so that I can make commission but I don’t want to be an account manager. Can anyone tell me if there are Customer Success Managers, etc positions that manage customers post sale and have a similar range base as me with commission plans? I’m just trying to understand income potential.

I’m an in-house lawyer with two years of post JD experience. I’ve graduated from a top Canadian school (if that matters). My work is focused on regulations within the capital markets. I’m considering management consulting. I’d like to know what salary range I should aim for at Deloitte, PWC, etc at their NY offices. I appreciate any insight you can give me.

Hi,

I am currently Sr Con in Deloitte in Identity and Access Management. I have received offer from PwC which is a 22% bump in salary. Is it recommended to join PwC?

How well does 1 year in a top 4 looks on the resume when trying to look for a software development role?

Do people working in IB, PE, Consulting, etc. get any financial aid when applying for top MBA programs (M7 or T15)?

Welcome dental professionals! I’m a Certified Registered Dental Hygienist in Florida with over 10 years experience. I have held leadership positions and I am passionate about advocating for the dental professional. Let’s talk periodontal protocols, salary, quality care over quantity. No dental topics off limit. Let’s educate each other!

I am working as business analyst having total experience of 5 years 8 months and as a business analyst 4 years and 4 months. I have got offer of 11 ctc with 10% variable on current CTC of 5.75 , Can you guys please tell me what should be the expected CTC for this experience?

I take care of clearing all medical claims for a home health office in Lexington, Kentucky. What is the salary range for someone else with a similar position?

Anybody here an Account Manager at AON?

How do you like it?

What company runs the background check?

Hello everyone, I just moved to Toronto and looking for a job preferably as Enterprise Risk Management Specialist/Analyst. Any help would be appreciated!! YEO - 4 years.

Does insurance cover vision and dental?

Who sees your bad reviews besides your counselor?

What’s salary for senior data architect in DnA? Anyone knows?

Got an offer from syneo health gurgaon of 12 LPA for 2.5 yoe i don't know much about the slabs! If anyone can help with that??
And also the working environment of this CRO...

Hello Fishes,

Anyone from Zen n Art, how's the company? I have got an offer and the client is PwC

Does anyone know what the NOC would be for an SAP consultant? Is it 2171 - Information systems analysts and consultants?

Also does anyone know what the job title would be in the letter given by Deloitte for a Consultant? Will it be Consultant or will it be technology consultant or will it be something else?

Hi team. Hope you all are well and safe.
I will be joining Accenture in two weeks, want to get some understanding on the current policy on remote work and return to office date if there is one.
I am currently in Seattle, WA, USA.
Thank you!

Friends any Sap Security and GRC openings . Plzzz refer me... I need a job... I have 5.2 years exp in SAP security and GRC.

Hi Friends, i attended 2 client interviews and both went wrong. I don't know what to do. I am new to EY GDS......Is anyone faced the same ?

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?

My sheet has multiple cells with Notes. Whenever I reorder rows or add new columns, the notes go completely out of whack (get displaced or squeezed). Any quick fixes? Also why does this happen?

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

Any weekend or online excel course recommendations?

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

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?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

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?

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?

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

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

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 useful are Macros and VBAs for tax prep?

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

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”

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

PowerQuery > PowerBI .. thoughts ?