Excel Basics Archives - Page 119 of 124

How to Copy a Sheet to Another Workbook with Excel Formulas – 2 Methods

Aug 3, 2024

The Excel workbook contains different worksheets. This worksheet showcases the following dataset: Use this formula to calculate the Average ...

How to Copy a Sheet to Another Workbook with Excel Formulas – 2 Methods

How to Copy a Formula in Excel with Changing Cell References (14 Methods)

Aug 9, 2024

Method 1 - Dragging the Fill Handle Icon Suppose a company has decided to increase the salary of five specific employees by 10%. You have a ...

How to Copy a Formula in Excel with Changing Cell References (14 Methods)

How to Sort Data Using a Formula in Excel – 2 Methods

Aug 14, 2024

This is an overview: Method 1 -Using the SORT Function 1.1 Sorting in Ascending Order Select a blank cell. ...

How to Sort Data Using a Formula in Excel – 2 Methods

How to Sort by Date and Time in Excel (4 Useful Methods)

Jun 16, 2024

Let’s have a look at our sample dataset. Here, the Order ID of products is given along with their Delivery Date, Delivery Time, and Price. ...

How to Sort by Date and Time in Excel (4 Useful Methods)

How to Sort Dates in Excel by Year (4 Methods)

Jul 17, 2024

Dataset Overview Let’s consider a dataset of employees with their ID, Name, Joining Date, and Year. Here’s an overview of the dataset that we'll use ...

How to Sort Dates in Excel by Year (4 Methods)

How to Apply Multiple Filters in Excel: 6 Methods

Apr 16, 2024

Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits ...

How to Apply Multiple Filters in Excel: 6 Methods

How to Sort Dates in Chronological Order in Excel (6 Easy Ways)

Jun 18, 2024

The dataset below has data in the Products, Order Date, Delivery Date, and Price columns. Method 1 – Adopting the Sort & Filter Option ...

How to Sort Dates in Chronological Order in Excel (6 Easy Ways)

How to Arrange Numbers in Ascending Order in Excel Using Formula: 3 Ways

Jul 4, 2024

Method 1 - Arranging Numbers in Ascending Order in Excel Using SMALL with ROWS and COLUMNS Functions 1.1 Sorting by Rows Combine SMALL with the ...

How to Arrange Numbers in Ascending Order in Excel Using Formula: 3 Ways

How to Sort Columns in Excel Without Mixing Data (6 Methods)

Jul 22, 2024

Dataset Overview Suppose you have a basic table containing the names of students and their respective scores in three courses. In this scenario, ...

How to Sort Columns in Excel Without Mixing Data (6 Methods)

How to Sort Multiple Columns in Excel (5 Quick Methods)

May 15, 2024

We will use the sample dataset below for illustration. Watch Video – Sort Multiple Columns in Excel Method 1 - Using ...

How to Sort Multiple Columns in Excel (5 Quick Methods)

How to Compare Text in Two Columns in Excel

May 22, 2024

For illustration, we will use following sample dataset containing two lists of items. Method 1 - Comparing Text in Two Columns For Matches ...

How to Compare Text in Two Columns in Excel

How to Increment Month by 1 in Excel (8 Handy Ways)

Jun 16, 2024

We have a dataset of dates in the cell range B5:B16. We will calculate the 1-month increment of the given dates. Method 1 - Use the ...

How to Increment Month by 1 in Excel (8 Handy Ways)

How to Add a 1 in Front of Numbers in Excel (7 Methods)

May 17, 2024

Method 1 - Using Ampersand Operator The ampersand operator is used to combine or merge two or more cells in Excel. In this method, we will ...

How to Add a 1 in Front of Numbers in Excel (7 Methods)

Excel COUNTIF Function to Count Cells Greater Than 0

Jul 16, 2024

Download the Practice Workbook COUNTIF to Count Greater Than Zero Introduction to the COUNTIF Function Syntax COUNTIF(range, ...

Excel COUNTIF Function to Count Cells Greater Than 0

How to Get 2 Decimal Places Without Rounding in Excel: 4 Methods

Jul 6, 2024

Method 1 - Getting 2 Decimal Places without Rounding for Both Positive and Negative Values in Excel Using TRUNC Function Using Excel TRUNC ...