Any Excel training for those new to Consulting?

like
Posting as :
works at
You are currently posting as works at

Check out Excel products from wall street prep

like

This looks like a fantastic resource. I wish someone had told me about it earlier!

Ctrl + minus when you get to the headcount tab.

funny

I thought excel was a consulting requirement

likefunny

CFI has good resources

Related Posts

Have a big interview tomorrow. The question I dread the most is about why you’re looking for a new job. The honest answer is that there isn’t enough work to go around at my agency and I want to get ahead of the inevitable layoffs. What’s the best way to tell them this? Do I just make something else up entirely?

like

Does anyone get so anxious about work that they can’t eat? The thought of food just makes you want to puke? How to manage? Skipping meals/not eating for a day is unhealthy and will cause weight gain

like

Do I put these succulents in soil now? What’s next?

Post Photo
like

What are the best security consulting firms with a focus on the federal sector?

Hi fishes,
I have got the below salary structure from Barclays . Please let me know the in hand salary per month for the same.
Thanks

Post Photo
like
like

Hi 🐟, I need help to choose a company to join between-

Fiserv and Barclays offered CTC is same.

Experience: 5.1 yrs
Tech Stack: Java, Spring boot, microservice

like

Hi, had finished technical with Barclays will have salary negotiation, offer holding 13.1lpa YOE- 3.3 Tech- Java, springboot, microservices Please guide how much they can give base upon your experience Thanks Barclays

like

Hi All,
I need your immediate help for Barclays, i am in the middle of the interview process for Barclays Pune/Mumbai, I have heard that they do check Credit Report for all roles as a part of their Pre employment screening (May be stage 1).
Is that correct?
Can someone please check their Background screening report and confirm?
I think they use Hireright as their 3rd part agency but not sure.
i would really appreciate your help.

like

Is any one know Tavisca, Pune about its work culture and job security?

like

Free MBA at Yale/Stern vs. Full price tag at H/S. What would you choose and why?

like

How do I convert my UK university score to GPA?
Scored 83% (First Class Honours)

like

Did booth say when decisions would be announced for R1?

like

What does the salary for a home health visiting nurse in the south look like?

like

I’ve been offered a reporting consultant job for less than 60k and I bring 9+ years of experience to the role. They should be offering more. I don’t want to settle but I don’t want to miss an opportunity to move. Reporting consultants should start at $65k per recruiting sites. Any advice? How can I get HR/recruiters to offer more? TIA

like

How can I stop data brokers from selling my information to political campaigns & other Ad compaigns? I don't live in California so CCPA does not apply to me..

like

Hii all ....
Can anyone give me some info regarding project allocation in tiger analytics?
It has been 3 months since I joined...still not allocated to any project.....
I am little worried about the recession news coming......

like

How long is too long to be an intern? I've been interning for about a 1 year and half now at 4 different agencies. All extended me until I'd leave for another agency. I was told bad timing/layoffs

like

Can’t decide between Hanoi or Ho Chi Minh city for 5 days in Vietnam. Also is it necessary to join a tour group? Thoughts?

Guys EY Mandatory learning course answer key anyone.!!??
If someone will provide genuine and positive answer, I can tell course name in comment.

like

Additional Posts in Excel Genius

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Any book recommendations on excel modeling for real world business applications?

like

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.

Post Photo
like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

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?

likehelpful

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?

like

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

like

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

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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!

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Anyone know what these badges are?

Post Photo
likefunny

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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?

like

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.

likesmart

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How do you fix microsoft excel cannot paste data error?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal