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

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

What kind of business applications?

Common applications or cases particularly in finance and supply chain. To throw out a few basic examples... pricing, costing, inventory management, make vs buy, procurement spend/order quantities, transportation problems, capacity planning, etc.

Not a book ... but a Udemy course - Use Excel like a Pro. I did it after I first got out of college. It teaches a good way to properly document a workbook and organize the analysis.

EY has their own Udemy site and I see a lot of good resources there too. Not sure if yours has something like that.

Thanks I’ll check that out!

like

There's loads of this stuff on YouTube - try that before you pay

Related Posts

What are you all reading other than maternity help books? Any book recommendations for after baby is born? Mainly around how to keep the baby safe from injuries and incidents.

like

Telugu pusthakaalu chadive vallu unnara? We can share book recommendations and resources.

I read a lot of novels and some poetry.

like

Any book recommendations for soft skills at an agency/studio? For stuff like giving feedback, meetings, presentations, client interaction, etc.

like

Good book recommendations on the basics behind M&A deals and the DD process? Asking for a friend who is looking to start a search fund and has operational experience but no finance.

like

Personal finance book recommendations?

like

Any book recommendations on how to tame/work with being an overachievers? I'm assuming a lot of us have a hard time switching off the problem-solving voice in our head (I know I do!) and wonder if there anything good to read about this.

like

Does anyone have any book recommendations for information on buying a house?

like

Want to improve my verbal and written communication skills. I hear reading more would help but I don’t read as much as I used to. So I’m wondering what books would help with that? Should I just read books that tickle my fancy like suspense and true crime novels? Help! Welcome to all book recommendations.

like

Looking for nonfiction book recommendations relating to international history/diplomacy/American foreign policy!

like

looking for good PBL book recommendations (teacher book club options)

My daughter is planning to start her own small business and I’m looking for any good recommendations on books or courses that can provide her the fundamentals to guide her through the process. Any help is greatly appreciated.

like

Any book recommendations on Clinical Trial Agreements?

like

Finished Rich Dad Poor Dad and appreciate the emphasis on creating alternative cash flows (vs. just income). Does anyone have book recommendations on creating wealth? I've focused heavily on income + 'safe' investing, but intrigued to learn more.

like

Any book recommendations on advanced procurement/sourcing concepts?

Most popular books I find such as 'Procurement and Supply Manager's Desk Reference' are not detailed/deep enough.

like

I’m moving from implementation consulting - where details are super important - to a strategy role, working with C suite executives. Got the feedback that I need to think and work less detailed and way more high level/abstract. Any book recommendations to train this skill or get insights how to best think on an abstract level?

like

Just finished The Vanishing Half... any book recommendations for the holiday break?

Post Photo
like

Any good book recommendations for new Managers in consulting ?

like

Any book recommendations for the summer vacation season? What's your favorite book over the last year?

like

Upcoming interview with large tech company for biz ops go-to-market role. Any book recommendations to learn about go-to-market / sales op strategies for tech?

funny

Any book recommendations about human psychology / thought processes?

like

More Posts

Turnips are 483, comment if you wanna come by

like

How are testing projects in Deloitte banglore? Anyone has hints of roles and responsibilities in product testing ?
Please dm

Not bad for a Tuesday :)

Post Photo
likeuplifting

How long did it take you to lose interest in your job?

like

Besides salary is there any additional bonuses, stock options, etc to expect as you advance to SVP and EVP?

like

Going from 165 as an ACD to 210 as a CD? Is that about right?

like

I’ve made myself an invaluable part of our team, but I know other Account Sups in my office with less experience + a higher salary. I believe in merit-based raises, but is it ever ok to mention this?

like

Do you count internships towards your years of experience? I did 20 months all together interning but not sure if that moves my needle from mid to senior when job hunting.

Posting on behalf of my friend.

He is a 2017 CSE graduate from Tier 1 college and is having 5 years of gap as he was preparing for upsc.
Now he wants to have a career in IT industry.

Please suggest how can he get a job?

How easy internal mobility in Atlassian India for EMs if they don’t like work in the team?

I have two questions. I have 10 years of experience in multiple sectors and I have been trying to gain a leadership position. I am attempting my PHR this summer but what are some tips in order for me to obtain a leadership position? Also, how long does it take to obtain another position out of state? I am trying to move to Houston but I don’t want to move until I am confident I can obtain a position in the city before packing up and leaving.

like

What programs do my fellow HR managers recommend as far as personality assessments for hiring ?

like

I am trying to land a role as a human resources business partner and I'm wondering which certification would be the best for me going forward. Phr? Shrm? Thoughts? Thanks!

like

Pretty sure the saga of the slave driven company has come to an end I’m the only HR person at this company. Friday I had full admin rights, and went to check email Saturday; account locked. Payroll/HRIS locked out. PEO service says no pending termination is on my file. Went to the office today to get my things just in case. Located in CA. Was about to report numerous violations too. All because I couldn’t solve 8 months of payroll issues in a day. 🫠 Good riddance, I’m getting a lawyer.

like

Hi folks, my base location as per EY GDS offer letter is Noida but I want it to be Gurgaon as my hometown is in Jaipur and Gurgaon is more convenient for me.. I sent email to my senior manager and got response that you can use flexibility and work in any Gds office in India. However, I feel that in case my base location is not being changed, I should shift to Noida rather than Gurgaon as there might be any formalities or facilities which we need to avail in our base location only.. Any thoughts?

like

I am not able to upload my tax declaration details from the greyHR portal. It is showing an error message since morning. Is there anyone else who is facing the same issue

likefunny

Informatica openings any?
9+ experience

like
like

Does any one know UK onsite salary for manager role for short term

Hi Avanade fish, I am interested in joining the Security practice and would like some insight in the role from folks in the practice.

helpful

Additional Posts in Excel Genius

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

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

Post Photo
likehelpful

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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!

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

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?

likesmart

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?

Post Photo
like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

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?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
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