Dr. Mark Gardener


Managing Data Using Exce, Cover

Managing Data Using Excel

Writer's Bloc

On this page you can find out about my latest writing project. I'll post updates on progress, tables of contents and also some of the R scripts (and possibly Excel spreadsheets) I am developing in support of the new book. I'll try to keep the material reasonably up to date.

The Writer's Bloc homepage contains a table of contents and an index of the pages that contain custom R commands and R scripts.

Managing Data Using Excel:
Organizing, Summarizing and Visualizing Scientific Data

Available now from
Pelagic Publishing

Pelagic Publishing

Get £5 discount when you buy direct from the publisher. Enter voucher code MDUE20 in the shopping basket at Pelagic Publishing

Managing Data Using Excel

Organizing, Summarizing and Visualizing Scientific Data

This book is about how to get the most out of your data. Making sense of data is part of the job description of a scientist. The book is split into nine chapters, currently entitled like so:

  1. Arranging your data.
  2. Managing your data: building your dataset.
  3. Managing your data: checking your dataset.
  4. Making sense of your data.
  5. Exploring regression data.
  6. Exploring time-related data.
  7. Exploring association data.
  8. Exploring differences data.
  9. Sharing your data.

The main themes of the book are concerned with showing you how a systematic layout allows you to maximize the usefulness of your data. Having a "recording" layout allows you to use your Excel spreadsheet like a database. Once you have your data arranged appropriately you can manage your data most effectively; this means being able to:

  • Check for errors.
  • Add extra information.
  • Visualize your data using graphs and charts.
  • Summarize your data in meaningful ways.
  • Share your data, including summaries and charts.
  • Carry out further analyses (e.g. statistics).

If you don't have a "proper" system for arranging your data it can be hard to make sense of them and conducting statistical analysis often means time wasted re-arranging data into an appropriate format. Once you have a "system" for arranging your data you can focus on what matters, the data itself. Your data can be arranged and re-arranged simply and easily for the required task.

The book will include several data sets, as Excel spreadsheets. There will be end-of-chapter summaries and self assessment exercises (with answers in an appendix). Throughout the book I will incorporate "Have a Go" exercises so that you get hands-on experience of manipulating data and carrying out various useful tasks (e.g. error checking, making charts and pivot tables).


Providing training for:

  • Ecology
  • Data analysis
  • Statistics
  • R The statistical programming language
  • Data management
  • Data mining

Follow me...
Facebook Twitter Google+ Linkedin Amazon
Contact DataAnalytics Homepage