### Create an Excel Control Chart to Analyze Data

In this article, we’ll show you how to construct an Excel control chart to analyze data and improve efficiency. Control charts are useful for monitoring any process that has a level of variation – for example, filling containers with a certain number of items. They can easily illustrate whether your process is operating within its…

### Calculate Annuities: Annuity Formulas in Excel

For anyone working in finance or banking, the time value of money is one topic that you should be fluent in. Knowing exactly what it means to discount something or to get the future value of a particular investment vehicle is necessary to do the job. Excel can be an extremely useful tool for these…

### How to Link with Excel Hyperlink Formula

When using Excel, do you ever need to quickly access information stored elsewhere– the internet or your company’s intranet, for example? Taking the time to find these files outside of Excel can waste valuable time, especially if you get lost navigating away from your spreadsheet and forget the information’s context while you search. Fortunately, this…

### 3 Easy Formulas to Calculate the Range of Values in Excel

An essential skill any Excel user should know is how to determine the range of values in Excel. Most businesses don’t have time to waste sorting through rows and rows in Excel in order to find the highest and lowest values of revenue, sales, or other information. The difference between the highest and lowest figures…

### Excel Lookup Formula to Create Combined Tables

Lookup functions (VLOOKUP and HLOOKUP) are among the most useful Excel functions to pull data from multiple column-/row-sorted lists into a unified table. Think of it this way, these functions ask a simple question and return the answer. Question: is the data from a specific cell reference in this column or row? Check out our…

### Excel Formula Not Calculating?

As committed Excel users, we often go on and on about it as a productivity solution and essential program powerhouse. But catch us on a bad day and we are cursing that little green arrow and #VALUE! error like nobody’s business! Have you ever poured time into a worksheet, only to realize that the Excel…

### Creating a Pareto Chart in Excel

The Pareto Principle, named for Italian economist Vilfredo Pareto, suggests that 80% of problems can be traced to as few as 20% of root causes.  This can be valuable, even vital information when you are trying to figure out which of many problems to tackle first, or in a complicated troubleshooting environment. For example, you…

### Creating Excel Reports

Excel is a powerful reporting tool, providing options for both basic and advanced users. One of the easiest ways to create a report in Excel is by using the PivotTable feature, which allows you to sort, group, and summarize your data simply by dragging and dropping fields.

### Basic Formula Series: The Excel® Average Formula

Let’s say that you’ve been given a new set of projects to work on, and you’re being asked to calculate how long you think your team will need to complete various pieces of each project.  The best way to obtain those numbers is probably to look at other projects you’ve completed and calculate the average…

### Basic Formula Series: The Excel® Sum Formula

Excel® formulas have their own logic and syntax, much like math problems. Once you understand the syntax, you can save a great deal of time by building basic and complex formulas to do the majority of your work for you. Where in math problems you combine numbers with variables, in Excel formulas and functions you…