Where did my money go ?

Flowing data had this posted a few months back showing various infographics which chart out the financial crisis and the events related to it. There even an interesting clip that you can watch. Interestingly the article also carries the impressive NY Times graphic on how ...

Continue Reading

Where did my money go ?

Beard Stories

Posted on 07 June 2009

Beard Stories
Beards are not a topic that you'd think someone would typically write about leave aside holding yearly competitions for. Dyers.org is Jon Dyer's site where he talk about life, leisure, movies and his experiments with beards. Sometimes its stuff like this that makes you realize that life is so much more fun when you're off the beaten path. Here is a nice chart of various beard styles on his site that caught my fancy. ...
Continue Reading

Comments (1)

The Weekend Strip

Posted on 07 June 2009

The Weekend Strip
Time for a break from the usual Excel stuff......a couple of chosen Dilbert's.....
Continue Reading

Comments     

Retirement Planner in Excel

Posted on 04 June 2009

Retirement Planner in Excel
Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the retirement planner in excel here. All of us worry about the impeding retirement. How ...
Continue Reading

Comments     

Make Charts in Excel Using Symbols

Posted on 21 May 2009

Make Charts in Excel Using Symbols
You can use Excel to make charts using symbols and display unconventional characters. Here's a list of symbols that can be used for making charts in excel. You can generate these symbols in Excel by formatting normal alpha-numeric characters with in-built or custom fonts (Windings, MS Outlook etc.) Few quick tips: To make a bar graph Use the REPT(char) function in Excel to repeat a character. Choose from the list of symbols ...
Continue Reading

Comments (1)

Bonavista Systems Excel Dashboard Competition 2009

Posted on 14 May 2009

Bonavista Systems Excel Dashboard Competition 2009
Bonavista systems, the makers of Microcharts, have invited entries for this years Excel Dashboard Competition. All you have to do is to present a dashboard which uses nothing more than Excel 2000 (or higher) and no other software other than Bonavista's Chart tamer and micro charts. The dashboards are going to be judged on 'the clarity and effectiveness of their design'. Entries can use any combination of tables, Excel charts, ...
Continue Reading

Comments     

SQL Statement Basics – Learn how to write SQL Statement

Posted on 13 May 2009

SQL Statement Basics - Learn how to write SQL Statement
An SQL Statement is a statement written in SQL. Every SQL statement could be classified as either a Data Access Control Statement, Data Definition Statement, Data Manipulation and Retrieval Statement or a Data Transaction Control Statement. You can download a complete set of SQL statements (SQL Satement & Basics.pdf) here. This handbook describes most of the frequently used SQL statements and contains numerous examples of how to use those statements. ...
Continue Reading

Comments (2)

Six Sigma Table

Posted on 12 May 2009

Six Sigma Table
A Six sigma table is a table that depicts the (six) sigma value corresponding to various accuracy levels. The six sigma table can be downloaded here. By looking down the tabulated values of the accuracy levels, you can find the (six) sigma level that corresponds to your accuracy level. The sigma table has five columns – the yield or the accuracy level ( 1 – the defect rate), the ...
Continue Reading

Comments (2)

Sudoku Solver Code in Excel with Brute Force – Solver Code, Logic and Program

Posted on 11 May 2009

Sudoku Solver Code in Excel with Brute Force - Solver Code, Logic and Program
This Sudoku solver in Excel will help you solve a sudoku puzzle with brute force. This Sudoku solver, has been written in VBA and incorporates a brute force algorithm which helps its solve some of the toughest sudoku puzzles using nothing more than an excel spreadsheet. You can download the Sudoku Solver in Excel with Code, Logic and Algorithm here. In this article we will talk about how to develop a Sudoku solver using code in Excel, discover the tips ...
Continue Reading

Comments (4)

Six Sigma Calculator in Excel

Posted on 11 May 2009

Six Sigma Calculator in Excel
How do you make a six sigma calculator in Excel? Well it's all really quite simple in excel....the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 - defect/opportunities). You can download a copy of the six sigma calculator in excel here. Before ...
Continue Reading

Comments (5)

House of Quality Template in Excel

Posted on 10 May 2009

