With features like auto-summing, chart making and the ability to track numbers from multiple lists, budgets or accounts, Microsoft Excel has become an essential business tool. You can use it to keep ...

Whether presenting a project at school, delivering a critical report at work, or simply trying to make sense of your budget, graphs are efficient and visually appealing means of conveying complex ...

The Change Chart Type utility in Microsoft Excel features several graphs from which you can select to convert your current Excel chart into a graph. Choosing a new graph type from the utility ...

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting ...

If you want to create a dashboard in Microsoft Excel, this post will help you. A dashboard is a type of graphical representation that depicts the key performance indicators for a particular topic or ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

Learn to chart multiple data sets on one graph in Excel with this concise two-minute tutorial. Explore how to utilize more ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.