Excel Formulas

### How to Audit Formulas Using Excel Auditing Tools – 7 Tools

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

### Calculate Percentage with Criteria in Excel (2 Useful Examples)

Method 1 - Use the IF Function to Calculate a Percentage with Criteria in Excel Consider the following dataset with the sales volume of some ...

### Conditional Average in Excel (Complete Guide)

Conditional averages involve calculating the average of a subset of data that meets specific criteria. In this Excel tutorial, we will demonstrate ...

### How to Calculate Average in Excel (Ultimate Guide)

In this article, we will comprehensively cover calculating the average in Excel, particularly using the AVERAGE function to find the average of ...

### How to Calculate Ratio in Excel: 4 Methods

Method 1 - Use Simple Division to Calculate Ratio Select the cell where you want to calculate the ratio >> Write the following formula: ...

### How to Divide in Excel (Using Functions and Features)

We used Microsoft 365 to prepare this article. You can apply the operations in Excel's previous versions with the exception of the QUOTIENT function, ...

### How to Subtract in Excel: 11 Different Methods

Method 1 - How to Subtract Two or More Numbers Manually in Excel Write the amounts like the following formula in cell G5 with the Minus (-) sign ...

### AutoSum in Excel (Complete Guideline)

To apply the AutoSum feature: Go to the Home tab > click AutoSum feature under the Editing group. This will insert the SUM formula ...

### How to Sum in Excel (All Things You Need to Know)

Here's the simplest use of the SUM function to sum a range of values. Download the Practice Workbook Sum in Excel.xlsx ...

### Calculate Salary in Excel

Calculate Salary in Excel: Knowledge Hub Calculate Basic Salary in Excel Calculate Gross Salary in Excel Calculate Net Salary in Excel ...

### How to Merge Sheets in Excel – Must-Know Tips and Techniques

This is an overview. Download Practice Workbook Merge.xlsx Merge VBA.xlsm How to Merge Excel Sheets in One File 1. ...

### How to Merge Tables in Excel ( 5 Methods)

Method 1 – Using the Power Query Tool Below are two different tables for Physics A and Physics B. We will combine two tables from multiple ...

### How to Add Comma in Excel (10 Easy ways)

Here's a simple overview of putting a comma separator for numerical values in Excel. Download the Practice Workbook How to Add Comma in ...

### How to Calculate Subtotals in Excel – A Complete Guide

This is an overview Download Practice Workbook Subtotals in Excel.xlsx How to Calculate Subtotals in Excel 1. Using the ...

Advanced Excel Exercises with Solutions PDF