@ExcelEasy profile picture
Excel Easy @ExcelEasy

Fully illustrated Excel tutorial 300 examples. 100% free.

Joined November 2011
  • Tweets 8,813
  • Following 195
  • Followers 217,773
1,127 Photos and videos
NPV formula in Excel excel-easy.com/examples/npv.…

NPV formula in Excel

The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment.

excel-easy.com
7
1,485
Contains Specific Text excel-easy.com/examples/cont…

Contains Specific Text in Excel

To check if a cell contains specific text, use ISNUMBER and SEARCH in Excel. There's no CONTAINS function in Excel.

excel-easy.com
1
13
2,018
Remove Spaces in Excel excel-easy.com/examples/remo…

Remove Spaces in Excel

The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.

excel-easy.com
3
15
2,044
Date and Time in Excel VBA excel-easy.com/vba/date-time…

Date and Time in Excel VBA

Learn how to work with dates and times in Excel VBA. To declare a date, use the Dim statement. To initialize a date, use the DateValue function.

excel-easy.com
2
13
2,092
Percent Change Formula in Excel excel-easy.com/examples/perc…

Percent Change Formula in Excel

The percent change formula is frequently used in Excel. First, let's understand the formula. Next, let's calculate the monthly and total percent change over a period of time.

excel-easy.com
1
3
16
2,317
Substring in Excel excel-easy.com/examples/subs…

Substring in Excel

There's no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and MAX in Excel to extract substrings.

excel-easy.com
1
14
2,276
SUMIF function in Excel excel-easy.com/examples/sumi…

SUMIF function in Excel

The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples.

excel-easy.com
1
15
2,138
Circular Reference in Excel excel-easy.com/examples/circ…

Find a Circular Reference in Excel

A circular reference in Excel occurs when a formula directly or indirectly refers to its own cell. This is not possible. Let's start simple.

excel-easy.com
12
2,282
Analysis ToolPak in Excel excel-easy.com/data-analysis…

Analysis ToolPak in Excel

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.

excel-easy.com
4
15
2,905
Solver in Excel excel-easy.com/data-analysis…

Solver in Excel

Excel includes a tool called Solver that uses techniques from operations research, a field focused on optimizing decisions, to solve all kinds of problems. To load the Solver add-in, execute the...

excel-easy.com
6
32
3,281
Delete Blank Rows in Excel excel-easy.com/examples/dele…

Delete Blank Rows in Excel

To delete blank rows in Excel, use Go To Special, Blanks. You can also use the COUNTA function and a filter to remove empty rows.

excel-easy.com
2
23
2,061
Running Total (Cumulative Sum) in Excel excel-easy.com/examples/runn…

Running Total in Excel

This page teaches you how to create a running total (cumulative sum) in Excel. A running total changes each time new data is added to a list.

excel-easy.com
19
1,804
Anova in Excel excel-easy.com/examples/anov…

ANOVA in Excel

This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor ANOVA is used to test the null hypothesis that the means of several populations are all...

excel-easy.com
1
13
2,216
Pivot Tables in Excel excel-easy.com/data-analysis…

Pivot Tables in Excel

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

excel-easy.com
2
23
2,195
LAMBDA function in Excel excel-easy.com/examples/lamb…

LAMBDA function in Excel

Use LAMBDA and the Name Manager in Excel to create your own Excel function. You can use this custom function like any other Excel function!

excel-easy.com
15
2,391
Check Mark in Excel excel-easy.com/examples/chec…

Insert a Check Mark in Excel

To insert a check mark symbol in Excel, simply press SHIFT P and use the Wingdings 2 font. You can also insert a checkbox in Excel.

excel-easy.com
1
9
1,995
Budget in Excel excel-easy.com/examples/budg…

Create a Budget in Excel

This example shows you how to create a budget in Excel. Follow this step-by-step guide and take control of your finances. First, enter the different types of income and expenses in column A.

excel-easy.com
1
10
2,337
Calendar in Excel excel-easy.com/examples/cale…

Calendar in Excel

This example describes how to create a calendar in Excel (2025 calendar, 2026 calendar, etc). If you are in a hurry, simply download the Excel file.

excel-easy.com
2
12
2,033
INDEX and MATCH in Excel excel-easy.com/examples/inde…

INDEX and MATCH in Excel

Use INDEX and MATCH in Excel and impress your boss. Instead of using VLOOKUP, use INDEX and MATCH. To perform advanced lookups, you'll need INDEX and MATCH.

excel-easy.com
2
15
1,917
Comparison Operators in Excel excel-easy.com/examples/comp…

Comparison Operators in Excel

Use comparison operators in Excel to check if two values are equal to each other, if one value is greater than another value, if one value is less than another value, etc.

excel-easy.com
2
8
1,825
Load more