Excel tips

Aug

Excel is widely used in businesses all over the world and can be used for many diverse tasks due to the flexibility of the program. I’ve been doing a fair deal of Excel templates over the years to solve an array of very different tasks. I’ve also ...

Jun

Sometimes it comes in handy to be able to note a date or time quickly in Excel. This happens often when using Excel sheets for logging purposes and registration of laboratory experiments and results. This post illustrates how to make a drop-down with todays date where the entered date will not update automatically. Data validation for drop-down menus For this purpose the ...

Jan

Chaos in Excel, Deliberately!

Yes, I deliberately put Chaos in Excel! In form of a simulation of the logistic equation which shows non-linear behaviour for certain values of the feedback constant;-) The Excel workbook is available for download and make it possible to play around with the feedback constant and hopefully get a better understanding of non-linear behaviour a.k.a. Chaos. Have fun ;-) The Logistic ...