Category: Excel®

Unleashing the Flexibility of Excel Text Formulas

Data collection is an important part of business. It is customer satisfaction survey results, employee performance assessments, market and industry research, lead generation analysis, or anything that depends on collecting, comparing and seeking relevant information. Unfortunately, depending on the setup and your tools, raw data can be confusing and impossible…
Read More

Calculate Range in Excel: 3 Easy Formulas

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…
Read More

Compound Annual Growth Rate: Comparing Investments with the Excel CAGR Formula

Does your company offer several types of IRA accounts? Are you unsure of your current IRA strategy? How do you know if the choices you make for your future are the best available to you? Say you review your IRA returns and consider changing your mix of investments. Five years…
Read More

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…
Read More

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…
Read More

How to Make 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…
Read More

No Excel Multiplication Formula? 3 Ways to Multiply in Excel

While there is no “Excel multiply formula” there are multiple ways to multiply in Excel. For instance, do you use an asterisk (*) to multiply, but hit a brick wall when you apply other arithmetic operators? What about shortcuts for multiplying many numbers in one step? Read on for three…
Read More

How to Hide Formulas in Excel and Protect Your Spreadsheet

Excel makes it easy to decipher why a formula produces its result. When you click on the cell, the formula is displayed in the formula bar. If that’s not enough, you can select the Formulas ribbon and click Evaluate Formulas for a step-by-step walkthrough. But what happens when you don’t…
Read More

Visually Display Composite Data — How to Create an Excel Waterfall Chart

Have you ever needed to present a chart that displays component data that roll up to a total? If all of the values are positive, Excel’s stacked column chart works beautifully; but it breaks down when your data includes both positive and negative values. The answer is an Excel waterfall…
Read More

Ease the Pain of Data Entry with an Excel Forms Template

Excel makes it easy to work with data tables, but first you must get that data into tables. Keying data into a spreadsheet and moving the cursor after each entry can be frustrating at best; at worst, it can leave you with mangled data in an unusable format. Fortunately, Excel…
Read More
< >