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

Anyone have any good sales book recommendations (not overly cheesy)? Looking for a new audiobook for long jogs.

like

Any book recommendations for first time dads?

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

Cook book recommendations?

Book recommendations for 6th grade?

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

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

Does anyone have good book recommendations over Christmas break?

like

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 good, recently released book recommendations? Genre: Business, Non-Fiction

likehelpful

Advice or Book recommendations on how not to get bothered by others/ friends/ peers? What they think or what they do!
Been struggling lately

like

Book recommendations (helpful in career and/or personal life) + WHY?

like

Any book recommendations on handling office politics?

like

Educational book recommendations! I love to read, please list any educational books you loved, especially related to special education!

like

Any good book recommendations on psychology?

like

Any recommendations on books to read for a small business attorney?

like

Any good book recommendations for new Managers in consulting ?

like

Any book recommendations on toddler behavior?kid is 18mons and my SO recently took a local role and he thinks our kid is spoiled . So when my kid had a meltdown today when I didn’t contd..

like

Hi! I’m looking for non-fiction book recommendations. Memoirs, self-help, business... anything really 🤗 TIA!

like

Some book recommendations for software engineers. You're welcome. :)

Post Photo
likefunny

More Posts

Anyone know experienced and reasonable electrician plumber handyman landscape guy serving the north Austin Cedar park area?

like

How much an ACD make in Chicago? And a CD?

Story of my life... 😪

Post Photo
funnylike

Asking for a friend..
Can anyone provice a referral for social media marketing job for 1yr Exp

like

Genuine question: Do y’all Big 4 audit and assurance people really like doing what y’all do? Coming from a similar background I feel like I dodged a big bullet. This was such a big flex back in college to score a Big 4 audit job but looking at what y’all actually have to do makes me sad.

like

Those who resigned with L1, how many days are allowed to stay in the country from the last day to take care of personal affairs to leave the country? Reference to legal ground would be helpful since I hear 30 days, 60 days, and immediately...

like

Has anyone been in a position where they have been working on a case drafting all the pleadings, motions, and communicating with OC, but once your supervisor sees how much youve racked up in fees,tries to settle it before you can, so they can collect the commission/fees on it, instead of you. I’m incredibly annoyed because I’ve been practicing the same area of law for 4 years and my supervisor has been practicing for 8, but the previous 7 were in crim law. Her advice is usually unneeded/wrong

like

What is an ideal/current compensation range for Senior Associate 1 in PwC. I’ll be joining R&R data analytics team soon after the HR round is completed. Please provide some insights.
Also, the HR asked if I’m eligible for gratutuity and i said yes since i have more than 5 years of YOE at deloitte. Is it normal or will that effect my new comp discussion in any way?

like

What’s your favorite side-by-side double stroller that has decent suspension? Will be starting school drop off with toddler and infant in the fall and want to ensure both can nap on the walk. Thanks!

like

I need some help. My company got bought out and i found out i am getting paid over 20k lower than my counterparts and i have more experience and a higher degree than them. Any suggestions on how to push for a raise? I have 8 years experience, a Paralegal Degree and a bachelors and i am told i am an asset to the company. I am in corporate law. Any help would be greatly appreciated

like
like

Im a senior finishing up my bachelors in computer science. I am looking to get into cloud computing and or Software development and i have been learning and getting certs in my free time, but i know in order to make it in life I need a mentor.. does anyone have any tips on where I could find one?

like

Looking for Male replacement (single occupancy) in a 2BHK apartment with unattached but dedicated washroom in a good society with Gym, Clubhouse, Badminton Court, 24x7 water.

Location: Ubale Nagar, Wagholi

Flat is kind of unfurnished, we have setup wifi, purifier and stove, so setup cost will be there.
Interested people comment/dm me.

Rent:9.5k
Deposit: 25k

like

I’m starting a job as a Computer scientist for the Air Force, civilian side, next month. I rarely touched code since I graduated in 2020 but I still know the basics and can still read code just fine. Is there anyone else who works as a computer scientist/ SWE with the Air Force who can give me any tips or any insight into what working federal is like?

like

Anyone at Cambridge Associates have a a talent acquisition or recruiter contact? Recently applied for a role and trying to increase the likelihood my application gets seen and I get a call back. Thanks in advance!

like
like
like

Hello Fishes,

I got offer from Accenture and HCL. HCL offer is slightly better than Accenture in terms of pay. Now, I have requested Accenture to revise the offer to match HCL offer.
Will they match HCL's offer? If yes how long will they take to revert back?

like

I’m new to B2B Tech Sales, about 2 months, but I’m not new to sales. How long does it take to ramp up and be competent enough to speak with prospects and not feel uncomfortable? I’m speaking with prospects that have 10 years plus of experience in tech and I have 2 months! I feel this may be harder than I thought!
When should “get it”?

like

Has anyone tried Brainzyme? If so, what do you think?

like

Additional Posts in Excel Genius

Anyone know the alt key shortcut to open the activate sheet dialogue box (ie right clicking arrows in bottom right of window)? The a is underlined, so it theoretically had a shortcut at some point in time...

like

Really wish my clients didn’t use Google Sheets. This sucks.

like

Hello Everyone, I am looking for some excel tips to create Bill of materials using the master database. Example my master database has got Parent item and their corresponding child item details. Tricky part is - sometimes a child item can be a parent item by itself, which means I have further explode that child item to its micro level.

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

does anyone know what CVS medical excel assessment for finance analyst consist of? I have an interview in a few hours

like

Hello Everyone!
What is your opinion about Coursera, LinkedIn Learning, and Udemy courses? I enjoy learning about several subjects, but I want to invest on something that will add much value and that is with my money! Any suggestions? Thank you!

like

Any advice on mechanical keyboard switches to use? I work in consulting and do a lot of modeling work in Excel. Any and all feedback is appreciated, TIA!

helpful

Question. I have data in Column A & I want to color highlight cells with data on Columns B-Z that don’t match A in the same row. How could I write formula/function that can do this?

like

I’ve used Excel for over 15 years. Functions and VBA were my go-tos. But today I just learned about power query (now known as “Get and Transform Data”). Total game changer. That’s all I have to say!

likeupliftingsmart

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

That time of the week again! Weekly tip thread below:

like

PowerQuery > PowerBI .. thoughts ?

like

Probably the easiest thing for many of you excel experts but I cannot figure out how to count a set of cells that were merged and blank as 1 value

So if I have 2 cells merged with nothing in the cell, and I want to count the number of blank cells, this should count for 1 value and not 2.

Anyone know the right formula for this? Count blank is counting it as 2.

What I really wanted was a total count of cells regardless of whether it has a blank or not with merged cells counting as 1

like

I want to get the unique values in a column of cities (say column B:B) but only for cities that, in the region column (A:A), are Europe or Asia

What’s the best way to combine UNIQUE and FILTER to do this? Thanks

like

Does anyone feel like vlookup solves most problems?

likehelpful

How do you convert round edges of a chart to sharp?

like

Hello, I have a report that lists every time costs are updated. Sometimes, people accidentally update costs incorrectly. There is no way to remove the accidents. I want to get an average costs for the current year, not including costs that are 10% lower than/more than the general whole. I'm thinking, "averageifs([unit costs],[item number],"="&A1,[year updated],"="&year(today()))" but I'm not sure how to remove the mistakes...

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

I have two sperate sheets, i need to extract volume and cost from the second to the first sheet, but they have to match the criteria like origin/destination, packaging type, what can i use to do so?

like

I have a sumifs function that I’m trying to do (see screenshot). What I usually do is run it across so there is only one criteria but line it up with the first range being January, but what I was hoping to do is have the second criteria be the dates which would make it a horizontal pull in contrast to the first criteria which is a vertical pull. Does that make sense? Is a simple sumifs function going to work for this? The screenshot shows how I currently have it and it works but not how I like.

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
    <