Started By
Message
re: Who Holds the Record For Most Posts on this Site?
Posted on 12/27/14 at 12:54 am to KSGamecock
Posted on 12/27/14 at 12:54 am to KSGamecock
Our sheets show an IF function to produce a uniform material cost per pound of differing material types. Always stumped me, but that's why I'm not in estimating.
Posted on 12/27/14 at 12:57 am to OBReb6
I posted a really simple IF example, you can stack and add shite to make them more complicated. I've had formulas that were +100 characters and were needlessly complicated, the excel equivalent of jerry rigging shite and when it came time to explain it to my replacement I had completely lost myself.
My top three days in excel:
1. When I learned how to write/record macros
2. When I learned how to create pivot tables
3. When I learned how to use formulas
I went from barely being able to keep up with my work to getting my stuff done in under an hour or two each day. Excel is the shite if you can make it work for you. There are classes and stuff...wish I had gone to them. Google taught me everything but it took a long arse time because am idiot.
My top three days in excel:
1. When I learned how to write/record macros
2. When I learned how to create pivot tables
3. When I learned how to use formulas
I went from barely being able to keep up with my work to getting my stuff done in under an hour or two each day. Excel is the shite if you can make it work for you. There are classes and stuff...wish I had gone to them. Google taught me everything but it took a long arse time because am idiot.
This post was edited on 12/27/14 at 1:02 am
Popular
Back to top
Follow SECRant for SEC Football News