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

Chapter 10. Creating Interactive Spreadsheets Using Tables and Slicers

This chapter introduces additional materials to the advanced Excel developer in the presentation stage of the data analysis life cycle. In the previous chapter, we learned how to create tables and charts, but in this chapter, we will make them come to life. So far, we have been representing data in a static fashion. What do I mean by representing data in a static way? I mean the Excel report that we have developed so far is not interactive. What you will learn in this chapter is how to leverage Excel's new features to add interactivity to your spreadsheets.