Excel Formulas

How to Auto-Update Current Time in Excel (With Formula and VBA)

While working in Excel, we often have to enter the current date and time in a cell for various purposes and auto-update them. Today I’ll show you how ...

How to Show and Hide Formula Bar in Excel (3 Methods)

Excel formula bar is a tool that can be used to edit any cell values applying a formula. By default, the formula bar is visible in Excel directly ...

Excel Current Date Formula (with 11 Easy Examples)

To get the current date in Excel, you generally have to utilize the TODAY() formula. This article will show you the various ways of how to apply the ...

Remove First Character from String in Excel (4 Ways)

Many times, you need to remove the first character from a string of your database in Excel. The article will help to know 4 different ways to remove ...

How to Create a Custom Formula in Excel (A Step-by-Step Guideline)

While working in Excel or making custom worksheets for business analysis, we may need to create a custom formula of our own. Despite all the ...

How to Create a Formula in Excel (5 Ways)

Excel can be used to perform any type of calculation and creating a formula is the basis of the calculation. In this article, you will learn how to ...

How to Use Sheet Name in Dynamic Formula in Excel

Sometimes depending on the scenario, you may need to use worksheet names in the formula, providing the sheet name manually is a tedious task. To ...

How to VLOOKUP with Multiple Conditions in Excel (2 Methods)

When you have to deal with massive data from multiple worksheets across your Excel workbook, The VLOOKUP Function is your savior. The VLOOKUP ...

Combine SUMIF and VLOOKUP in Excel (3 Quick Approaches)

In Microsoft Excel, we have to combine SUMIF and VLOOKUP functions to look for a value, and based on that criterion, a sum is calculated from a range ...

How to Transpose Rows to Columns in Excel (5 Useful Methods)

Transposing data in MS Excel is truly one of the most common tasks performed by Excel users. Indeed, there are many ways to transpose rows to columns ...

How to Move Columns in Excel (5 Quick Methods)

There are different methods to move columns in Microsoft Excel. In this article, I’ll show the most suitable 5 ways to move columns in an Excel sheet ...

How to Add Specific Cells in Excel (5 Simple Ways)

To add specific cells here I will show how to do it in some easy ways in Excel. Go through the flows of the screenshots carefully and hope you will ...

How to Perform VLOOKUP with Wildcard in Excel (2 Methods)

Whenever you are handling a wide range of data in your worksheet, applying VLOOKUP with wildcards is an effective way to find your texts or values ...

How to Add Multiple Cells in Excel (6 Methods)

There are a few quick ways to add multiple cells in Excel. Today we are going to learn how to use them with numerous techniques and formulas. ...

How to Combine Multiple Rows into One Cell in Excel

Sometimes we need to show the multiple rows data into one cell to mean something or to create a new column. In this article, I’m going to describe ...

ExcelDemy
Logo