How to Create Excel Formulas
Apr 23, 2024
Let's use a Score List of Math scores of some students. This dataset contains the ID, Student Name, and their corresponding Marks in columns B, C, ...
Aug 6, 2024
The sample dataset (B4:D13) showcases Item, Quantity, and Unit Price of Fruit Sales.
Example 1: Multiplying Named Ranges
Steps: ...
Jun 15, 2024
Here we use three worksheets on the Salary of Employees for January, February, and March. We used the short form of the month names as the ...
Jul 3, 2024
We'll use the following dataset to combine formulas in a single cell.
Step 1 - Creating the Data Set
In this step, the SUM function and ...
Jun 18, 2024
We have Sales Data of a Company as our dataset. In the dataset, we have Quarterly Sales for the Years 2021 and 2022. We will find the Half-Yearly ...
Jul 5, 2024
We have a sample dataset of product prices and taxes to be applied to them. We have formatted all the data cells in the Accounting format. We saved ...
Jun 14, 2024
Method 1 - Use Formula with IF Function to Exclude Zero Values in Excel
Let’s say, we have a dataset displayed in the (B4:D8) cells. Here, the ...
Jul 26, 2024
We have a dataset that contains some employees’ salaries for two years and their salary increments.
Method 1 - Use the AutoFill Tool
...
Jul 31, 2024
Despite all the built-in functions provided by Excel, we may need to create a different function to get our job done. Excel lets us create our own ...
Jul 29, 2024
Dataset Overview
Let’s consider a sales data set where sellers receive a 10% commission on each product sold. To calculate the commission, we’ve ...
Aug 3, 2024
Consider the Performance of Sales Reps dataset. It showcases Names, the 2022 Sales, and the 2021 Sales of each employee.
Method ...
Jul 3, 2024
Example 1 - Applying Combined Functions to Make a FOR Loop in Excel
Here's an overview of the problem we'll solve with a for loop.
Steps: ...
