Excel-related articles.
Kutools is an Excel add-in with over 300 features and functions that simplify, automate, and expand on what is available natively. For example, you can: It’s the last point I wanted to pay particular attention to, as these chart templates…
Formulas can often be difficult to understand, so breaking them down makes it easier to see what each part evaluates to. This can be done by selecting a function’s argument in the tooltip, or by highlighting a specific part of…
There are numerous ways of finding the highest value in a column and returning another in the matching row. Let’s have a look at two. In the example, a table called tblSales is present on the left. Method 1 uses…
It occurred to me that I have got into a routine of highlighting all 17,179,869,184 cells and applying horizontal and vertical text alignment before proceeding with anything else. Everything just looks better that way and saves me time later on….
Yesterday (2nd July) was the exact middle point of 2022, so today (3rd July) is the first day of the year’s second half. 😯😬 It’s common knowledge that there are 365 days in a year (except leap years). As 365…
I’m pleased to say that searchable dropdown lists have finally made their way into my Excel! Now I can search for something and get a filtered list of suggestions. Previously, the only option was to rely on a stopgap solution…
End of content
End of content
