What would you consider "Advanced" or "Expert" level Excel usage?

Hi Fishes Accenture , I need your urgent support / help / suggestion / advice🙏🏻

I have joined on 18th April, 22 as BA in Accenture .I have got a mail stating I have been rolled off from my current project on 19th.
I am very worried now as I am on bench. Request everyone to get me a project.
Exposure: Banking, Payment Card.
Thank you in advance 🙏🏻

I want to get a job at BCG. Any recommendations on how to accomplish or anyone I can have a conversation with to understand the process?

How do u research what a good sign on bonus is? Director in non consulting, health care insurance company ?

One of these days where I wake up and I’m like “why/how tf did I get into investment banking??”

The most interesting research topic you've come across....?

I came to US few years ago , I have a heavy accent and still struggle to express myself fluently at times. Any advice on best online resources to help with my accent/fluency?

Anyone from IB Senior Associate level and above willing to chat? Just trying to gauge what kind of skill set is required to be an SA in IB. In a pretty decent spot right now but was just wondering

Kornacki and King are pulling entry level consulting hours and King is of advanced age. How long can they do this? Kornacki is like the wunderkind Associate everyone wants on their team and to shove in front of the client. King is the analyst that the smarter managers choose for the team because he is quiet and confident. He gets promoted first. Kornacki cuts ties and goes to Big 4 for a salary increase. Tapper is the Partner telling war stories at the bar, acting like he’s personally buying

Hi Fishes,
+Repost
I have 6 years of experience and have offers from the below companies, Help me on selecting the same?
I am getting a headache as my last date is approaching. Please Help me before Jan 18.

Company, project, CTCdetails are below.

Value Labs - Banking(Fullstack) - 19Fixed + 2LPA
NTT Data - Well Fargos (only UI) - 20 + 2LPA
Hexaware - Amaze Banking Project (only UI) - 20+2LPA
GSPANN - Sports E-commerce (AWS, MERN) - 20LPA*
Matrimony. com - MERN - 20 LPA*
*no variable

How is NTT global data services based on job security and salary on time

Good bar spots around 345 park (KPMG) lol

How do you deal with ADD and being able to clearly explain your ideas? Are meds the answer? Really don’t want to do that. Already in therapy. Plz help.

My company is in need of a update online, could use your opinions! We need to better showcase our culture (caring, supportive, fun, intelligent IT industry leaders) as well as diversity. We are predominantly white still but making strides to improve here. What’s the best way to approach? I don’t want to seem disingenuous or that we are singling out our diverse employees (asking for photos). We have a remote and on-site workforce about 350+ EEs. Non white EEs make up about 35% of the company rn.

I have a non business background, and I often noticed that to go a bit further on certain cases or distinguish yourself from others, some knowledge about the industry/sector can be good. Do you have a website/ressource where I can have an overview of the most frequent industries? Thank you in advance :)

Guys, I am following this guy name Chakabars on IG, any of you do? He basically talks about racism, being black, health etc... Yesterday, I saw a post where he mentioned that COVID 19 couldn’t touch>

Anyone have suggestions on where to start learning how to program add-ins with office.js?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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?

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

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?

Does anyone have an Excel shortcut guide for Mac?

Any weekend or online excel course recommendations?

New project, new massive excel file that I keep making mistakes on. Tips on error validation and performing QA?

Has anybody used the COM library and python to build reports? I'm looking for somebody to chat with about my project.

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?

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

I rarely have to use formulas in Excel, so please be kind to me.

Apart from conditional formatting cells, what formula can be used to display a word whenever a cell contains a range of numbers? Contd

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.

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!

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.