@ExcelEasy

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

 Amsterdam
excel-easy.com
Joined November 2011
  • Tweets9.2K
  • Following194
  • Followers216K
1.1KMedia
Most Frequently Occurring Word in Excel. Which word wins the popularity contest? 🏆 excel-easy.com/examples/most…

Most Frequently Occurring Word in Excel

This example teaches you how to find the most frequently occurring word in Excel.

excel-easy.com
1
4
2,420
Your data moves. Your range gets the memo! 📩 Dynamic Named Range in Excel. excel-easy.com/examples/dyna…

Dynamic Named Range in Excel

A dynamic named range in Excel expands automatically when you add a value to the range.

excel-easy.com
1
1
10
3,292
Investment or Annuity in Excel. Watching your money grow is the best show ever! 📈 🍿 excel-easy.com/examples/inve…

Investment or Annuity in Excel

This example teaches you how to calculate the future value of an investment or the present value of an annuity in Excel.

excel-easy.com
2
10
3,277
Make loan payments crystal clear! 💰 PMT function in Excel. excel-easy.com/examples/pmt.…

PMT function in Excel

The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. This page contains many easy to follow PMT examples.

excel-easy.com
3
15
4,046
Not all events need cake. Some just need VBA! 🎂 Events in Excel VBA. excel-easy.com/vba/events.ht…

Events in Excel VBA

Events are actions performed by users which trigger Excel VBA to execute code.

excel-easy.com
2
14
3,943
OR function in Excel. One condition is enough! excel-easy.com/examples/or.h…

OR function in Excel

The OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false. Combine the OR function with other functions and become an Excel expert.

excel-easy.com
2
14
3,965
Kg to lbs in Excel. If only we could lose weight as quickly as we convert it! ⚖️ 😅 excel-easy.com/examples/kg-t…

Convert kg to lbs in Excel

1 kg = 2.20462 lbs (pounds) and 1 lb (pound) = 0.45359 kg. Use a simple formula, the CONVERT function or download our free unit converter to convert from kg to lbs or vice versa.

excel-easy.com
2
11
4,021
Flip your list in a few clicks! Reverse a List in Excel. excel-easy.com/examples/reve…

Reverse List Order in Excel

This article teaches you how to reverse the order of a list in Excel. For example, we want to reverse the list in column A below.

excel-easy.com
12
5,067
We all love a discount! 🛍️ Percentage Discount in Excel. excel-easy.com/examples/disc…

Discount Formulas in Excel

If you know the original price and the discounted price, you can calculate the percentage discount. If you know the original price and the percentage discount, you can calculate the discounted price,...

excel-easy.com
1
9
4,606
Mac *** Cheese. AND function in Excel. excel-easy.com/examples/and.…

AND function in Excel

The AND function in Excel evaluates multiple conditions and returns TRUE only if all conditions are TRUE. This guide provides a comprehensive understanding of the AND function, starting with basic...

excel-easy.com
3
14
4,322
Use Relative References in Excel VBA. Make your macros move smarter! excel-easy.com/vba/examples/…

Use Relative References in Excel VBA

By default, Excel records macros in absolute mode. However, sometimes it is useful to record macros in relative mode. This program teaches you how to do this.

excel-easy.com
2
11
4,113
LET function in Excel. Give your formulas room to breathe! 🫁 excel-easy.com/examples/let-…

LET function in Excel

Use the LET function in Excel 365/2021 to declare variables and assign values (or calculation results) to variables. Next, use these variables in a calculation.

excel-easy.com
1
17
4,761
One little $ can change everything! Cell References in Excel. excel-easy.com/functions/cel…

Cell References in Excel

Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

excel-easy.com
1
15
4,283
SWITCH function in Excel. Switch to smarter formulas! excel-easy.com/examples/swit…

SWITCH function in Excel

The SWITCH function in Excel looks up a specified value in a list of values and returns the result corresponding to the first match found.

excel-easy.com
2
5
3,726
Let your colors do the counting! 🎨 Sum by Color in Excel VBA. excel-easy.com/vba/examples/…

Sum by Color in Excel VBA

Learn how to create a program in Excel VBA that sums numbers by color.

excel-easy.com
1
13
4,184
Crack the code behind Excel errors! Formula Errors in Excel. excel-easy.com/functions/for…

Formula Errors in Excel

This chapter teaches you how to fix some common formula errors in Excel. Let's start simple.

excel-easy.com
3
12
3,886
Find your quarter in a flash! Quarter Formula in Excel. excel-easy.com/examples/quar…

Quarter Formula in Excel

An easy formula that returns the quarter for a given date. There's no built-in function in Excel that can do this.

excel-easy.com
3
10
3,668
Array Manipulation Functions in Excel. Make your arrays work smarter, not harder! excel-easy.com/examples/arra…

Array Manipulation in Excel

Use the new array manipulation functions in Excel 365 to quickly combine, shape and resize arrays.

excel-easy.com
5
10
3,631
Month Names in Excel VBA. Need to turn month numbers into names? excel-easy.com/vba/examples/…

Month Names in Excel VBA

Learn how to create a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of the months.

excel-easy.com
2
12
2,548
Merge Tables in Excel. Better together 🎶 by Jack Johnson. excel-easy.com/examples/merg…

Merge Tables in Excel

You can use tables and the VLOOKUP function in Excel to quickly merge two tables. This trick will bring your Excel game to a new level.

excel-easy.com
2
10
4,106
Load more