• Home
  • About
  • Full List

Stuff Accountants Like

This blog is dedicated to stuff that accountants like

Feed on
Posts
Comments
« #3 Quoting FASB
#5 Coffee »

#4 Excel Formulas

Jan 16th, 2009 by pfi

Excel FormulasThis one shouldn’t come as a suprise at all: accountants love excel formulas. Formulas are wonderful things that can update fields, add amounts, and solve equations. Once it’s entered in, all an accountant needs to do is copy it 200 times and the work is done.

If you were to approach an accountant at work, you will find multiple excel spreadsheets open. Even more spreadsheets can be found if they have a dual monitor setup. Accountants feel more comfortable with Excel than most things in their lives.

The beauty of Excel is that even when all the work is done in Excel and checks out, accountants can spend as much time formatting the work for presentation as they did creating the work. Spare functions in Excel such as drawing arrow objects, highlighting cells, and formatting decimal places bring pleasure to accountants as they seek to wrap up their work.

It doesn’t matter that what they have been working on is nothing new and that there are endless templates available for them to use. The time spent working with formulas and formatting a workbook is a precious way for an accountant to express their investment of time.

Tags: #4, Excel Formulas

Posted in List

5 Responses to “#4 Excel Formulas”

  1. on 29 Jan 2009 at 8:12 am1PwC IT Nerd

    Ah…. something that accountants and IT nerds can agree upon. Excel is irreplaceable.

  2. on 29 Jan 2009 at 10:42 am2Gwendolyn

    Excel understands me. I somewhat understand it.

  3. on 30 Jan 2009 at 9:18 am3Shannon

    Love it!! I’ve been referred to before as “spreadsheet queen”. I would go into withdrawals without it and by chance, I happen to have it open right now 😉

  4. on 30 Jan 2009 at 12:24 pm4skipadoo

    =sumproduct ftw!

  5. on 31 Jan 2009 at 4:21 pm5Smee

    Excel is great, but let’s not forget acellerated depreciation and bonus depreciation. It is a way to look back and say, hey I can’t believe it’s already been six years since we put that appliance on the books and already it’s been fully depreciated. It feels like only yesterday. 27 and half years is far too long.

  6. on 02 Feb 2009 at 8:16 am6I should be working

    Excel even tells me where to go for lunch!
    =INDEX(B2:B65000,ROUNDUP(RAND()*COUNTA(B2:B65000),0),1)

    (put your list of choices in column B starting in the second row)

  7. on 03 Feb 2009 at 4:01 pm7Lucky Staffer #13

    The best thing about excel: the “Comments” box. You can hide all sorts of goodies there!

  8. on 22 Feb 2009 at 1:46 pm8Leslie

    Repeat after me (like a mantra):
    Excel is my friend. Excel is my friend…

  9. on 02 Mar 2009 at 12:40 am9Stuff Accountants Like » Blog Archive » #24 Softcopies

    […] love working in Excel, and they didn’t get this way sorting a thousand rows by hand. You can thank softcopies for […]

  10. on 05 May 2009 at 8:03 pm10Bobby uno

    This is so true. We also use Excel to scare off non accountants, all we have to do is tell them why we needed Excel 2007 (I have one spreadsheet open right now with over 600,000 rows).

  11. on 10 May 2009 at 11:29 pm11Stuff Accountants Like » Blog Archive » #39 USB Keypad

    […] surprises here – anything that allows an accountant to use Excel more efficiently is beloved by accountants. Among the jumble of mice, keyboards, AC adapters, […]

  12. on 02 Nov 2009 at 12:18 pm12Spreadsheet Nation

    […] designed to compare other spreadsheets.  Surprisingly, excel formulae only made it to #4 on the “Stuff Accountants Like” blog (#1 is Not Sleeping – sadly, the blog itself has recently gone to sleep).  And since I […]

  13. on 23 Mar 2011 at 11:09 am13Hillbilly

    Working with of those right now

  14. on 29 Nov 2012 at 12:43 am14Paul

    In English, the plural of ‘formula’ is ‘formulae’.

    Did anybody mention that accountants, particularly, love pedantry?

  15. on 24 Mar 2013 at 3:24 pm15Saint Del

    So all the excel masturbatory stuff I’ve been feeling guilty about all these years just means I’m normal. For an accountant, anyway. Should be a relief, but somehow I’m disappointed.

  16. on 16 May 2013 at 2:26 am16EEK

    “Accountants feel more comfortable with Excel than most things in their lives” – SO TRUE!!!

    Love your posts :).

  17. on 19 Nov 2013 at 7:12 am17J.F.

    LOL! As I’m reading this I look down and I have no less than six excel sheets open, and it’s the beginning of the day! Love this blog!

  • Subscribe via email

  • Links Accountants Like

       FASB

       IASB (IFRS)

       PCAOB

       SEC EDGAR

       Updates for Becker CPA

      CPE Renewal Requirements

  • Etc.

  • Contact

    E:
    stuffaccountantslike [at] gmail [dot] com

    F:
    Become a Fan on Facebook

    T:
    You should follow @accountantslike.

Stuff Accountants Like © 2025 All Rights Reserved.

Free WordPress Themes | Fresh WordPress Themes