Latest Blog Posts

Excel VBA: Split String by Number of Characters (2 Easy Methods)

In this article, I’ll show you how you split a string by any given number of characters using VBA in Excel. Split String by Number of ...

How to Subtract from Different Sheets in Excel: 2 Suitable Methods

Method 1 - Using Manual Formula to Subtract from Different Sheets Steps: Go to the spreadsheet where you want to find the subtraction of the ...

Subtracting One Range from Another in Excel VBA – 3 Examples

The following dataset contains sales records of different products in different regions.   Example 1 - Getting a Range Address ...

How to Calculate YTD (Year-To-Date) Average in Excel (4 Approaches)

Method 1 - Calculate YTD Average Using Excel AVERAGE Function For calculating the year-to-date average, we are going to use the following dataset. ...

How to Switch Rows and Columns in Excel Chart (2 Methods)

This tutorial will demonstrate how to switch rows and columns in an excel chart. Suppose we are creating a chart in excel or working on an existing ...

How to Sort Data by Value in Excel (5 Easy Methods)

The Excel Sort option allows us to customize the order of worksheet data. We can sort data alphabetically, numerically, date-wise, etc. Let’s explore ...

How to Split Date and Time in Excel (8 Easy Methods)

Method 1 - Using the INT Function to Split Date and Time in Excel We have a dataset containing the date and time. We'll split them in Columns C and ...

Convert Excel to Text File with Delimiter (2 Easy Approaches)

Text files consume less memory and are faster than Excel spreadsheets. Delimiters make text files more readable, especially those that have numeric ...

Split Column in Excel by Word (5 Effective Ways)

Suppose we have a list of addresses in a column as shown below. Each cell of the column contains the word SUITE. Let's split the column by that word. ...

Growth Over Last Year Formula in Excel (A Step-by-Step Analysis)

Year-over-year growth analysis can offer a comprehensive portrayal of a company's financial development. To compare the growth of a company over the ...

How to Split Names Using Formula in Excel: 5 Easy Methods

Method 1 - Extract First Name Steps Select cell C5 where you want to apply the formula to extract the first name. Write down the ...

How to Remove Sort by Color in Excel (With Easy Steps)

Step 1 - Add an Extra ‘Index’ Column Enter a 1 in a blank cell of the Index column to the right of the data set. Drag the Fill Handle to the ...

Excel VBA: Split String into Rows (6 Ideal Examples)

In this method, we’re going to show you 6 ways for Excel VBA split string(s) into rows. To demonstrate our methods, we’ve chosen a dataset with 2 ...

How to Hide Blank Rows in Excel VBA (4 Examples)

Below is a dataset of the sale details for different products. It contains a couple of blank rows that we will hide using simple VBA code. The ...

How to Multiply from Different Sheets in Excel (5 Methods)

In Microsoft Excel multiplying values is one of the most frequently used functions. There are several ways to perform this. However, it becomes ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo