Excel Formulas

How to Sum Columns by Color in Excel (6 Easy Methods)

In this article, I will discuss how you can get the sum of cells in Excel columns by color. Often, while working with Microsoft Excel, we use ...

How to Generate a Random String from a List in Excel (5 Suitable Ways)

In this article, you will learn 5 different ways to generate a random string from a list in Excel with ease. How to Generate Random String ...

Subtraction for Whole Column in Excel (with 5 Examples)

Subtraction is one of the most common techniques in Excel. We use this in our day-to-day calculations numerous times. In Microsoft Excel, subtraction ...

How to Separate Date in Excel Using Formula (5 Suitable Ways)

Separating dates from different parts of the text or time is one of the most common uses of Excel.  Also extracting day month and year from part of ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Sometimes it becomes a necessity for us to know the sum of some filtered cells. Though we can do it manually, Excel has some fantastic features to ...

How to Sum Selected Cells in Excel (4 Easy Methods)

If you are looking for some special tricks to sum selected cells in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

How to Subtract from Different Sheets in Excel (2 Suitable Ways)

It is very common in everyday Excel usage that you need to calculate data from two or more different spreadsheets. For example, you may need to ...

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

Year-To-Date (YTD) refers to the amount of time from the start of the present calendar year or administrative year to the present day. Microsoft ...

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

If you are looking for some special tricks to split date and time in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

Split Column in Excel by Word (5 Effective Ways)

This article illustrates 5 different ways you can split a column in excel by word. Suppose each cell of a column in a dataset contains a particular ...

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 (4 Easy Methods)

In Microsoft Excel, there must be some cases when you need to split the full name. Excel has several methods to do this. It actually reduces your ...

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

How to Split Names with Comma in Excel (3 Suitable Ways)

In Excel, you may run into situations where you have to split names inside of cells separated with the comma a lot. In the event, you may need to ...

Generate Random Number Between 0 and 1 in Excel (2 Methods)

Manually Generating random numbers is tiresome work. However, we can produce random numbers using different Excel functions. In this article, we will ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo