All articles with 'microsoft' Tag

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.

Good news!!! We have upgraded the excel formula help page to a new, more easily accessible and better laid out page. Find out more…

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.

Learn how to use excel chart templates in this installment of spreadcheats. Save time.

If you have never commented on PHD this is your chance. Go ahead and comment and I will give you $1.00 discount on my Excel Formulas Help E-book.

The topic for the open thread is: What do you like in Microsoft Excel?

We are a big advocate of keyboard shortcuts. I think learning a handful of keyboard shortcuts can improve your productivity tremendously, whether you are using excel or firefox.

But using only keyboard shortcuts is like using only right hand. So, we have compiled 5 incredible ways mouse can help you be productive while using MS Excel.

In this weeks edition, learn how to compare multiple items in a range using match, know how you can add more than one legend to a chart, include images in comments.

Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”

This is very useful feature, especially when you are using PowerPoint.

Pie charts are one of the most used charts in the world. And for obvious reasons: they are simple to create and easy to understand. When it comes to pie chart, I have no clear opinion. Part of me says use them, the other says avoid them.

What is your opinion on Pie charts ?

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.

Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.

Reader Raja asks about “how he can reset the colors in his workbook”. Read more to find out how you can fix this problem.

As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel

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.