Chapter 1
Basic worksheet modeling
Questions answered in this chapter:
How can I efficiently determine each of my employee’s weekly wages?
How can I efficiently determine how much a bakery owes each supplier?
How can I predict the number of customers a new health club will have in 10 years?
What does the phrase “Please excuse my dear Aunt Sally” (PEMDAS) have to do with writing correct Excel formulas?
How can my local coffee shop determine how changes in price and unit cost affect profit?
A friend of mine, Dennis Fuller, once told me, “The worksheet is the canvas for the business analyst.” None of us can paint a masterpiece like Van Gogh’s The Starry Night. But if you master Excel, you can start with a blank worksheet and create your own masterpiece—one ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
