# All articles with 'free' Tag

## Excel Links of the Week – Free E-Book Edition

Published on Mar 9, 2009 in blogging, excel links

Find out how you can get a free e-book on excel and charting in this week’s excel links.

Continue »

## RSS Icon using Donut Charts – Because it is Weekend

Published on Mar 6, 2009 in Charts and Graphs, Learn Excel

RSS Icon using Donut Charts – Because it is Weekend

Continue »

## Excel Basics – What are Combination Charts and How to Make One?

Published on Jan 5, 2009 in Charts and Graphs, Learn Excel

A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.

Continue »

## 2009 Calendar Template in Excel – Now with week starting on Monday

Published on Dec 16, 2008 in Learn Excel

Stružák, one of the commenters on the 2009 Excel Calendar Template post asked me if I can rearrange the cells in the calendar so that the week could start on Monday. Since I didn’t have access to internet for a while, I have asked him to make the necessary changes and mail it to me […]

Continue »

## Brick Charts in Excel – an Alternative to Gridlines

Published on Dec 10, 2008 in Charts and Graphs, Learn Excel

Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up. Here is how you can get this type of chart (we will call it a brick chart) First we will make a regular bar chart Now, let […]

Continue »

## Free Excel Calendar Template for year 2009 (and all years up to 9999)

Published on Dec 4, 2008 in Featured, Learn Excel, personal

Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)

Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.

Continue »

Published on Nov 25, 2008 in Learn Excel

Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series, in this post we will discuss 2 advanced data validation techniques that can help you when you are modeling a complex worksheet.

Continue »

## Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

Published on Oct 29, 2008 in Analytics, Charts and Graphs, Learn Excel

This is a Guest Post by Robert on Visualization Techniques for Excel KPI Dashboards. 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 the […]

Continue »

## Sports Dashboards in Excel – A Tutorial

Published on Oct 20, 2008 in Charts and Graphs, Learn Excel

One of my favorite cricket player, the GOD – Sachin Tendulkar has become highest test run scorer. What do I get if Sachin becomes highest scorer, you may ask. In order to celebrate this occasion I have created a cool sports dashboard in excel with some of the top test cricket players’ statistics. And, you […]

Continue »

## More than 3 Conditional Formats in Excel

Published on Oct 14, 2008 in Charts and Graphs, Learn Excel

One of the most popular posts on this blog is how to become excel conditional formatting rock star. Quite a few commenters there asked me if there is a way to get more than 3 (or 4) conditional formats in excel 2003. Like what you see below: You can get more than three conditional formats […]

Continue »

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

Published on Oct 9, 2008 in Analytics, Charts and Graphs, Learn Excel

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

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 »

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

Published on Oct 3, 2008 in Learn Excel, simulation

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 »

## Simple Todo List application using Excel – Download and become productive

Published on Oct 1, 2008 in Learn Excel

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

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.