House of Quality Template in Excel
You can download the house of quality template in excel here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...
Continue Reading

Comments (6)

Stress Test Results – A Classic Visualization Challange

Posted on 08 May 2009

Stress Test Results - A Classic Visualization Challange
The results of the "Stress Test - Housing Crisis of Shame" are out. I just saw NY Times publish the stress test figures this morning. The first thing that came to my mind when I saw the results was, well.......not that they require another $75 billion, that's pretty well known to most of us by now, was ....gosh.....what an opportunity wasted. Here was a important and relevant piece of data that could have really been presented better using ...
Continue Reading

Comments (1)

How to create a Gantt Chart in Excel

Posted on 07 May 2009

How to create a Gantt Chart in Excel
This article shows how to make Gantt charts in excel. Though Excel remains the preferred choice for creating simple Gantt charts, there are other commercial tools available for developing more complex versions of the Gantt chart. GANTT Charts are an important project management tool. In this article, I will describe how to create gantt chart in excel with a marker for show today's date. Using a stacked chart in excel, we ...
Continue Reading

Comments (8)

How to Create a Pareto Chart in Excel

Posted on 05 May 2009

How to Create a Pareto Chart in Excel
Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...
Continue Reading

Comments (11)

How to create an Excel Flow Chart – (Template and Software)

Posted on 04 May 2009

How to create an Excel Flow Chart - (Template and Software)
This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...
Continue Reading

Comments (4)

Excel to PDF Converters – List of Free Downloads

Posted on 18 April 2009

Excel to PDF Converters - List of Free Downloads
Ever wondered how do you convert your excel spreadsheets in to the PDF format? Here are a few tools (mostly free though some are free only during the trail period) that can help you convert from excel to the PDF format (.xls to .pdf). ExpressPDF ExpressPDF is a website based online excel to pdf conversion tool. You will need to submit the document to be converted on the website and ...
Continue Reading

Comments     

Mumbai Mahabaleshwar Road Trip and Directions

Posted on 16 April 2009

Mumbai Mahabaleshwar Road Trip and Directions
How do you reach Mahabaleshwar from Mumbai Well there are two ways to reach Mahabaleshwar from Mumbai Route 1: Bombay-Panvel -Lonavla-Pune-Shirwal-Khambatki Ghat -Wai-Panchgani-Mahabaleshwar (Total distance around 305 kms, driving time with break 7 hours) Route 2: Bombay-Kalamboli-Panvel-Pen-Mahad-Pholadpur-Mahabaleshwar (Total distance around 237 kms) The first one is preferable. That way you cover a major part of the route going along the Mumbai-Pune Expressway and the remaining through reasonably good Pune-Satara bypass. That way you are ...
Continue Reading

Comments (2)

Excel DATE Function – How to use Excel DATE Function

Posted on 06 April 2009

Excel DATE Function - How to use Excel DATE Function
Syntax of Excel DATE Function Example of Excel DATE Function Possible Errors returned by the DATE Function The Excel Date function returns the number representing the date for a given day, month and year. In Excel DATE function is typically used to construct a date by providing the constituting parts such as day, month and year. The minimum and maximum values that a date can take in Office 2003 is January 1, 1900 and December 31, 9999. Excel DATE ...
Continue Reading

Comments (2)

Top 10 Tips to Increase Blog Views and Traffic

Posted on 04 April 2009

Top 10 Tips to Increase Blog Views and Traffic
If you have been wondering how to increase blog views for your blog, the following tips can come in handy. Mind you, the two most important factors to increase your blog views are - great content and large number of good quality links from other blogs to yours. If you can achieve both of these, rest should be easy to manage. Increase blog views by writing good content on your blog As ...
Continue Reading

Comments (1)

Delete Old Calendar Entries and Meeting Requests from Outlook

Posted on 28 March 2009

Delete Old Calendar Entries and Meeting Requests from Outlook
All too often we let old calender entries and meeting requests accumulate in outlook resulting in the calender folder gradually bloating out of shape (and receiving the dreaded "your mailbox is over its size limit" message from the server) How do you solve the problem of deleting older calendar entries and meeting requests in outlook - well here's how: Go to your outlook ...
Continue Reading

Comments (3)

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