Posts Tagged ‘excel 2007 tips’

Reason out the Hike or the downfall of the trend in a better manner: Another Dashboard Tip

Saturday, March 14, 2009 11:24 No Comments

- Contributed by Gunjan Aggarwal
In earlier blogs, we learn how to create interactive charts with the help of checkboxes. Those who have missed that blog post can read the article on using check boxes for a neat treat .
It’s very much necessary for a web analyst [...]

This was posted under category: Dashboard Design Tips Tags: , , , , , , ,

Count that word in the cell

Friday, February 27, 2009 11:45 No Comments

- Contributed by Deep Moni Hazarika
Counting the length of a string or characters is easily done in excel. Just the LEN() function and simple. But the one day I was asked if there was any way to count a particular word in a cell which had a long sentence. That sounded tricky but needed some [...]

This was posted under category: Excel Tips Tags: , ,

Excel Tip 2: Excel 2003 to Excel 2007 - A radical uplift

Wednesday, November 26, 2008 2:03 4 Comments

- contributed by Deep Moni Hazarika
Most of us had well adapted ourselves to the excel 2003 interface and were able to find the required menu options and controls when needed. And when most of us got pretty comfortable with Excel 2003, Microsoft introduced us to the newer baby of spreadsheets - Excel 2007. Fantastic. Learning [...]

This was posted under category: Excel Tips Tags: , ,