All articles in 'Learn Excel' Category

KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

Published on Oct 9, 2008 in Analytics, Charts and Graphs, Learn Excel
KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

This is a Guest Post by Robert on Visualization Techniques for KPI Dashboards using Excel. This 6 Part Tutorial on Management Dashboards Teaches YOU: Creating a Scrollable List View in Dashboard Add Ability to Sort on Any KPI to the Dashboard Highlight KPIs Based on Percentile Add Microcharts to KPI Dashboards Compare 2 KPIs in […]

Continue »

Replace Radar Charts with Tables to Make Comparison Easy

Published on Oct 7, 2008 in Charts and Graphs, hacks, ideas, Learn Excel
Replace Radar Charts with Tables to Make Comparison Easy

In Petal Charts – an Alternative to Radar Charts I have suggested using a radar chart tweak to replace the radar charts. Both PTSBlog and Information Ocean have posted their critical reviews of these petal charts. So as a penance for proposing petals, I am going to provide a tutorial on creating a comparison table […]

Continue »

Excel Links of the Week [Oct 06]

Published on Oct 6, 2008 in excel links

What a Monday it is. Most of the us woke up to find that whatever we have been accumulating for the last few years in investment gains has been wiped out (BSE Sensex at 2 year low, Dow slips below 10000). Not a very pleasant way to start the week, but then may be this […]

Continue »

Major Updates to Google Docs Spreadsheets App – Menus, Named Ranges, Toolbar

Published on Oct 6, 2008 in Learn Excel, technology

Google Docs – spreadsheet application has introduced some major upgrades to their editor today. Some of the key changes include: Introduction of menus to access all spreadsheet functions / features by category: Now the spreadsheet app menus look more like Excel 2003 menus. Looks like Google is trying hard to close gap between the two […]

Continue »

Deal or No Deal – Download and Play the Popular TV Game Show in Excel

Published on Oct 3, 2008 in Learn Excel, simulation
Deal or No Deal – Download and Play the Popular TV Game Show in Excel

Ever since we moved to Seattle we have been watching TV game show – Deal or No Deal (for lack of better things to do in the hotel) The game provides an interesting look at human nature and risk taking abilities. People who wouldn’t risk their retirement savings or jobs would go to these game […]

Continue »

Display decimals only when the number is less than 1 [Excel number formatting tip]

Published on Oct 2, 2008 in Learn Excel
Display decimals only when the number is less than 1 [Excel number formatting tip]

Here is a quick excel number formatting tip. If you ever want to format numbers in such a way that it shows decimal values only if the number is less than 1 you can use conditional custom cell formatting (do not confuse with conditional formatting). Here is an example: In such cases you can use […]

Continue »

The Best of Pointy Haired Dilbert : September 2008

Published on Oct 2, 2008 in blogging, Learn Excel

September has been by far the best month since I started this blog with 103k page views, 34 posts and 246 comments (great discussions everybody ). The RSS Subscribers have crossed the 1000 milestone last month and are steadily growing each day. With so many posts and great discussions every month it may be difficult […]

Continue »

Simple Todo List application using Excel – Download and become productive

Published on Oct 1, 2008 in Learn Excel
Simple Todo List application using Excel – Download and become productive

After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel. Since most of us use Excel on day to day basis, why not use it as a productivity application as well by keeping track of all the things we must do (TO DO List). When […]

Continue »

Clean up Incorrectly Formatted Phone Numbers using Excel

Published on Sep 30, 2008 in ideas, Learn Excel
Clean up Incorrectly Formatted Phone Numbers using Excel

In our Utopian imaginations all the data would have been standardized and shareable across systems and people. But alas, the reality is totally different. We seldom get data in the format / way we desire it to be. In other words, the ingredients are all there, but for us to prepare the dinner, you must […]

Continue »

Excel Links of the Week [Sep 29]

Published on Sep 29, 2008 in excel links
Excel Links of the Week [Sep 29]

Time for sharing another round of excel related articles around the web. List of all data visualization and analysis excel add-ins, The list includes some of the really useful add-ins. Handy bookmark if you work with data visualization alot and need to know where to find good stuff to add to your excel capabilities. Designing […]

Continue »

Handling spelling mistakes while searching your data using excel

Published on Sep 25, 2008 in Analytics, ideas, Learn Excel
Handling spelling mistakes while searching your data using excel

Spelling mistakes are a thing of day to day carporate life. Most of the data in spreadsheets is entered by people and hence prone to having spelling mistakes or alternate spellings. For eg. a person named John could have been spelled as Jon. And when John calls you back to confirm his reservation and you […]

Continue »

Sorting a list of items in random order in excel – using formulas

Published on Sep 23, 2008 in Analytics, Learn Excel
Sorting a list of items in random order in excel – using formulas

In shuffling a list of items in excel I have described the technique of using random numbers generated by RAND() to sort a list of items. The technique had one disadvantage though, every time you need to reshuffle the list you have to press F9 to recalculate the rand() and then go to menu > […]

Continue »

SQL Queries from Excel

Published on Sep 22, 2008 in Learn Excel, technology
SQL Queries from Excel

Often when you are working on 2 incompatible systems and try to import data from one to another, excel can be a handy tool. I have used excel plenty of times to generate SQL insert / update statements which I could later execute on the database console. Here is a tutorial if you ever have […]

Continue »

Weekly Excel Links – Moved to Seattle Edition

Published on Sep 22, 2008 in Charts and Graphs, excel links, Learn Excel

As mentioned earlier we have moved to Seattle this Sunday. It seems like a great place already. Just that everything is more expensive than we are used to in Columbus. But I guess that is the premium we have to pay for being in a big city. On to this week’s edition of excellent excel […]

Continue »

You are NOT spider man, so why do you use radar charts?

Published on Sep 18, 2008 in Charts and Graphs, ideas, Learn Excel
You are NOT spider man, so why do you use radar charts?

There are few charts in excel that are as revolting as a radar chart. The purpose of a radar chart is to compare m options across n parameters so that audience can be convinced that option A is better than say option B. But, I am yet to come across a radar chart that tells […]

Continue »