01438 832724 sums@excel-consultant.biz
  • Facebook
  • Twitter
  • Facebook
  • Twitter
Excel Consultant
  • Home
  • Services
  • About
  • Latest News
  • Contact
Select Page
How to avoid the “nested IF” nightmare

How to avoid the “nested IF” nightmare

by David Hardstaff | Nov 12, 2017 | Spreadsheets, Tips and Tricks

Many users of Excel will be familiar with the conditional “IF” function – the plain English syntax of which is: “If something is true, do this, otherwise do this” So the formula =IF(A1=1,”Hello”,”Goodbye”) means...
When should my spreadsheet become a database?

When should my spreadsheet become a database?

by David Hardstaff | May 29, 2017 | Databases (general), Spreadsheets

Well, here’s a surprise – the answer is ‘it depends’!  However, there are some general pointers, and a couple of recent conversations I have had with people have made me think that it’s worth setting out one or two of the indicators that your business may be...

See articles about

  • Databases (general)
  • Spreadsheets
  • Tips and Tricks

About David Hardstaff

I have 35 years of business experience, in the operational sector for the most part. I have a good understanding of process, efficiency and management accounting.

I have used spreadsheets since the days of Lotus 123 and Quattro Pro, when all we had was green numbers on a black screen, so I have plenty of experience of making them work for a business.

I understand your business need first, and will work with you to find and implement the most appropriate solution.

How we work

  • 25+ years of experience
  • Operations background
  • Business Intelligence specialist
  • Business Analysis
  • Software specialist
  • All projects guaranteed

Contact

Quick human test : 7 + 1 =

  • Facebook
  • Twitter

Designed by Elegant Themes | Powered by WordPress