Category: Excel®

How to Audit Formulas in Excel: The Formula Auditing Toolbar

The formula function in Excel is one of the most useful things any business owner or employee can use, especially when large volumes of data need to be evaluated. Sometimes you are given completed worksheets that you need to do extra analysis on. It is sometimes difficult to see where…
Read More

Creating a Radar Chart in Excel

Sometimes it is very useful to see the magnitude of many variables for several different independent variables in one chart. The easiest way to do this is to create a radar chart, also known as a spider chart or web chart in Excel. A radar chart in Excel is set…
Read More

How to Convert Text to Number in Excel: 2 Ways

Excel is the go-to program when you need to organize data, create formulas and share information with the team. That being said, working with data in numerous places and applications can make the data import not as seamless as one would hope. Let’s say you transferred data from an external source into Excel and…
Read More

Share Data with an Excel Chart Secondary Axis

Placing two data sets in an Excel chart is an effective way to quickly understand data and make important business decisions. However, when the values in your data sets widely vary, your chart may be difficult to comprehend. A great way to mitigate this problem and make your data clear…
Read More

Harnessing the Power of an Excel Macro to Delete Rows in a Spreadsheet

In our fast-paced, technology-driven world, it doesn't make sense to spend time clicking through rows and rows on a spreadsheet just to delete them. By using the power of Excel Macros, you can automate the process so that Excel will eliminate any and all flagged rows instantaneously. Let's take a…
Read More

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

Present Value of 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…
Read More

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

Calculating Time with Excel Formulas

How often have you looked at your watch and typed the current time into your worksheet? Or tried to convert from one time zone to another and produced an error? Or wondered why a time shows up looking like “0.9285”? Fortunately, these questions are easy to answer once you understand…
Read More

How to Use the Excel Match Function to Find Data

In Excel, some functions exist to be used to increase functionality when paired with other functions. MATCH is a good example. MATCH helps you search a range of references to find a “match” to your query. It then returns the position of that match. In short, you can use MATCH…
Read More
< >