Excel Formulas

How to Split Data in Excel – 5 Methods

The  following dataset showcases full names and first and second names. Method 1 - Using Text to Columns Features to Split Data in Excel ...

How to Keep a Running Balance in Excel (8 Methods)

We've put daily Earnings and Expenses in the first week of February 2022 in our sample dataset. We'll use it to track expenses. How to ...

How to Find External Links in Conditional Formatting in Excel (2 Ways)

Assume your worksheet contains a large number of external links, and you now have to dynamically identify the cells that contain the links and ...

Excel Macro to Split Data into Multiple Files: 2 Methods

Method 1 - Steps to Create the Excel Macro to Split Data into Multiple Files Open the VBA Editor in Excel Press ALT+F11 to open the VBA editor ...

Calculate Debit Credit Running Balance Using Excel Formula (3 Examples)

We'll use the following dataset, where deposits and withdrawals on the credit and debit accounts are put in column C and column D. We’ll calculate ...

How to Find Max Value in Range with Excel Formula: 5 Easy Methods

Method 1 - Applying Excel MAX Formula to Find Maximum Value in Range Steps: Type the below formula in Cell B15 and press Enter from the ...

How to Combine Data from Multiple Sheets in Excel (4 Ways)

We have several students along with their Student ID and their Marks, where each sheet contains values for a different subject. We'll consolidate the ...

How to Keep Formatting in Excel When Referencing Cells – 2 Methods

The sample dataset contains two columns with names and ages. The header and data have different cell colors. Method 1 - Keeping the Format ...

How to Use INDEX MATCH with Multiple Criteria for Date Range

Let’s say we have certain products whose prices have remained stable for a certain period of time. We want to INDEX MATCH the prices for the given ...

How to Return Row Number of a Cell Match in Excel (7 Methods)

If you're working with huge datasets and extensive search functions, you might need to locate a specific row to find additional information for a ...

How to Convert Date to Year in Excel (3 Methods)

Dataset Overview We'll use the list of dates below to convert to year. Method 1 - Convert Date to Year Using Excel YEAR Function ...

How to Convert Date to Day of Week in Excel (8 Methods)

02/04/2022 represents a date, it does not provide any information on the day of the week. We will convert that value to the day of the week. ...

Get the First Day of the Current Month in Excel (3 Methods)

Microsoft Excel offers a handful of methods to get the first day of the current month. You can also get the first day of any random month or for the ...

Using the INDEX-MATCH Function with Multiple Criteria for a Partial Text in Excel – 2 Methods

The Excel INDEX Function The INDEX function returns the value of a cell at the intersection of a row and column in an array or range. Syntax ...

How to Merge Data from Multiple Workbooks in Excel (5 Methods)

We’ll use the following dataset that represents some salespersons’ sales in different regions. We’ll use two more workbooks, which also represent ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo