6 Easy Steps to Making an Interactive Map Chart in Excel

Creating interactive map charts in excel is one of the easiest things to do.....that is if you know how. I recently created this map chart showing the top 50 tropical storms to hit the Unitef States since 1900. As you move ahead in time from 1900 to 2005, the map shows the states that were hit by the storm, the damage caused, storm category and rank. ...

Continue Reading

6 Easy Steps to Making an Interactive Map Chart in Excel

Speed Gauges – An absolute No No

Posted on 11 September 2008

Speed Gauges - An absolute No No
.....because they take up a lot of space to show just one data element. However, if you still want to go ahead, you may want to take a look at this. (Inspired by the speed gauge depicted on BusinessObjects, now a SAP company). You can download the file here.
Continue Reading

Comments (2)

Tracking mouse movements in Excel

Posted on 11 September 2008

Tracking mouse movements in Excel
I wrote this small program that tracks the movement of the mouse in excel. The program uses an image to return the mouse X,Y coordinates. The shape that follows the mouse changes its attributes as it passes through various points in space. You can download the file here.
Continue Reading

Comments     

How to make Visio like flowcharts in excel

Posted on 06 September 2008

How to make Visio like flowcharts in excel
I sometimes use connectors and autoshapes in excel to make flowcharts for my projects. A little refined touch and you can have them looking nealy like the ones made in Visio. I say *nearly* because although everything moves, reshapes and resizes properly, the connectors still bend at 90 degrees unlike the ones in Visio which curve smoothly.....but nonetheless a small price to pay especially if you don't have ready access ...
Continue Reading

Comments     

5 easy ways to make data validation work for you

Posted on 06 September 2008

5 easy ways to make data validation work for you
One of the easiest ways to add interactivity to your spreadsheets and dashboard is to use the data validation feature in excel. Data validation allows you specify a list of options that you want a cell to display as a drop-down. You may want to download the sample sheet here before we begin. To being creating a dropdown for a particular cell, select the cell and click Data -> Validation. In ...
Continue Reading

Comments (2)

DNA Strand simulation using Excel

Posted on 01 September 2008

DNA Strand simulation using Excel
Excel can be used to create neat little simulations for classroom traings. I remember a long time back, I had a tough time trying to understand how the strands of a DNA coil around each other. Well....I tired my hands at creating a rotating DNA strand using 3-D bubble charts.....stright 'n simple for the most part......the trick lies in making the base and linking pairs change their overlaps after rotating every ...
Continue Reading

Comments     

Excel Chart Types – Basic

Posted on 31 August 2008

Excel Chart Types - Basic
These are some basic chart types in Excel. You can play around with these by downloading the file here. Stephen Few, Data visualization Guru and author, mentions a few rules for creating charts on his website PerceptualEdge. Some good reads are: Practical rules for using colors in charts Godin’s Silly Rules for Great Graphs Stephan has, over the years, written on many facets of presenting data ...
Continue Reading

Comments     

Tell me the time !! A TAG Heuer watch.

Posted on 23 August 2008

Tell me the time !! A TAG Heuer watch.
[caption id="attachment_130" align="alignnone" width="300" caption=""][/caption] Just playing around and having fun. Pretty simple code but one that realy works. You can have a look at the file here. Image courtesy www.dialaphone.co.uk
Continue Reading

Comments     

Sudoku solver in Excel VBA

Posted on 23 August 2008

Sudoku solver in Excel VBA
Update: You can download the Sudoku Solver in Excel with brute force here (latest version) here. For the uninitiated, Sudoku is a grid of 9x9 cells where each cell can and must have a value from 1 to 9 such that no number must be repeated in a row, column or any of the 9 groups of 3x3 grids. And not onto the circumstances behind this sudden urge to develop a sudoku solver. ...
Continue Reading

Comments     

Excel Dashboard : Data Modelling

Posted on 23 August 2008

Excel Dashboard : Data Modelling
If you have followed this till now (silly me, if you’re reading this, you likely might’ve :-)), you’ve completed the first of the three important phases in the development of your dashboard. You may want to use these formulas to get your data up to scratch for the next important step – Data Modeling and the generation of pivot tables. Generating a Pivot Table Once your data has been properly scrubbed, cleaned for errors and filled up, its time to us ...
Continue Reading

Comments (1)

60 Useful Excel Formulas That Are Good To Know

Posted on 23 August 2008

60 useful excel formulas that are a good to know DATE = Returns the serial number of a particular date DATEVALUE = Converts a date in the form of text to a serial number DAY = Converts a serial number to a day of the month EOMONTH = Returns the serial number of the last day of the month before or after a specified number of months MONTH = Converts a serial number to a month NOW = ...
Continue Reading

Comments (1)

20 Useful Excel Formulas You Must Know

Posted on 23 August 2008

20 Excel formulas you should know DATEVALUE = Converts a date in the form of text to a serial number DAY = Converts a serial number to a day of the month MONTH = Converts a serial number to a month YEAR = Converts a serial number to a year LEFT = Returns the leftmost characters from a text value LEN = Returns the number of characters in a text string RIGHT = Returns the rightmost characters from ...
Continue Reading

Comments (1)

Excel Dashboard : Data Organization

Posted on 23 August 2008

Excel Dashboard : Data Organization
Having our first view of the data More often that not, dashboards get prepared with a large amount of data. Even if that’s not the case, it always makes send to have your data nicely laid out. That way, whenever you have to go back and check the accuracy of the data, it becomes so much easier. Let’s work with an example. Suppose we've just been provided with one year’s worth of sales and target numbers for the regional and ...
Continue Reading

Comments (1)

Prepare Dashboard Using Excel : Shortcuts in Excel

Posted on 22 August 2008

Also useful would be to arm yourself with some shortcuts, they can be a ton of help when working with large amounts of data. The idea is to just work with the keyboard without having to use the mouse....things work much faster that way. Basic (and necessary) Cut Ctrl + x Copy = Ctrl + c Paste = Ctrl + v Minimize all = WinKey + m Move to first row = Home Move to last row = End Ctrl + ...
Continue Reading

Comments     

Prepare Dashboard Using Excel : Basics

Posted on 22 August 2008

Prepare Dashboard Using Excel : Basics
I'll be using excel 2002 and 2003 for most of this so many of the things that work on these versions may not work on some of the earlier ones. There are certin excel "add-ins" that allow excel to do more things when they are turned-on when they are turned-off ! (Isn't that the case with everythign else though in life :-)) Please be sure to click on Tools -> Add-Ins... and in the add-ins box that appears, check/turn-on "Analysis ToolPak". ...
Continue Reading

Comments     

Series: Prepare Dashboard Using Excel

Posted on 22 August 2008

"A dasboard is a collection of data and/or graphic elements that allow the reader to make better sense of what's taking place." That's my definition and I'm sticking to it!!! Often times authors will make this definition more complex. A dashboard no matter how complicated or sophisticated, is in the end, just a compilation of data and possibly, graphics. What they do......well they allow the reader "to make more sense of what's taking place". Special emphasis on "more sense". A dashboard will ...
Continue Reading

Comments     

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES