@ExcelEasy

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

 Amsterdam
excel-easy.com
Joined November 2011
  • Tweets9.3K
  • Following194
  • Followers216K
1.1KMedia
🏆 Excel's greatest hits! 10 Most Used Functions in Excel. excel-easy.com/examples/most…

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
3
2,120
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

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
1
5
2,679
🌦️ Forget the weather. Let's forecast your numbers! FORECAST in Excel. excel-easy.com/examples/fore…

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
9
3,263
Do your numbers get along? Correlation in Excel. excel-easy.com/examples/corr…

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
9
3,600
When N/A shows up, IFNA has your back! IFNA function in Excel. excel-easy.com/examples/ifna…

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
15
4,130
💰 Sell smarter, calculate faster! Sales Calculator in Excel VBA. excel-easy.com/vba/examples/…

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
15
3,867
Two functions enter, one text gets changed! SUBSTITUTE vs REPLACE in Excel. excel-easy.com/examples/subs…

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,124
What if? Let your data answer! Data Tables in Excel. excel-easy.com/examples/data…

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
15
4,064
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

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,416
Rows to columns? Turn things around! Transpose Data in Excel. excel-easy.com/examples/tran…

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
3,987
🧳 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

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

excel-easy.com
3
17
4,864
👀 A different view can change everything! Workbooks Views in Excel. excel-easy.com/examples/work…

Workbook Views in Excel

Excel offers three different workbook views: Normal, Page Layout and Page Break Preview.

excel-easy.com
3
14
3,852
Give your code something to think about! Variables in Excel VBA. excel-easy.com/vba/variables…

Variables in Excel VBA

This chapter teaches you how to declare, initialize and display a variable in Excel VBA.

excel-easy.com
1
11
4,571
Let's make everything add up! SUM formulas in Excel. excel-easy.com/examples/sum.…

SUM formulas in Excel

Use the SUM function in Excel to sum a range of cells, an entire column or non-contiguous cells. To create awesome SUM formulas, combine the SUM function with other Excel functions.

excel-easy.com
2
13
3,868
Forgot to save? Panic! 🆘 AutoRecover in Excel. excel-easy.com/examples/auto…

AutoRecover in Excel

Excel periodically saves a copy of your Excel file. Learn how to recover a file that was never saved and how to recover a file that has been saved at least once.

excel-easy.com
3
22
4,867
☕️ Even macros need a coffee break! Delay a Macro in Excel. excel-easy.com/vba/examples/…

Delay a Macro in Excel

To execute a sub in Excel VBA after a specific time, use onTime, Now and the TimeValue function.

excel-easy.com
1
16
4,728
DATEDIF function in Excel. To calculate the time between two dates! ⏳ excel-easy.com/examples/date…

DATEDIF function in Excel

The DATEDIF function in Excel calculates the number of days, months or years between two dates. The DATEDIF function has 3 arguments.

excel-easy.com
2
20
4,508
Keep your spreadsheets under lock and key! 🔐 Password Protect an Excel File. excel-easy.com/basics/protec…

Password Protect an Excel File

Encrypt an Excel file with a password so that it requires a password to open it. To password protect an Excel file, execute the following steps.

excel-easy.com
1
3
9
3,922
Bring your project timeline to life! Gantt Chart in Excel. excel-easy.com/examples/gant…

Gantt Chart in Excel

Excel does not offer Gantt as a chart type, but it's easy to create a Gantt chart by customizing the stacked bar chart type.

excel-easy.com
2
15
3,936
For the positive-minded (and negative numbers): Negative Numbers to Zero in Excel. excel-easy.com/examples/nega…

Negative Numbers to Zero in Excel

A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.

excel-easy.com
1
8
4,149
Load more