All articles with 'Microsoft Excel Conditional Formatting' Tag

A panel chart (often called as trellis display or small-multiples) shows data for multiple variables in an easy to digest format. It lets users compare in any way and draw conclusions with ease.

Today, I want to discuss how the principles of panel chart can be applied to visualize a complex set of survey results. For this we will use the recent survey conducted by Gartner on how various customers use BI (Business Intelligence) tools.

In October 2008, I have started an ambitious series of posts on this blog called – Spreadcheats. These are little tricks, nuggets, tutorials on using Excel that would make anyone a spreadsheet guru.

The spreadcheats series has been wildly successful. I am compiling all this useful information and articles in to one big post so that anyone can follow the links and become good in Excel. Read on,

[Note: This is not for beginners. If you know what a formula is, you would enjoy this 31 articles]

Marko, who is a long time PHD reader and an excel ninja sent this via email, I work at an insurance company in Slovenia. At the beginning of each year we have a conversation with our superiors to review our work in the past year and to set new goals (main activities) that we’re gonna […]

In Excel Gantt Charts part of our project management series, we have discussed about how using Conditional Formatting and Formulas we can make a gantt chart like this: But when you have large project plans, gantt charts like above can get pretty intense and hard to read. So a better approach is to group various […]

Last week I have reviewed Google’s flu trends chart and told you that is it is very well made. Out of curiosity I made a similar chart in Excel. In this post, I am going to share the experience and results with you. Interested? Read on…

Most of you already know that using the REPT formula along with pipe (“|”) symbol, we can make simple in-cell charts in excel. For eg. =REPT(“|”,10) looks like a bar chart of width 10. Despite the simplicity, most people don’t use in-cell charts because these charts don’t look anything like their counterparts. But you can […]

This is second part of 2 part series on conditionally formatting dates in excel.

Highlighting Repeat Customers using Conditional FormattingIn yesterday’s post we have learned how to conditionally format dates using excel. In this article, you will learn how to use these conditional formatting tricks to highlight repeat customers in a list of sales records.

This is first part of 2 part series on conditionally formatting dates in excel.

Conditional formatting is a very useful feature in Excel. You can use Conditional formatting to tell excel how to format cells that meet certain conditions. For eg. You can use conditional formatting to show all negative values in a range in red color. Today we will learn how to use conditional formatting to format dates.

Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in November, I have asked you to visualize sales data using sample data. The visualization challenge #2, sponsored by Zoho Reports generated a huge buzz around the community and fetched 32 incredible entries. The response was so overwhelming that it took me almost 24 hours to write this post. Thanks everyone for participating and making this a huge learning experience for everyone. Personally I have learned several useful dashboard and charting tricks. I will be sharing some of these lessons with all of you in the coming weeks.

Here is a 2010 new year gift to all our readers – a free 2010 calendar excel file (a little secret: just change the year in “outline” sheet from 2010 to 2011, to get the next years calendar. It works all the way up to year 9999). You can even get a Printable PDF Calendar. There are 14 different sheets in the calendar file. First one is an outline calendar for the entire year. The next 12 are monthly calendars. And the last sheet shows a mini-calendar for the year 2010.

Read the rest of this post to know more and download the calendar.

Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor changes to it and sharing it with you all so that you can have great time shopping for the holidays.

The workbook is full of lessons on conditional formatting, cell formatting, using formulas. Go ahead and download it today.

While feeding the babies last night, I had this idea. Why not make an excel sheet where you can keep track of the baby’s feeding and sleeping activities on day to day basis. It would probably help you understand your baby’s needs better and may be give you some insights.

Project management dashboards, project status reports help stakeholders, project sponsors and team-members can understand project status very quickly. In the last installment of project management using excel, learn how to make project management dashboard using excel in this tutorial. Also download the excel project status dashboard template.

Here is tricky scenario, faced by Basil, our forum member, “I want to have Excel display a wing ding check mark when a user types “y” in a cell. I have been trying to do a substitute formula but putting the symbol in an unused portion of the spreadsheet and calling it to the selected cell but I can’t get it to work. Any thoughts?”

We can use either cell formatting or conditional formatting to achieve this.

Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working and where the effort is going. By using Microsoft Excel capabilities you can create a truly remarkable timesheet tracking tool.

In this installment of project management using excel series, we will learn 3 things about timesheets and resource management using Excel
1. How to setup a simple timesheet template in excel?
2. How to make a more robust timesheet tracker tool in Excel?
3. How to use the timesheet data to make a resource loading chart?