Excel-related articles.
In Excel tables, having each row number displayed is convenient so you can see where you are and how many records exist. However, if you use static numbers or formulas like =ROW(1:1) to achieve this, you will inevitably run into…
The TEXTJOIN function offers a convenient way of concatenating values whilst separating them according to a specific delimiter.
Perhaps you are carrying out an audit or keeping track of a project in Excel. Datestamps and timestamps are bound to come in handy. Instead of manually entering the current date and/or time, use the following: • Ctrl + ;…
Excel is the behemoth of the spreadsheet kingdom. Across the length and breadth of every nation, it reigns supreme. As the market leader, the program has enjoyed a long stranglehold on its competition since dethroning the now-defunct Lotus 1–2–3 in…
It’s fair to say that Excel formulas are becoming like a programming language. Over the past couple of years, Microsoft has fundamentally changed Excel’s calculation engine and introduced a set of functions that allow us to construct formulas to do…
A few months ago I encountered a scenario I hadn’t faced before. I was dealing with a large number of financial transactions from multiple bank accounts that were being housed in separate Excel worksheets. I needed to consolidate them so…
