Profile

Cover photo
Glen Feechan
Worked at needaspreadsheet.com
Attended Castle View Comprehensive
Lives in Seaham
71 followers|5,771,087 views
AboutPosts

Stream

Glen Feechan

Shared publicly  - 
 
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...
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 wa...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
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...
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 ...
1
Tumwine Jackso's profile photoGlen Feechan's profile photo
2 comments
 
Tumwine - That depends whether you want to fix a reference when you copy it. Take a look at my post on how and when to use the dollar sign:

notjustnumbers.co.uk - EXCEL TIP: The dollar sign ($) in a formula - Fixing cell references
Add a comment...

Glen Feechan

Shared publicly  - 
 
ICAEW Spreadsheet Capability Framework - your opinions?
As you may be aware, I am a member of the Institute of Chartered Accountants in England and Wales (ICAEW) Excel Community Advisory Committee. An important piece of work that the committee has been working on is what we are (currently) calling the Spreadshee...
As you may be aware, I am a member of the Institute of Chartered Accountants in England and Wales (ICAEW) Excel Community Advisory Committee. An important piece of work that the committee has been working on is what we are (c...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: Controlling what is printed from a sheet
One of the challenges that many Excel users face, is ensuring that the printed version of a spreadsheet looks as good as it did on the screen. There are a few simple things that you need to know to help to organise what actually gets printed and how it is s...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: Merry Christmas with a quick macro to swap one colour for another
First of all I would like to wish all of my readers and subscribers, a very Merry Christmas and a Happy 2016. I know we all work hard, and I hope, like me, you all get a chance to spend some time with those you love in the coming days, whether Christmas is ...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: An introduction to dynamic ranges
A few months ago I wrote a post  introducing the use of ranges in Excel: Excel Tip: A short introduction to named ranges In that post I alluded to dynamic ranges but didn't really say much about them, so I thought I would expand a little on the subject now....
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
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...
1
Tumwine Jackso's profile photoGlen Feechan's profile photo
2 comments
 
Of course. You can subscribe to my blog posts on the blog if you like.
Add a comment...

Glen Feechan

Shared publicly  - 
 
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...
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 tr...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: Using Index to calculate a cumulative sum (e.g. a Year to Date total)
Let me start with an apology. My current workload has meant that my posts have been a lot less frequent in recent weeks. This may continue for a while, but I will still be aiming to post at least once a month during this busy spell. In this post I want to s...
Let me start with an apology. My current workload has meant that my posts have been a lot less frequent in recent weeks. This may continue for a while, but I will still be aiming to post at least once a month during this busy...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: An easier way to change cell colours
Before I begin, I would like to wish a Happy New Year to all of my readers and subscribers - as this is my first post of 2016. I am starting the year in humble mode, as I have had something very simple pointed out to me that I can't believe I had never spot...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: How many calendar months does a date range affect?
This week I responded to a client request for a formula that seemed straight-forward, but it took a few emails backwards and forwards to establish exactly what was required. My answers at each stage, provide a number of alternative versions of what appear t...
1
Add a comment...

Glen Feechan

Shared publicly  - 
 
Excel Tip: Return the formula text from a cell, rather than its value
Just a short little tip this week, due to a hectic diary. When you reference a cell in Excel, you will get its value, but what if you want to return the formula itself? Excel, as usual, provides a way to do this. Let us say that cell A1 contains: =SUM(B1:B1...
1
Add a comment...
Work
Employment
  • needaspreadsheet.com
    CEO
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Seaham
Links
Contributor to
Education
  • Castle View Comprehensive
    1987
Basic Information
Gender
Male