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 26 Oct 2022 0

Suppose you have a JSON file that looks like this and you want to import it as a table into Power BI: This… 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 March 13, 2022 0

The F5 key in Excel is a bit of a neglected child within Excel. The possibilities behind this test are very useful,… 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