Profile cover photo
Profile photo
Glen Feechan
66 followers
66 followers
About
Posts

Post has attachment
Merry Christmas...
Merry Christmas...
Merry Christmas...
notjustnumbers.co.uk
Add a comment...

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...
Add a comment...

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 ...
Add a comment...

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...
Add a comment...

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...
Add a comment...

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...
Add a comment...

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...
Add a comment...

Post has attachment
Excel Tip: Using Logic in Excel
Logic (particularly Boolean Logic) plays a huge rule in computer programming and circuitry, but is also very useful in Excel. It is fundamental to the IF statement which in itself is such an important tool in Excel, but has many other roles. Essentially, wh...
Add a comment...

Post has attachment
Excel Tip: Ranking numbers in Excel
Before I start, a couple of announcements. First of all, please accept my apologies for the time between posts. A combination of workload and a family bereavement have slowed me down somewhat! Secondly, if any of you will be in and around London tomorrow (W...
Add a comment...

Post has attachment
Excel Tip: Adding up columns based on multiple criteria (the SUMIFS function)
Before getting into today's post I want to point you to an excellent free Webinar being offered (for a limited time) by Mynda Treacy, entitled " Creating Excel Dashboards ". Mynda is a real expert on Excel Dashboards and her training materials are always ex...
Add a comment...
Wait while more posts are being loaded