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.

[Buehler445]

Originally Posted by SithCeNtZ

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.

Time is the issue. Because it is me. And fat boy has shit to do.

[CapsLockKey]

Originally Posted by SithCeNtZ

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.

Can do some real powerful stuff in Excel when you start using external data connections. I used to use Access religiously but most people aren't familiar with it. I started using Excel connecting to live data with parameters and it blows people's minds when I send them a spreadsheet and tell them it auto updates everytime they open it.