Glen Feechan
66 followers
66 followers
Posts
Post has attachment
Merry Christmas...
Merry Christmas...
notjustnumbers.co.uk
Post has attachment
Excel Tip: Use the HYPERLINK function to link to a cell on another worksheet
The HYPERLINK function can be very helpful in Excel for creating multiple links to websites, other documents or cells in the current document based upon cell data. You can create a static hyperlink without it, but if you have a list of URLs or file paths, t...
Post has attachment
Excel Tip: How to evaluate individual parts of a large formula.
Just a short but very useful tip this month. But before we start, I'd like to thank those readers who donated to Macmillan Cancer Support when I ran the Great North Run earlier this month. All donations are much appreciated and the page is still open for a ...
Post has attachment
Excel Tip: An introduction to SUMPRODUCT and why you should learn it
Let me start with an apology for leaving it so long without a post. It's been a busy time work-wise and, in addition, I've taken up running to finally lose the excess weight and run the Great North Run half marathon next month. After spending the last 20 ye...
Post has attachment
Excel Tip: Case-sensitive COUNTIFS and SUMIFS
I have covered both SUMIFS and COUNTIFS in earlier posts. To recap: You can use COUNTIFS to count the instances of a value in a range, e.g. =COUNTIFS(A1:A100,"H")  will count how many cells with value "H" there are within the range A1:A100.  You can also ad...
Post has attachment
Excel Tip: Setting the print area and page breaks
In this post I want to touch on a topic that I've not written a lot about on this blog - printing. There are many settings in Excel that you can use to influence what is printed, and I'm sure I will revisit this topic to cover some more of them soon. In thi...
Post has attachment
Excel Tip: Ensuring that dropdown lists start at the top (and Merry Christmas)
Before I start this post, I must first apologise for the lack of posts over recent months. After returning from my summer holidays, my workload hasn't really eased (which isn't a bad thing), and my blogging has suffered. I wanted to get an (albeit short) ti...