Excel Formulas

Excel Concatenate Date

Excel Concatenate Date: Knowledge Hub How to Concatenate Date and Time in Excel Excel VBA: Combine Date and Time How to Concatenate ...

Excel Concatenate Text

Excel Concatenate Text: Knowledge Hub Add Text and Formula in the Same Cell in Excel Concatenate Names in Excel Copy Concatenate Formula ...

Sum or Subtract Percentages in Excel

In this Excel tutorial, we will discuss various examples of how to sum or subtract percentages. Adding or Subtracting percentages is often required ...

How to Create Named Range in Excel: 4 Suitable Methods

Method 1 - Create Named Range Using Name Box Create a name for the Annual Salary column using the Name Box. Select the cell range F6:F15 ...

How to Copy a Formula in Excel (Column, Rows, Copy as Formulas)

The following image shows a dataset containing products from different sellers. Each product has a discount. The formula to calculate the discounted ...

How to Calculate Percentage Change in Excel (4 Examples)

The following dataset contains some products (B5:B14) and their sales in January (C5:C14) and February (D5:D14). We have calculated the percentage ...

Find and Replace in Excel (A Complete Guideline)

In this blog post, you will learn how to find and replace data in Excel- Using the Find and Replace tool Using the Go to Special feature for ...

Excel Formula List (40+ Useful Formulas to Master Excel)

In the following image, you see some students with their marks in English. We have calculated the total marks, average marks, total no. of students, ...

How to Repeat Actions, Cell Values and Patterns in Excel (Complete Guideline)

In this Excel tutorial, you will learn: - How to redo actions - How to repeat cell values - How to repeat patterns - How to repeat formulas using ...

How Can You Compare Tables in Excel? (All You Need to Know)

The following sample dataset will be used for illustration. ⏷ Apply Conditional Formatting to Compare Tables and Highlight Differences  ⏵ ...

How to Insert, Use and Convert Complex Numbers in Excel?

In the following image, we have shown different functions related to complex number operations in Excel. X and Y are two complex numbers. We can see ...

How to Do a GST Reconciliation in Excel (4 Methods)

What Is GST Reconciliation in Excel? GST (Goods and Services Tax) is a tax applied to items you purchase or services you use. It’s added to the cost ...

How to Create Multiple Invoices in an Excel Spreadsheet – 2 Steps

This is an overview. Download Practice Workbook Invoices.xlsx Creating Multiple Invoices.docx Create Invoices in ...

How to Combine Two Formulas in Excel (3 Ways)

Here is an overview of combining two formulas in Excel. How to Combine Two Formulas in Excel: 3 Ways Method 1 - Two Different ...

How to Calculate Pearson’s Coefficient of Skewness in Excel

In this article, I am going to show how we can calculate Pearson's Coefficient of Skewness in Excel. Excel offers two functions SKEW and SKEW.P to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo