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

Who’s got book recommendations? No lame “business guru” books that repeat the same principle over and over again.

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

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

I was recently hired as an event coordinator/project manager for my company. Are there any online certification courses I could take to freshen up my skills? I would also love book recommendations or trade article recommendations. Thank you in advance

like

Any book recommendations for philosophy, psychology, and business? Or any book you read last year changed your values? Going to fly international, gonna read it on flight. 😍

like

New to investing. Looking for any/ all tips... book recommendations, YouTube videos on how to get started

like

Book recommendations for helping to re-light the fire under my ass for big ideas/remembering why you got into copywriting?

likesmart

3 Audible Credits to use before I cancel my subcrtiption. Looking for book recommendations.

And, go!

Anyone here have any good book recommendations for the quarantine?

like

Any good book recommendations for best consulting practices, approaches, etc.? Looking to take my PowerPoint/communication, managerial, sales, and strategy skills to the next level. Thanks!!

like

Book recommendations on genetics and bio hacking?

like

Any (light) book recommendations to read- non fictional, not self-help. Psychology, abstract, biography, science, human evolution, how our mind works, etc..

like

Book recommendations on Audible for a young male attorney struggling to get back to living a healthy lifestyle (physically, mentally, spiritually)? Open to any genre.

likehelpful

Does anyone have recommendations on books or courses that do a really good job explaining step-by-step on how to start and run a mid-size business (local marketing agency, self storage real estate business, call center for third parties, etc.)

like

📚 anyone read anything really good recently? Ideally looking for book recommendations in 2 categories:
A) self-help
B) thriller/mystery/crime fiction
🤗

like

What are your book recommendations on Audible? Non fiction or fiction

like

Any book recommendations on executive presence?

like

Any book recommendations?

like

Book recommendations for a vacation?

like

Book recommendations for newly minted managers?

like

More Posts

Are there any interesting careers/projects to pursue within IT Audit that have some transferable skills for later on in your career?

funny

Is this where the cool kids post their cooking? Homemade cauliflower pizza

Post Photo
like

For all that may be interested in working at home.

like

Thoughts on a 9 year partnership track? And it’s 9 years until you’re eligible—it’s not guaranteed. And if you’re a woman and have a kid, you’ll mostly like need to take a year off.

likesmart

Anyone get a credit extension beyond your state’s designation? For example, I am in NJ and they said credit extension until end of 2020, but that only gave me a few more weeks. I have contacted state

like

How long does it typically take for applications at amazon to be reviewed? I recently applied to two part time positions and completed the online assessment and am wondering how long to expect for this process. If anyone is willing to refer, that would be greatly appreciated!!

like

*URGENT JOB NEEDED* - BDM/E-com account management roles
Hey all, as I see a lot of recruiters in this group I wanted to know if anyone is hiring for BUSINESS DEVELOPMENT MANAGER or E-COM ACCOUNT MANAGEMENT or VENDOR MANAGEMENT roles.
My husband is relentlessly trying to get a job in Canada/US but he is getting either regret mails or no response for referrals.
It would be really helpful if there is anyone is hiring for such roles or if you can refer to those roles in your organization. TIA :)

like

Anyone done dropbox recently in Mumbai for their first H1B renewal? Care to share the experience? Was anyone requested for interview after dropbox? TIA

Hello, I am holding us payroll experience for 8 years. Can u get into sap hcm ? After taking SAP HCM Course ?

like

Hyd folks - Heard first hand horror stories of friends struggling to get care at hospitals for family members with COVID. Even with all the money and influence. Stay safe!

Anyone cash flow positive on an investment condo in Brookline/Brighton?

like

Hi,
Is LM provide salary account for the employee?
Which bank?
If not hdfc then If we want to open in HDFC bank what needed and to whom should we check this?

What is the starting audit manager salary for Grant Thornton in South Florida?

Whyyy this group is so slow

likefunny

Anyone trying to buy a house right now in Boston? The market is insane. My SO and I have lost 4 bids in the last 2 months to people who offered wayyyyyy above asking. Is it worth getting into real estate right now to get the low interest rate but inflated houses?

like

Hi
Pol and 16k PLN per month gross vs 30Lakh Bangalore. Which one is good. Pros and Cons in poland? Please.
Tech stack : Devops AWS. 8+ YOE.
Both are Service based company

like

What’s on your list for Restaurant Week this year?!

like

Hi Everyone. This question is specifically for people who have an Abu Dhabi work visa. How long did it take for your work permit to come through after you provided the complete set of documents to your firm? Thanks!

like

I've been fostering different cats for a while this whole pandemic, but I think this little guy might be my first failure.

Post Photo
like

Has anyone tried forever bloom brand specifically their foundation/cleanser/Vitamin C cream?

like

Additional Posts in Excel Genius

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)

Opinions wanted: I inherited an excel file around 2k rows and 50 columns used to manage stakeholder communications. Mostly free text fields and it feels very chaotic. It will be easy to miss an update/ hard to get a summary of changes without reading most of the columns. Would it be worth converting to an Access Db just for my use? Willing to put in the time to figure it out, but not sure if it will be more/less difficult to manage over time

like

Hi I’m doing a copy and paste from my online bank which contains the data I need but when I paste it embedded small icons for each lines and I need to do another copy values only each time...

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

What’s an xlookup?

like

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

What’s everyone’s favorite keyboard? Thinking about switching mine up

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

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Too many format error, already tried the XLStylesTool. What next?

I have about 10 variables each with a certain score (10,14,15, 20,20,20,7,9,2,1). I need the max value is there is a single winner (MAX function work here.) If there is a tie for the highest score, I need an output that says “Multiple.” How would I go about this?

Thanks in advance!

like

Assistant sent me a sheet with ~500 rows, many of which have multiple entries that should have line breaks between each. Instead of using alt+enter for a line break, they manually formatted using spaces to move entries to the next “line” in a given cell. Is there a quick fix?

like

Excel 🐠, need your help: how can I have gridlines removes as default? Not for a current workbook, but for all workbooks opened.

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

like

Is it possible to have a table where the first 8 columns are pulled from a source in Power Query, and the next 6 columns are “data entry” items where I can fill in information based on what the first 8 columns show?

like

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

What’s the best way to compare lots of data with time stamps? I.e. you’re trying to evaluate the time different steps in a process take for multiple line items (10000 rows)

Current approach I’m doing is to subtract the times (in hh.mm.ss) from each other to get the duration of each step. Not sure if there’s an excel time stamp function that would make this easier. It’s not working well for times that were late PM and bleed into early next day AM.

I am pretty good at excel but have not learned any new functions in last 8 years. What is the best way to keep up with new excel tools? Any app recommendations that give you a short 5 min tutorial daily? I don't want to spend more than 5 minutes a day.

likesmart