What do you think?
Rate this book
Managing Data Using Excel
Microsoft Excel is a powerful tool that can transform the way you use data. This book 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 maximize the usefulness of their data.
Readers will learn how to use Excel to:
Build a dataset (how to handle variables and notes, rearrangements and edits to data) and 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), time-related data (using pivot tables, sparklines and line plots) and association data (creating and visualizing contingency tables).
Explore differences (pivot tables and data visualizations including box-whisker plots) and 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, and helpful self-assessment exercises and summary tables can be found at the end of each chapter. Supplementary material can also be downloaded on the companion website.
Managing Data Using Excel is an essential book for all scientists and students who use data and are seeking to manage data more effectively. It is aimed at scientists at all levels but it is especially useful for university-level research, from undergraduates to postdoctoral researchers.
Readers will learn how to use Excel to:
Build a dataset (how to handle variables and notes, rearrangements and edits to data) and 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), time-related data (using pivot tables, sparklines and line plots) and association data (creating and visualizing contingency tables).
Explore differences (pivot tables and data visualizations including box-whisker plots) and 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, and helpful self-assessment exercises and summary tables can be found at the end of each chapter. Supplementary material can also be downloaded on the companion website.
Managing Data Using Excel is an essential book for all scientists and students who use data and are seeking to manage data more effectively. It is aimed at scientists at all levels but it is especially useful for university-level research, from undergraduates to postdoctoral researchers.
- GenresComputer Science
324 pages, Paperback
First published February 23, 2015
39 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
July 16, 2015
Managing Data Using Excel: Organizing, Summarizing and Visualizing Scientific Data joins others in the 'Research Skills' series and is a top recommendation for any who would use their Excel spreadsheet skills to organize and share scientific data, standing out from the crowd of more general 'how to use Excel' handbooks to address the specific needs of the scientific community.
There are basics here, from how to build a dataset handling variables and notes to summarizing data using averages, creating visual displays with graphs and pivot charts, and using these tables to fine-tune results and displays that export well into datasets and summaries scientists can share.
Exercises are provided to reinforce concepts, while tips and notes compliment the educational process by pointing out common Excel challenges. Plenty of tables and charts pepper the discussions while an index makes it easy to use this is a reference for at-a-glance information.
Plenty of general Excel handbooks document how to create datasets and apply calculations, but the specific focus on scientific data manipulation provided here makes it a top recommendation over any general tutorial.
There are basics here, from how to build a dataset handling variables and notes to summarizing data using averages, creating visual displays with graphs and pivot charts, and using these tables to fine-tune results and displays that export well into datasets and summaries scientists can share.
Exercises are provided to reinforce concepts, while tips and notes compliment the educational process by pointing out common Excel challenges. Plenty of tables and charts pepper the discussions while an index makes it easy to use this is a reference for at-a-glance information.
Plenty of general Excel handbooks document how to create datasets and apply calculations, but the specific focus on scientific data manipulation provided here makes it a top recommendation over any general tutorial.
Displaying 1 of 1 review