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 “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, told me “the worksheet is the canvas for the business analyst.” None of us can paint a masterpiece like Van Gogh’s Starry Night, but if we master Excel, we can start with a blank worksheet and create our own masterpiece that enables ...

Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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.