All articles with 'downloads' Tag

Here is a fun, simple and different alternative to traditional dashboards. Introducing…. tweetboards.

In excel conditional formatting basics article, we have learned the basics of excel conditional formatting. In this article we will learn how to highlight top 5 or 10 values in a list using excel as shown aside. We will use LARGE excel formula and conditional formatting to do this.

Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.

Today we will learn a little trick to compare 1 value with a set of values, For eg. our sales vs. competitor sales. We will learn how to create a chart like this.

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

RSS Icon using Donut Charts – Because it is Weekend

Japanese Candlestick Chart or Candlestick Chart as they are popularly known are one of the most commonly used stock charts.Today we will learn how to make a candlestick chart in Microsoft Excel in 4 simple steps.

Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So here comes market segmentation charts or marimekko charts using, conditional formatting.

This week, check out the updated excel downloads page and 5 interesting excel articles from around the web. Read more to learn about a mouse trick to paste values, how you can tweet from excel using user forms, an intuitive charting principle and more.

Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare time.

Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms

Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.

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.

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 […]

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 […]