Excel is the world's most widely-used spreadsheet. In this book and its accompanying CD-ROM, students learning data analysis are shown how to create sophisticated worksheet. The book works on the ...

Success in business and science means making smart decisions. And those require the kind of information you can only get from sophisticated data analysis. It’s a growing field with huge opportunities.

Mastering Data Sorting: The Foundation of Pareto Analysis The first step in applying the Pareto Principle is to sort your data in a meaningful way. Excel’s sorting functionality allows you to ...

The Excel Data Analysis Toolpak is a powerful addition to any analyst’s toolkit. By following the steps outlined above, you can easily install and use the Toolpak to perform a wide range of ...

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...