Not Just Numbers

Excel Tip: Managing Deadlines in Excel

noreply@blogger.com (Glen Feechan) — Tue, 21 May 2013 03:09:34 PDT

Today's post was prompted by a discussion on the accountants website, AccountingWeb. One accountant was looking for a simple way to manage client deadlines in Excel, for Corporation Tax returns,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Protecting cells

noreply@blogger.com (Glen Feechan) — Mon, 13 May 2013 22:00:00 PDT

One of my ten principles last week was to protect cells with formulae in them, and it occurred to me that it might be useful to do a quick post on how cell protection works. It is really easy to...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: My Ten Principles for Excel Good Practice

noreply@blogger.com (Glen Feechan) — Tue, 07 May 2013 00:00:17 PDT

As part of my role on the Institute of Chartered Accountants in England and Wales (ICAEW) Excel Community Advisory Committee, I (along with the other members) have been asked to share my personal...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Don't hold your data in Excel if you've got somewhere better!

noreply@blogger.com (Glen Feechan) — Tue, 30 Apr 2013 04:29:34 PDT

Just a short post this week, and a one you might be surprised by. I am going to encourage you not to use Excel! Yes, after years of telling you how to get the best out of Excel, I am going to tell...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Don't fiddle with the data!

noreply@blogger.com (Glen Feechan) — Tue, 23 Apr 2013 08:46:54 PDT

Yesterday I had a conversation with a client that I have had, in various forms, many times before. It relates to using information in a spreadsheet from an external source. Almost every time I...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Do you really need to merge those cells?

noreply@blogger.com (Glen Feechan) — Tue, 16 Apr 2013 04:40:12 PDT

Just a short one this week, along the lines of my cautionary post a couple of weeks ago on the dangers of cut and paste. When working on a spreadsheet that someone else has built, there are a...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Online Excel Training - Exclusive Reader Offer

noreply@blogger.com (Glen Feechan) — Tue, 09 Apr 2013 05:25:58 PDT

Regular readers will know that I have been working on ways to help you with more in-depth Excel Training than blog posts will allow. You can already purchase my Introduction to Pivot Tables course...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Beware - Cut and Paste IS NOT the same as Copy and Paste

noreply@blogger.com (Glen Feechan) — Tue, 02 Apr 2013 04:22:48 PDT

I hope those who celebrate it have enjoyed the Easter break. I just have a short, but very important, post this week as we ease back into work. This is a warning about the very significant...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Presenting Pivot Table data in a fixed layout using GETPIVOTDATA

noreply@blogger.com (Glen Feechan) — Tue, 26 Mar 2013 05:52:18 PDT

It's been a while since I covered GETPIVOTDATA on the blog, so I thought it was worth a re-visit, but with the specific objective of demonstrating a structured approach to populating a fixed...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Using Goal Seek

noreply@blogger.com (Glen Feechan) — Tue, 19 Mar 2013 09:56:35 PDT

Before we get into this week's post, I'd just like to say a big thank you for the magnificent response to my survey last week. I will reflect your feedback in the new training product I am currently...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Training - I need a minute of your time

noreply@blogger.com (Glen Feechan) — Mon, 11 Mar 2013 04:12:10 PDT

Hopefully you are finding my Excel tips useful and they are helping you with your daily work. This week, however, I need a little something from you. You may have seen that I do offer a small...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: INDEX and MATCH - an alternative to VLOOKUP (and HLOOKUP)

noreply@blogger.com (Glen Feechan) — Tue, 05 Mar 2013 05:03:00 PST

In my last post I described how to use both VLOOKUP and HLOOKUP to lookup and return data from lists or tables. Whenever I mention these functions in forums, etc. I usually get someone reminding...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: VLOOKUP or HLOOKUP?

noreply@blogger.com (Glen Feechan) — Tue, 26 Feb 2013 10:29:50 PST

Many of us use VLOOKUP regularly and I know I've covered it a number of times on the blog, but what about its poor relation, HLOOKUP? I regularly come across users who don't know it exists - or if...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: A simple dependent drop-down list

noreply@blogger.com (Glen Feechan) — Tue, 19 Feb 2013 06:36:58 PST

I have previously blogged about how to create a drop-down list in Excel using data validation, but sometimes I am asked to make the options in one drop-down list dependent on the selection from...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Quickly fix formulae copied from another spreadsheet

noreply@blogger.com (Glen Feechan) — Tue, 12 Feb 2013 04:04:57 PST

This week I have a simple tip to solve a very specific problem, but one that many users will encounter regularly. Many times when building spreadsheets, I have a set of formulae that do what I...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Simple tips for tidying up text in Excel

noreply@blogger.com (Glen Feechan) — Mon, 04 Feb 2013 22:00:03 PST

Although we might do our best to use data validation to ensure text is correctly entered into a spreadsheet, we very often need to deal with data from other sources that might not be well...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: How to combine multiple sets of data for a pivot table - a practical solution

noreply@blogger.com (Glen Feechan) — Tue, 29 Jan 2013 00:30:06 PST

I have written many posts about the benefits of pivot tables and how to prepare data for use in them, but there is one scenario that I haven't covered which I come up against every now and again with...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Why do I need pivot tables? - and a song!

noreply@blogger.com (Glen Feechan) — Tue, 22 Jan 2013 04:15:56 PST

Before we get to the song, I want to answer a question I am asked over and over again: "Why do I need pivot tables?" Regular readers will know what a big fan I am of pivot tables, and how they...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How to create an Excel Pivot Table

noreply@blogger.com (Glen Feechan) — Tue, 15 Jan 2013 08:37:02 PST

I am a huge fan of Pivot Tables as they can completely transform your ability to analyse and report on data in Excel and thought it was about time I did a post on them. Then I had a better idea...why...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel Tip: Using CHOOSE - or do you need OFFSET, or maybe INDEX?

noreply@blogger.com (Glen Feechan) — Mon, 07 Jan 2013 23:43:58 PST

How are those New Year Resolutions coming along now we're all back to work? Did you set your Excel ones? I'd still love to hear what they are. Just a couple of quick messages before we...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What are your Excel New Year's Resolutions?

noreply@blogger.com (Glen Feechan) — Tue, 01 Jan 2013 01:00:02 PST

I'd like to take this opportunity to wish all of my readers around the world, a very Happy New Year. To those of you in Australia and New Zealand, whose New Year's Day will already be coming to an...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Christmas is coming...

noreply@blogger.com (Glen Feechan) — Tue, 18 Dec 2012 03:14:13 PST

Everyone is subscribing to make sure they don't miss out on their exclusive Secret Santa Gift Are you all ready for Christmas? If you’re one of those people who have had all of your presents...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

EXCEL TIP: A simple cashbook - the OAP way

noreply@blogger.com (Glen Feechan) — Tue, 11 Dec 2012 04:06:25 PST

Thanks everyone for your response to last week's post, telling me what you want to learn from the blog. I've had some great input and will be including some of your requests over the coming weeks. If...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Excel - What would you like to learn?

noreply@blogger.com (Glen Feechan) — Tue, 04 Dec 2012 07:58:04 PST

How would you like a future blog post to provide help on a subject of your choosing? I am working on planning subjects for blog posts for the new year and would really appreciate hearing what you...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

EXCEL TIP: Creating a rolling graph

noreply@blogger.com (Glen Feechan) — Tue, 27 Nov 2012 02:06:00 PST

A time-taking Excel task that I see many clients accepting as necessary, is copying and pasting graph data every month to populate graphs that show a rolling twelve months. The data is copied and...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]