Managing Data Using Excel Book

Managing Data Using Excel is an Excel book about data science, data analysis, data interpretation, and statistical analysis.

Microsoft Excel is a powerful tool that can transform the way you use data. Managing Data Using Excel explains in comprehensive and user-friendly detail how to manage, make sense of, explore and share data, giving scientists at all levels the skills they need to maximise the usefulness of their data.

Managing Data Using Excel gives you the skills you need to be organised with your data, which helps with data analysis and data interpretation. The book is split into two broad parts:

• Arranging and managing your data.
• Using your dataset: summarizing, visualizing and sharing your data.

In the book, you’ll learn the skills you need to arrange your data using Excel. This is an important part of data science and data analysis. You will also learn the skills you need to summarize and visualize your data, which are important elements in data interpretation and data analytics. You’ll also learn the skills you need to share data effectively, important skills required to get your message across to others.

In our book, Managing Data Using Excel you’ll learn the essentials of data science. Readers will learn how to use Excel to:

• Build a dataset – how to handle variables and notes, rearrangements and edits to data.
• Check datasets – dealing with typographic errors, data validation and numerical errors.
• Make sense of data – including datasets for regression and correlation; summarizing data with averages and variability; and visualizing data with graphs, pivot charts and sparklines.
• Explore regression data – finding, highlighting and visualizing correlations.
• Explore time-related data – using pivot tables, sparklines and line plots.
• Explore association data – creating and visualizing contingency tables.
• Explore differences – pivot tables and data visualizations including box-whisker plots.
• Share data – methods for exporting and sharing your datasets, summaries and graphs.

Alongside the text, “Have a Go” exercises, Tips and Notes give readers practical experience and highlight important points. Helpful self-assessment exercises and summary tables can be found at the end of each chapter.

Managing Data Using Excel is more than a book about Excel statistical analysis, it gives you the skills you need to prepare your data for statistical analysis, interpretation and for sharing with the wider world.