Excel Tutorials

Microsoft Excel 2016

Microsoft Excel (or simply Excel) is one of the most popular spreadsheet applications. It 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) 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.
 
Learn how to use Excel to manage your data, create tables, arrange and analyze datasets, apply formulas to thousands of data points in a couple of clicks, create meaningful graphs and much more.
Available languages: ENGLISH, NORSK

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.

excel16-5

Working with large datasets can be quite challenging on its own, but working with large datasets that contain mistakes can ruin your mental health very fast.

Here you will find a couple of tips on how to spot common mistakes in a few clicks.

excel16-6

Learn to create and use pivot tables to rapidly extract key statistics from a large data set.