excel Archives

What is the difference between .Text, .Value and .Value2

Door Bjorn Meijer November 15, 2023 0

There are three ways to use VBA in Excel to extract the value from a cell using the Range object… Read more

Door Bjorn Meijer November 2, 2023 0

Whether you're analyzing financial data, preparing a sales report, or managing a list of customer information, it's often essential to… Read more

Door Bjorn Meijer November 30, 2022 0

Since Excel 2013, Microsoft has added a new useful feature, QuickFill. As soon as Excel recognizes a pattern, the… Read more

Door Bjorn Meijer Nov 10, 2022 2

Especially with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color… Read more

Door Bjorn Meijer 28 Oct 2022 0

In this article I explain how you can find out based on a date whether it is in… Read more

Door Bjorn Meijer 15 Oct 2022 0

Microsoft Excel is ideal for performing operations on large amounts of data. One of the useful features within Microsoft… Read more

Door Bjorn Meijer 17 January 2022 0

If you regularly work with Excel, it often happens that you have to add columns or rows of numbers. And… Read more

Door Bjorn Meijer January 4, 2022 0

For example, in Excel you can easily fill a drop-down list with data using a range. If in the… Read more

Door Bjorn Meijer December 14, 2021 0

Suppose you have a long list of data that contains a number of empty rows or cells. The empty rows… Read more

Door Bjorn Meijer November 2, 2021 0

The possibilities in Excel are virtually unlimited. You can even create your own rainfall radar and process the data in a… Read more