Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
10
Creating Interactive Spreadsheets Using Tables and Slicers
Index

Summary


This chapter can be very challenging for those who have not heard of the term linear programming. For those who enjoy this subject, other terms such as machine learning and data mining will make them smile. The good news is that professionals with these skills like yourself are very sought after and get compensated generously. After reading this chapter, you have learned how to model a linear programming problem and tell Excel to solve it for you. We will continue attaining advanced Excel skills and get introduced to VBA, Excel's scripting language.