Convert HEX Values in Excel
Every day we deal with numbers with decimal notation, but there can be these rare occasions when we need to use other systems,…
Every day we deal with numbers with decimal notation, but there can be these rare occasions when we need to use other systems,…
In Excel, two functions are designed in a way to work with these types of codes: CHAR and CODE. If you want to…
If you want to calculate the time between two dates, you have to remember that’s a bit more complicated than calculating the difference…
Not very often can happen that we need to return the actual reference of a certain cell, instead of the cell value itself….
A lot of times, people are giving up on Excel because they have problems with formatting. One of the most common problems is…
So far, we showed and you are probably aware of the two cool functions- VLOOKUP and INDEX (in a combination with the MATCH…
If you are dealing with Excel, you will certainly stumble upon arrays at some point in time. Excel arrays are structures that can…
We covered the TRANSPOSE function earlier. This is an Excel formula that copies the text that is either horizontal or vertical and pastes…
We often find ourselves in a situation where we want to have a different view of existing data. As you probably know, Excel…
Excel is probably the best common tool to use when it comes to mathematical operations. Dealing with them is all about knowing what…