All articles in 'Learn Excel' Category

KPI Dashboards – Highlight KPIs Based on Percentile [Part 3 or 6]

Published on Sep 3, 2008 in Charts and Graphs, Featured, Learn Excel
KPI Dashboards – Highlight KPIs Based on Percentile [Part 3 or 6]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. This 6 Part Tutorial on KPI 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 […]

Continue »

6 charts you will see in hell

Published on Sep 3, 2008 in Charts and Graphs, Featured, Learn Excel
6 charts you will see in hell

Often it is easy to get carried away with a tools features. Excel is no exception. But here is a list of grotesque charts that you should never make, not even on your last day at work. 1. Leave the radar charts for Spidermen why? You can hardly conclude anything by looking at them They […]

Continue »

Initials from Names using Excel Formulas

Published on Sep 2, 2008 in ideas, Learn Excel
Initials from Names using Excel Formulas

Often when you are processing customer records or doing mail merge, it might be useful to get initials from a given name, like JFK for John F Kennedy. You can do this using simple text formulas (left(), mid(), find()) combined with if(). Here is how: Assuming cell B3 has the full name, then this is […]

Continue »

Aligning charts, objects on spreadsheet [excel layout tip]

Published on Aug 28, 2008 in Learn Excel

Often when you are adding several charts to your report or project plan, it may be important to have them all aligned to a proper baseline – a fundamental design principle. Take a look at this: But if you try to select each chart individually and adjust the alignment, it may not provide correct results […]

Continue »

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort

Published on Aug 27, 2008 in Analytics, Charts and Graphs, Featured, Learn Excel

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. This 6 Part Tutorial on KPI 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 […]

Continue »

Excel links of the week – weekend without wire [Aug 26]

Published on Aug 26, 2008 in excel links, ideas, Learn Excel

Last Saturday our internet connection at home went off. I called the road runner folks hoping to getting it back up, but no luck. We were told to wait till Monday evening before the service personnel could restore the connectivity. Thankfully, we didnt feel all that bored and could spend lot of time talking to […]

Continue »

Date with my sheet – 10 tips on using date / time in excel

Published on Aug 26, 2008 in ideas, Learn Excel

Excel date time features are very handy and knowing them a little in depth can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the sheet using these 10 handy tips. Before jumping on to the tips, it helps to know how excel […]

Continue »

Quickly process text using split() spreadsheet function in google docs

Published on Aug 25, 2008 in Analytics, Learn Excel, technology

Google docs spreadsheet app is going mainstream with each passing day. Recently they have introduced split() formula to divide text in to multiple cells using a user specified delimiter. The syntax for this function is =split(text value, delimeter), for eg. =split(“pointy haired dilbert”, ” “) would result in 3 individual cells with “pointy”, “haired” and […]

Continue »

Display symbols in excel chart axis

Published on Aug 21, 2008 in Charts and Graphs, hacks, ideas, Learn Excel

Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text. Just follow these 4 simple steps: First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like […]

Continue »

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Published on Aug 20, 2008 in All Time Hits, Charts and Graphs, Featured, Learn Excel
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. This 6 Part Tutorial on KPI 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 the […]

Continue »

It is show time baby! – better designer clocks to display time in your spreadsheets

Published on Aug 19, 2008 in Charts and Graphs, ideas, Learn Excel

My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even though the idea of this blog is share the little that I know with you, it is amazing how much I have learned from you […]

Continue »

Excel Links of the week – What do you dream about? [Aug 19]

Published on Aug 19, 2008 in ideas, Learn Excel

The other day my wife told me that we dream about a total of 6 years in our life, an average of 2 hours for everyday you sleep. [Source: wikipedia on dreams]. That is almost as much time as you would work in 30 years (30*50*40/24/365, assuming you work 40 hours a week for 50 […]

Continue »

Polar clock using donut chart [Excel Visualization fun]

Published on Aug 18, 2008 in Charts and Graphs, Featured, ideas, Learn Excel
Polar clock using donut chart [Excel Visualization fun]

Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to display time, I knew this could be an interesting visualization to do in excel. So I have created a donut chart in excel that can […]

Continue »

Plot your data around the clock [Excel charting idea]

Published on Aug 14, 2008 in Charts and Graphs, ideas, Learn Excel

If your reports include hourly distribution of data like, Customer footfalls in your store Page views of your site Customer service calls to your toll free numbers here is an interesting charting idea to show the data around the clock (literally) Update: Visualization pros Jon Peltier and Jorge Camoes took a critical look at this, […]

Continue »

Simulating Dice throws – the correct way to do it in excel

Published on Aug 13, 2008 in Learn Excel, simulation

If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if […]

Continue »