Excel Formulas

How to Audit Formulas Using Excel Auditing Tools – 7 Tools

The following showcases an overview of  Excel auditing tools. Download Practice Workbook Audit Formulas.xlsx The sample ...

Using a Nested Formula in Excel – 5 Examples

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

Name Manager in Excel (Basic and Applications)

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

Hide Excel Formulas (with Protecting Sheet & Without It)

This article covers the application of Format Cells dialog box and Review tab to hide Excel formulas. Also, we show the use of VBA code to do the ...

How to Show Formulas in Excel (4 Easy Ways)

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 Create Named Range in Excel: 4 Suitable Methods

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 Copy a Formula in Excel (Column, Rows, Copy as Formulas)

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

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

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 ...

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

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 ...

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

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 Protect Formulas in Excel (Easy Steps)

Dataset Overview Suppose you have a dataset containing sales data, and you’ve used formulas to calculate revenues. Now, let’s protect the cells with ...

How to Remove Formulas in Excel – 8 Easy Methods

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo