We covered many of the common data issues that you might encounter when working with data and several strategies to deal with them. Every dataset will have its own challenges that go well beyond what we have covered so far, but by the end of this chapter, you would be able to handle a good number of scenarios. What you can bet on is having data quality issues which will force you to clean your data. As we saw time and time again, Excel has plenty of built-in tools that will ease your pain and make your life a lot easier. In the next chapter, we will continue to focus on how to prepare our data but we will take it to the next level. Advanced uses of formulas and conditional statements are introduced with simple-to-follow examples.
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