Archive for the 'Excel' Category

Excel: Logest and Linest (and similar)

February 9th, 2012

A useful post I found about Logest. The handiest tip I found is to use the “Index” function when using LOGEST, which makes it not necessary to enter it as an array formula.

As you can see, been using Excel more frequently now. Makes it easier somewhat, since everyone in the office is on Windows/Microsoft.

Excel: Clustered Stacked Column Chart

February 1st, 2012

Being a “beginner” in Excel again. I’ve had to google a lot for help in creating charts. Here is a useful link I found when I needed to create a column chart that consisted of stacks clustered together:

(Link)

Go nuts! (If this link ever dies, contact us here and I’ll attempt to recreate the instructions written there.)