How to Auto Fill in Excel 2013 with keyboard shortcuts

Since I was analysing an awful lot of data, this came really hand.

The auto fill option is very useful to drag across cells and fill them with a formula.

Just select the first number (the cell you would like to extend, here: =AVERAGE(B1:B3)) and use CTRL+SHIFT to expand the selection onto the cells you would like to fill.
Like this:

Then you press CTRL+R and it looks like this:

Now excel calculates the average for each column.
However, it is different for other directions of selections, you have to press CTRL+D(own) to fill downwards or CTRL+L(eft) or CTRL+U(up).

See here where I found this neat trick:

http://superuser.com/a/270028
http://superuser.com/a/270160

Excel 2013 - How to make a Step Chart

Unfortunately Excel does not provide Step charts. So the transition between data points in descending or ascending or it is smoothed and not sharp dropping.

If something you want to do should look like this:

Then have a look at the link below how you can trick Excel into doing it:

http://www.exceldashboardtemplates.com/how-to-easily-create-a-step-chart-in-excel/ 

It worked fine for me!

Gantt Chart Software for free!

This software is free and I use it for my work. It is not the most flexible and good looking one, but it is free, useful and easy to use:

http://www.ganttproject.biz/

And here is a video, so you can see what's possible:

Happy gantting.

Box-and-Whisker Charts for Excel - For Dummies

I need to do a lot of these for my studies. It is the most easy way I could find to create Box plots in Excel!

Box-and-Whisker Charts for Excel - For Dummies