Archive for April, 2009

Analyzing Search Keywords using Excel : Array Formulas in Real Life

Published on Apr 29, 2009 in Charts and Graphs, Learn Excel
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.

Continue »

Calculate Moving Average

Published on Apr 28, 2009 in Learn Excel
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.

Continue »

Excel Links of the Week – What is really happening Edition

Published on Apr 27, 2009 in excel links

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.

Continue »

Hide a Workbook from Nosy Colleagues [quick tip]

Published on Apr 22, 2009 in Excel Howtos, Learn Excel
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.

Continue »

and the Winner is…

Published on Apr 21, 2009 in Charts and Graphs, Learn Excel

The winner for our first visualization contest is decided. Curious? Read on…

Continue »

Excel Formula Errors – Understand and Debug Them

Published on Apr 20, 2009 in All Time Hits, Excel Howtos, Featured, Learn Excel
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.

Continue »

There is an Easter Egg in this Post

Published on Apr 8, 2009 in blogging, Learn Excel

Go ahead and find it..,

Continue »

Using Credit Card Numbers in Excel

Published on Apr 7, 2009 in Excel Howtos, Learn Excel
Using Credit Card Numbers in Excel

Do you know that it is not so straight forward to use credit card numbers in excel. Yes, excel uses a precision of 15 digits and thus when you enter a credit card number (16 digits) it is converted in to scientific format and the details are lost. Read on to learn the work around.

Continue »

Budget vs. Actual Charts – 14 Charting Ideas You can Use

Published on Apr 5, 2009 in All Time Hits, Charts and Graphs, Featured

Do you want to make a budget vs. actual performance chart but not sure what option to use? Check out these 14 excel charting alternatives and find the one that tells your story.

Continue »