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)
Row meets column. 💕 Match made in spreadsheet heaven! Two-way Lookup in Excel. excel-easy.com/examples/two-…
Two-way Lookup in Excel

Two-way Lookup in Excel

To lookup a value in a two-dimensional range, use INDEX and MATCH in Excel. Below you can find the sales of different ice cream flavors in each month.

excel-easy.com
1
6
2,294
Text doesn't fit? AutoFit! ✨ AutoFit in Excel. excel-easy.com/examples/auto…
AutoFit in Excel

AutoFit in Excel

You probably know how to change the width of a column in Excel, but do you also know how to automatically fit the widest entry in a column?

excel-easy.com
1
5
2,993
Wrong entries? Not on our watch! 😎 Data Validation in Excel. excel-easy.com/basics/data-v…
Data Validation in Excel

Data Validation in Excel

Use data validation in Excel to make sure that users enter certain values into a cell.

excel-easy.com
7
3,221
Count Cells with Text in Excel. Numbers aren't the only things that count! 😉 excel-easy.com/examples/coun…
Count Cells with Text in Excel

Count Cells with Text in Excel

This page illustrates multiple ways to count cells with text in Excel. Visit our page about the COUNTIF function to count cells that contain specific text.

excel-easy.com
8
3,822
Excel, can you move that for me? OFFSET function in Excel. excel-easy.com/examples/offs…
OFFSET function in Excel

OFFSET function in Excel

The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

excel-easy.com
1
2
13
4,150
Decisions made easy: Combo Box in Excel VBA. excel-easy.com/vba/examples/…
Combo Box in Excel VBA

Combo Box in Excel VBA

A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To create a combo box in Excel VBA, execute the following steps.

excel-easy.com
1
8
4,021
The fun we never signed up for.. Tax Rates in Excel. excel-easy.com/examples/tax-…
Tax Rates in Excel

Tax Rates in Excel

This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel. The following tax rates apply to individuals who are residents of Australia.

excel-easy.com
1
12
4,024
Choices, choices.. good thing there's: Select Case in Excel VBA. excel-easy.com/vba/examples/…
Select Case in Excel VBA

Select Case in Excel VBA

Instead of multiple If Then statements in Excel VBA, you can use the Select Case structure. Let's explore this through two examples.

excel-easy.com
2
13
4,396
Don't start from scratch. Start smart! Default Templates in Excel. excel-easy.com/examples/defa…

Default Templates in Excel

Book.xltx and Sheet.xltx are two special templates you can create and add to the XLStart folder. As a result, Excel uses Book.xltx as the basis for new workbooks and Sheet.xltx as the basis for new...

excel-easy.com
10
3,787
Give your range a name. “Hey, you!” gets confusing. Name Box in Excel. excel-easy.com/examples/name…
Name Box in Excel

Name Box in Excel

You can use the name box in Excel to select a cell, range or named range. You can also use the name box to quickly create a named range (important).

excel-easy.com
7
3,854
Need more room? Resize! No renovation required. 😉 Resize Property in Excel VBA. excel-easy.com/vba/examples/…
Resize Property in Excel VBA

Resize Property in Excel VBA

The Resize property in Excel VBA makes a range a specific number of rows and columns smaller or larger. The Resize property always takes the top left cell of a range as the starting point.

excel-easy.com
8
3,904
Average? Only if! 😉 AVERAGEIF function in Excel. excel-easy.com/examples/aver…
AVERAGEIF function in Excel

AVERAGEIF function in Excel

The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria.

excel-easy.com
1
7
3,767
Life is chaotic. Let’s organize it! Calendar in Excel. excel-easy.com/examples/cale…
Calendar in Excel

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
10
3,604
Time to show those leading zeros the door! Remove Leading Zeros in Excel. excel-easy.com/examples/remo…
Remove Leading Zeros in Excel

Remove Leading Zeros in Excel

This guide teaches you how to remove leading zeros in Excel. The first method uses Paste Special to remove leading zeros from numbers affected by text formatting. The second method uses a simple...

excel-easy.com
1
7
3,558
🩷 Love is priceless. Loans? Let's calculate! 😅 Loan Calculator in Excel VBA. excel-easy.com/vba/examples/…
Loan Calculator in Excel VBA

Loan Calculator in Excel VBA

This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons.

excel-easy.com
1
11
3,499
Lost in translation? Convert Text to Numbers in Excel. excel-easy.com/examples/text…
Convert Text to Numbers in Excel

Convert Text to Numbers in Excel

In Excel, text is left-aligned and numbers are right-aligned. This example teaches you how to convert 'text strings that represent numbers' to numbers.

excel-easy.com
1
1
9
3,540
💬 Your code has something to say! Text Box in Excel VBA. excel-easy.com/vba/examples/…
Text Box in Excel VBA

Text Box in Excel VBA

A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA, execute the following steps.

excel-easy.com
1
11
3,963
• Straight to the point! Bullet Points in Excel. excel-easy.com/examples/bull…
Bullet Points in Excel

Bullet Points in Excel

This page illustrates 4 ways to insert bullet points in Excel. You can use a keyboard shortcut, insert a symbol, create a custom number format (our favorite) or use the CHAR function.

excel-easy.com
1
17
3,971
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
12
3,926
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
11
3,906
Load more