Excel Formulas

How to Pull Data From Another Sheet Based on Criteria in Excel

Method 1 - Use the Advanced Filter to Pull Data from Another Sheet We have a dataset of customers and their payment history. We are going to pull ...

How to Count Specific Characters in a Column in Excel – 4 Methods

The sample dataset showcases authors and book titles: Method 1 - Using the SUMPRODUCT Function to Count Specific Characters in a Column ...

How to Count Number of Characters in a Cell in Excel?

If you are looking for some of the easiest ways to count the number of characters in a cell in Excel, then you are in the right place. Sometimes it ...

How to Create a Range of Numbers in Excel (3 Easy Methods)

Method 1 - Use the Data Validation Option to Create a Range of Numbers in Excel In this datasheet, we have used 3 columns and 7 rows to represent ...

How to Remove Text After Character in Excel: 4 Easy Ways

Using Find & Replace Feature Select your data. Press Ctrl + H to get the Find and Replace dialog. Or, go to the Home tab > Editing ...

Why Excel Shows Formulas Instead of Results (7 Reasons)

For example, we have the following dataset and you see Excel is showing formulas in the cells instead of calculated results. Let’s check how we can ...

How to Create a Formula in Excel for Multiple Cells (9 Easy Ways)

We have a dataset that contains some employees’ salaries for two years and their salary increments. Method 1 - Use the AutoFill Tool ...

How to Lock a Cell in Excel Formula (2 Easy Ways)

Method 1 - Assigning a Dollar Sign ($) Manually to Cell References Steps: Let’s calculate the speed of light for the Water medium. Select ...

How to Calculate Difference Between Two Dates and Times in Excel

  Part 1 - Calculating the Difference Between Two Dates in Excel We have the Starting Date of different projects in column C and the Ending ...

How to Auto Update Current Time in Excel (3 Easy Ways)

  Method 1 - Using the NOW Function  Steps: Select cell C4 and enter this formula: =NOW() Press Enter. It will enter ...

How to Create a Custom Formula in Excel (2 Practical Examples)

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 ...

How to Create a Formula in Excel (5 Easy 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 the Sheet Name in a Dynamic Formula in Excel – 3 Methods

There are 4 datasets containing information about sales representatives and their sales: Quarter 1, Quarter 2, Quarter 3, and Quarter 4. ...

Transpose Data in Excel (Applying Functions, Commands, and VBA)

Download Practice Workbook Transpose Data.xlsm Method 1 - Using Excel Paste Special Tool to Transpose Data Press Ctrl + C to ...

How to Transpose Rows to Columns in Excel (7 Quick Methods)

Below is a dataset that shows the year and Results of Students. Method 1 – Using Paste Special Command a) Pasting a Special Command from ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo