Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

Hello Fishes,

I have an offer from EY LLP for kolkata location, I have few questions before I join.
1. What's the difference between EY GDS and LLP,
2. How is work life balance ?
3. How frequently they ask you to travel to client locations.

For me it's a domestic PSU bank project. I am looking for suggestions as I am completely from IT background.

Looking for a referral for a Government consultant position or a Management consultant position. I have 1YOE in government consulting and 3 years overall experience which consist of research and client focus positions. Don’t have a specific company in mind.

Hello everyone ! I hope all are doing good. I had got an offer to work for JP Morgan Client. Will you guys suggest me if i should go for it.?

Can M/SMs share your experience leaving Deloitte GPS for the commercial side of a competitor firm. Will Deloitte honor my 2wks notice or ask me to leave immediately? Want to give my client/team notice

Hi fishes,
I joined cognizant on 2nd Nov 22. How long it will take to allocate a project?

Recently laid off and looking for recruiters that specialize in media/strategy/advertising (both agency and client side). Sure there are others looking as well - would greatly appreciate any info.

You’re given a brief for an OOO campaign. Could be cool. How many days are you given before you have to show concepts to the ECD? And to the client? Curious about time expectations at different places.

Hi There, Got the offer from Nagarro and soon going to join, can somebody help with below queries?
1. How is the project allocation done?
2. Allocation bonus is given only if in project? Is it depends on performance factors or only prorated basis?
3. If in bench, salary deduction or job security concerns?
4. In offer given Mumbai location which is my preferred location but not able to find there address in Mumbai, let me know if anybody has the address?
Your response will be much appreciated.

Partners, a program manager running a large, newer account (with a lot of potential) is rolling off, and I have been asked to be the replacement. Any advice for taking over a new team at a new client?

Urgent joining coming up:
Robert Bosch 23 or Palo Alto networks 22 + stocks $6k per year for Sr Analyst role? Bosch hybrid and palo wfh?? Palo client role
And Bosch service Role

I’m a new CbDer. I don’t come from a technical background and am currently working on a mainframe project as my first project. How do you guys advise me to add value to the project?

Any recruiting firm/specific contact with a good client book in finance (London)?

Does anyone know the entry level salary for Project Manager at Epic Systems? Its located in Wisconsin. Thank you!

2 questions: what is your favorite mail client for the Mac (OS X) and other favorite Mac apps (productivity etc)?

I love MS To Do (formerly wunderlist), I just wish OneNote was as good

How to fetch an on-site/client opportunity? Been into Analytics & Consulting from past 6 years. I've continued with a firm for 5 years and they just ended up making excuses for senior folks being priority.
I'm very passionate for consultancy services/ideas. Was even able to fetch some 250k worth of projects to the firm.
I'm desperate for an on-site opportunities and trying everything in my power to achieve that. Any ideas/guidance would be highly appreciated!

What is typical comp for an AD in big pharma in a commercial strategy role? Currently at 230k+20% in consulting, trying to gauge if pay would go up down or stay the same if I jumped to a client role. I think of my AD clients as junior to me but I realize I may have had some misconceptions about comp level on the client side

Looking for opportunity
YOE 15
Skill :
_enterprises data management
_data migration
_project management
_salesforce
_team handle
_shell scripting
_SQL
_CRM
_Sible
_ETL

Industry experience_
Telecom
Banking and finance
Consumer goods

Traveling to NYC soon and I wanted to know what restaurants are worth visiting... I feel like I have high standards working in the hospitality business!

Thought and prayers with me who has been tied up in meetings and didnt take a second look at closing my positions in case theres stimulus. Got 1k in snap puts, 1k in spy puts and about 500 in UVXY calls, all are mid november or later at least

Does having a partner (not married, but long term relationship) who is currently an MBA student help my admissions chances at that school? If it matters, what is a tasteful way to mention that?

Hello all, I am working as Javascript full stack developer(MERN). My current salary is 8.5lpa and I have 1year 9months of experience...how much should be my expected salary for switching. TIA

Hi Fishes.

Looking for Job referrals for C++ roles. LWD was 17th October.

C++/ YOE=5.6

Thanks

In my 1 year in corporate this is what I have understood.
1. Choose your friends wisely.
2. Focus on skill development.
3. Gossip and office politics are more or less common thing in corporate. We may not avoid it but limit ourselves as much as possible.
4. expect unexpected things.
5. No one really cares for you, so you have to set
your own priority and take decision accordingly.
6. You will understand whether your colleague is actually your friend or not only when you will be on np 😀.

I might actually work for the worst partner in BigLaw. Literally tries to crush my soul. And I’m not sure why, I always try to over deliver. I was planning on leaving for another firm but Covid happened. I feel stuck and helpless, but I’m thankful that I still have income. This isn’t a question, just a statement and cry for help.

Hello actively looking for a job change.
Is there any openings for software Tester if so please refer and dm me the details.

Thank you in advance.

How much CTC will be provided by Honeywell for 3.5 years experienced.
Cctc: 8.48lpa
Tech stack: full stack developer

Tomorrow is the first day of the new work week. What are your goals for this week?

Any single ladies looking for a handsome cub? 😉😘 DM 28AZ

Jacksonville this week! Anyone in?

Anyone have night terrors? Woke up screaming in another room last 2 nights. Last night on the floor after hallucinating that a laser was going thru my brain b/c I “didn’t take my pill” contd

Any 7+ years exp person in AWS/Data Engineering? We have an opening with handsome pay.
DM for more info
Company - Fractal

Hello , I have received box from synechron even before joining. Should j be opening it I am not sure if I want to join

Hi all, trying to decide whether or not a move to San Francisco would be worthwhile, currently WFH just north of Toronto as a PM and wondering what the pros and cons of the Bay Area are compared to here, thanks!

Hello!
I am currently a substation design electrical engineer 1.

I am making $71k a year from a large Consulting firm.

I have a bachelors and masters degree in Electrical Engineering. I have passed the FE & PE exams, I am an EIT, and I have a year of experience outside of school. Three internships as an engineer while I was in school.

I feel like I am underpaid and would like to know the thoughts of others. I feel undervalued in comparison to what other companies over that do the same work.

What are the reputations of FAANG companies as places to work? What are your preferences of which firms you’d want to work for/not work for?

Any massage therapists as a side hustle?

If I have NAME, REF etc errors in different spots of a very large worksheet, is there a quick way to delete all formulas that are bringing errors?

Is there a way to wrap your header text within access database?

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

Problem:
There is a table. Column A:D are mapped to column E with unique records. In a new column (Q), there is a list of values that that contain any randomized value from Columns A:D. What is the syntax to map Column Q to column E?

Is using INDEX/MATCH the right direction?

Does EY’s version of excel have Xlookup? I don’t see it

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

My boss has advanced skills in excel and I don’t. We share documents but we are never on the same page with the data updates. How do I make the document a live doc, like google sheets? Also does anyone know how I can sharpen my skills without being in a lecture? I’m a visual learner, I have to see someone do it then I pick it up :/

I am running a macro that uses "Application.FileDialog(MsoFileDialogType.msoFileDialogFilePicker)" to select a single workbook file and then open the selected workbook.

Cell A1 on Sheet1 of the workbook that is running the macro contains sheet names that can be selected from a drop-down list. I want to be able to use the sheet name that is in cell A1 to select that sheet in the newly opened workbook.

It's probably something simple, but I can't seem to get it to work. Any ideas?

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.

Has anyone had any success here with recording a macro to set up a pivot table? For context, I am just looking to run a pivot and then run the macro and have it show the pivot table completed with the right fields in columns, rows, and values and then also formatted how I want. I tried to just record doing the setup of the macro, but I got an error message when trying to rerun.

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.