Excel users don’t care about “features”; they care about solving problems. That’s what Analyzing Business Data with Excel is about: solving real business problems, like measuring quality, employee performance, or even complex business processes. You’ll get comfortable with a raft of important Excel features: array formulas, statistical functions, and PivotTables to name a few. But Gerald Knight stays focused on what you can accomplish with these tools.
You’ll learn how to forecast workloads, then learn more complex modeling techniques based on regression. There’s a full chapter on statistical process control, essential for anyone involved in Six Sigma or similar initiatives. Knight walks through capturing individual performance within complex workflows: for instance, the efficiency of customer service reps. Finally, if you’re sharing your work, you’ll appreciate Knight’s concise overview of building workbooks people can actually understand. Bill Camarda, from the April 2006 Read Only