Excel Formulas Archives

How to Audit Formulas Using Excel Auditing Tools – 7 Tools

Aug 4, 2024

The following is an overview: Download Practice Workbook Audit Formulas.xlsx The sample dataset showcases Principal Amount, ...

How to Audit Formulas Using Excel Auditing Tools – 7 Tools

Using a Nested Formula in Excel – 5 Examples

Aug 11, 2024

Nested formulas contain one or more functions as parameters or arguments within another function. Download Practice Workbook Download ...

Using a Nested Formula in Excel – 5 Examples

Name Manager in Excel (Basic and Applications)

Jul 5, 2024

Download Practice Workbook Use of Name Manager.xlsx What Is Name Manager in Excel? Name Manager in Excel is used to create, ...

Name Manager in Excel (Basic and Applications)

Hide Excel Formulas (with Protecting Sheet & Without It)

Jul 16, 2024

This article will cover how to hide Excel formulas, either by using the Format Cells and Review features, or with a VBA macro. Since these methods ...

Hide Excel Formulas (with Protecting Sheet & Without It)

How to Show Formulas in Excel (4 Easy Ways)

Jun 14, 2024

Here is an overview of showing formulas in Excel. How to Show Formulas in Excel? There are a few ways you can show formulas in Excel. ...

How to Show Formulas in Excel (4 Easy Ways)

How to Create Named Range in Excel: 4 Suitable Methods

May 30, 2024

Method 1 - Create Named Range Using Name Box Create a name for the Annual Salary column using the Name Box. Select the cell range F6:F15 ...

How to Create Named Range in Excel: 4 Suitable Methods

How to Copy a Formula in Excel (Column, Rows, Copy as Formulas)

Aug 10, 2024

The following image shows a dataset containing products from different sellers. Each product has a discount. The formula to calculate the discounted ...

How to Copy a Formula in Excel (Column, Rows, Copy as Formulas)

Cell Reference in Excel (Absolute, Relative, and Mixed)

Jul 6, 2024

In this article, you will learn how to use absolute, relative, and mixed cell references. We'll use a sample dataset for Products and Sales, in ...

Cell Reference in Excel (Absolute, Relative, and Mixed)

Why Formula Is Not Working in Excel (15 Reasons & Solutions)

May 16, 2024

We'll use a dataset that contains student Names and their scores in Math and English. We will go through some of the most common fixes when formulas ...

Why Formula Is Not Working in Excel (15 Reasons & Solutions)

How to Convert Formulas to Values in Excel: 8 Quick Methods

May 24, 2024

Method 1 - Use Paste Special Command to Convert Formulas to Values Steps: Select cells (F5:F14). Press Ctrl+C to copy. Click Home ...

How to Convert Formulas to Values in Excel: 8 Quick Methods

How to Protect Formulas in Excel (Easy Steps)

Jul 21, 2024

Dataset Overview Suppose you have a dataset containing sales data, and you’ve used formulas to calculate revenues. Step 1 - Unlock All ...

How to Protect Formulas in Excel (Easy Steps)

How to Remove Formulas in Excel – 8 Easy Methods

Aug 3, 2024

A sample dataset is shown below. Download Practice Workbook Download and practise. Removing Formulas.xlsm How to Remove ...