Microsoft Excel - How often do you use it?

[SithCeNtZ]

Originally Posted by Buehler445

I use that bitch every day.

A simple =(timeout-timein)*24 makes a timesheet with multiple entities a breeze.

I use vlookup in a real simple purchase unit to application unit conversion.

DaFace actually turned me on to the SUBTOTAL function actually allows you total a column after a filter has been applied. I have an incredibly reerunedly convoluted billing spreadsheet that converts a myriad of field activities to whether or not they are billable to a billion different entities.

I should be doing that asshole on a database, but it's been a billion years since I've built one and I don't want to spend the money on access.

I also have a remarkably difficult to set up but remarkably easy to operate conversion from Quickbooks report to banks cashflow statement that is pretty much a series of references.

I don't know anything about your company obviously, but storage and processing power is so cheap now that you could probably build a DB for free in something like AWS on their free tier. You'd have to learn how to use it of course, but don't let cost be a reason you don't do it.