Excel Easy (@ExcelEasy) header
Excel Easy (@ExcelEasy) profile picture

Excel Easy

@ExcelEasy

Fully illustrated Excel tutorial + 300 examples. 100% free.

 Amsterdam
excel-easy.com
Joined November 2011
  • Tweets9.3K
  • Following194
  • Followers216K
1.1KMedia
Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)Photo by Excel Easy (@ExcelEasy)
Life's too short for decimal-only thinking! Fractions in Excel. excel-easy.com/examples/frac…
Fractions in Excel

Fractions in Excel

This example teaches you how to enter a fraction in Excel and how to change the format of a fraction.

excel-easy.com
4
1,785
Looking for something? SEARCH function in Excel. excel-easy.com/examples/sear…
SEARCH function in Excel

SEARCH function in Excel

Use the SEARCH function in Excel to find the position of a substring in a string. The SEARCH function is case-insensitive and supports wildcards.

excel-easy.com
1
7
2,911
Round and round the controls go! Loop through Controls in Excel VBA. excel-easy.com/vba/examples/…
Loop through Controls in Excel VBA

Loop through Controls in Excel VBA

With just a few lines of code, we can easily loop through controls on an Excel VBA Userform.

excel-easy.com
6
3,444
Add it up, filter it down! SUBTOTAL function in Excel. excel-easy.com/examples/subt…
SUBTOTAL function in Excel

SUBTOTAL function in Excel

Use the SUBTOTAL function in Excel (instead of SUM, COUNT, MAX, etc.) to ignore rows hidden by a filter or to ignore manually hidden rows.

excel-easy.com
1
1
11
3,884
Been living under a rock? Excel still knows today's date! Today's Date in Excel. excel-easy.com/examples/toda…
Today's Date in Excel

Today's Date in Excel

To enter today's date in Excel, use the TODAY function. To enter the current date and time, use the NOW function. To enter the current date and time as a static value, use keyboard shortcuts.

excel-easy.com
1
15
4,015
🍔🍔 Seeing double? Find Duplicates in Excel. excel-easy.com/examples/find…
Find Duplicates in Excel

Find Duplicates in Excel

This page teaches you how to find duplicate values (or triplicates) and how to find duplicate rows in Excel. Select a range of cells. On the Home tab, in the Styles group, click Conditional Formatt...

excel-easy.com
12
4,450
Think inside the range! Range in Excel. excel-easy.com/introduction/…
Range in Excel

Range in Excel

A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

excel-easy.com
9
3,987
Every second, third, or tenth row? Sum Every nth Row in Excel. excel-easy.com/examples/sum-…
Sum Every nth Row in Excel

Sum Every nth Row in Excel

This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for any number.

excel-easy.com
2
13
4,020
Don't just pivot. Get the data! GETPIVOTDATA function in Excel. excel-easy.com/examples/getp…
GETPIVOTDATA function in Excel

GETPIVOTDATA function in Excel

To quickly enter a GETPIVOTDATA function in Excel, type an equal sign (=) and click a cell in a pivot table. The GETPIVOTDATA function can be quite useful.

excel-easy.com
1
2
18
4,191
🏆 Excel's greatest hits! 10 Most Used Functions in Excel. excel-easy.com/examples/most…
10 Most Used Functions in Excel

10 Most Used Functions in Excel

Let's check out the 10 most used Excel functions. Visit our section about functions for detailed explanations and more awesome functions.

excel-easy.com
1
13
3,889
Start here, finish there. Let VBA handle the journey! 🏁From Active Cell to Last Entry in Excel VBA. excel-easy.com/vba/examples/…
From Active Cell to Last Entry in Excel VBA

From Active Cell to Last Entry in Excel VBA

This example illustrates the End property of the Range object in Excel VBA. We will use this property to select the range from the Active Cell to the last entry in a column.

excel-easy.com
3
13
3,542
🌦️ Forget the weather. Let's forecast your numbers! FORECAST in Excel. excel-easy.com/examples/fore…
FORECAST in Excel

FORECAST in Excel

The FORECAST (or FORECAST.LINEAR) function in Excel predicts a future value along a linear trend. The FORECAST.ETS function in Excel predicts a future value using Exponential Triple Smoothing, which...

excel-easy.com
1
11
3,835
Do your numbers get along? Correlation in Excel. excel-easy.com/examples/corr…
Correlation in Excel

Correlation in Excel

The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. Use the CORREL function or the Analysis Toolpak to find the correlation...

excel-easy.com
1
11
3,997
When N/A shows up, IFNA has your back! IFNA function in Excel. excel-easy.com/examples/ifna…
IFNA function in Excel

IFNA function in Excel

Use the IFNA function in Excel to replace a #N/A error with a friendly message. The IFNA function only catches #N/A errors.

excel-easy.com
2
16
4,366
💰 Sell smarter, calculate faster! Sales Calculator in Excel VBA. excel-easy.com/vba/examples/…
Sales Calculator in Excel VBA

Sales Calculator in Excel VBA

Learn how to create a program in Excel VBA that calculates the total sales of each employee over a period of three years.

excel-easy.com
1
16
4,006
Two functions enter, one text gets changed! SUBSTITUTE vs REPLACE in Excel. excel-easy.com/examples/subs…
SUBSTITUTE vs REPLACE in Excel

SUBSTITUTE vs REPLACE in Excel

If you know the text to be replaced, use the SUBSTITUTE function in Excel. If you know the position of the text to be replaced, use the REPLACE function.

excel-easy.com
2
13
4,222
What if? Let your data answer! Data Tables in Excel. excel-easy.com/examples/data…
Data Tables in Excel

Data Tables in Excel

Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table in Excel.

excel-easy.com
16
4,135
Your own little app, right inside Excel! Userform with Multiple Pages in Excel VBA. excel-easy.com/vba/examples/…
Userform with Multiple Pages in Excel VBA

Userform with Multiple Pages in Excel VBA

Learn how to create a program in Excel VBA which creates a Userform that contains multiple pages. This userform also contains images.

excel-easy.com
2
11
4,465
Rows to columns? Turn things around! Transpose Data in Excel. excel-easy.com/examples/tran…
Transpose Data in Excel

Transpose Data in Excel

Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel. You can also use the TRANSPOSE function.

excel-easy.com
11
4,033
🧳 So much to pack, so little space! Excel to the rescue! Knapsack Problem in Excel VBA. excel-easy.com/vba/examples/…
Knapsack Problem in Excel VBA

Knapsack Problem in Excel VBA

Learn how to create a program in Excel VBA that solves a small instance of a knapsack problem.

excel-easy.com
3
16
4,920
Load more