Analyzing Search Keywords using Excel : Array Formulas in Real Life
Jarad asks me in an email “how word frequency can be generated from a range of cells using excel formulas?” This got me thinking and lead to this post, where we learn how to calculate word frequency using array formulas and use it to analyze a bunch of search keywords.
Calculate Moving Average
As part of our spreadcheats, today we will learn how to calculate moving average using excel formulas. As a bonus, you will also learn how to calculate moving average of latest 3 months alone using the count, average and offset formulas. Once you finish the tutorial, you have some home work to do as well. So go ahead and learn how to calculate moving averages.
Excel Links of the Week – What is really happening Edition
In this week’s excel links learn how to lookup in 2 columns, a cool charting hack using which you can depict uncertainty in predictions, an excel template that can be used to visualize social networks and much more.
Hide a Workbook from Nosy Colleagues [quick tip]
Do you have a nosy colleague who would like to see what you are up to? Then use the hide workbook feature in the ribbon.
and the Winner is…
The winner for our first visualization contest is decided. Curious? Read on…
Excel Formula Errors – Understand and Debug Them
In this installment of spreadcheats we will learn how to understand excel formula errors and fix them. The #DIV/0!, #NAME?, #N/A, #NULL!, #NUM!, #REF!, #VALUE! errors and how to fix them.
There is an Easter Egg in this Post
Go ahead and find it..,