Introduction to MS Excel 2016


excel_icon_thumb800Microsoft Excel (MS Excel) is one of the most popular spreadsheet applications and has become for many the “default” software to handle data, numbers, and graphs. Other spreadsheet applications such as Calc (Open Office/Libre Office) are certainly as good as (or even better than) MS Excel. bioST@TS provides here a series of tutorials for MS Excel 2016 since it is available to all employees and free for students (via Office365) at the University of Bergen.


excel16-1

Never used MS Excel before? Maybe once, and most probably by mistake…?

Calm down and start with these simple steps. You will learn how to open a worksheet, type in your data, sort them, make simple calculations, etc.

 


excel16-2

This chapter will show you how to quickly analyse a simple dataset and define basic values like average, variance, standard deviation, standard error of the mean, and so on. We’ll also see how to draw a histogram and a boxplot to better represent these datasets.

 


excel16-3

Creating a graph or a figure in MS Excel isn’t very complicated… as long as you have an idea of how the result should look like. Do you want to create a histogram? a bar graph? a pie chart? a scatter plot? Will you have one or several datasets to show in this graph? Will you need a secondary Y-axis? error bars? labels? Let’s see that step-by-step.


excel16-4

Sooner or later, you will have to write a report, exam, thesis, article or summary which contains graphs, charts and/or tables. Exporting such objects from MS Excel to MS Word (or MS Powerpoint) may be done in a couple of clicks, but this could be a bit risky if you do not understand what is imported.

Here you will find a couple of recipes to import/export your data and understand what copy-pasting technically implies.