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.
Data Analysis and Business Modeling with Excel 2013
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
Free Chapter
Getting Data into Excel
Connecting to Databases
How to Clean Texts, Numbers, and Dates
Using Formulas to Prepare Your Data for Analysis
Analyzing Your Data Using Descriptive Statistics and Charts
Link Your Data Using Data Models
A Primer on Using the Excel Solver
Learning VBA – Excel's Scripting Language
How to Build and Style Your Charts
Creating Interactive Spreadsheets Using Tables and Slicers
Tips, Tricks, and Shortcuts
Index
Customer Reviews