Recent comments in /f/LifeProTips

AldermanAl t1_j9aq8dv wrote

Greatest office tool of all time, but easy to be relied upon to heavily and become end user computing files that have a high risk input error. Then everything you have been reporting becomes inaccurate with one person's formula screw-up.

Always store a gold copy of any business important excel that is password protected and unable to be changed so that you can do regular comparisons to ensure the in use copy is the same as the gold.

1

bassbahl t1_j9apcke wrote

I learned through a lot of videos, reading tutorials, sort of knowing what I want, and trial and error. Yes, a lot of the videos are dry, but so are logic formulas. Honestly the simple ones are sometimes the best. Nobody yelling at me to “smash that subscribe button”.

3

ericds1214 t1_j9ao34r wrote

Beyond just spending a few days familiarizing yourself, use Excel for as much in your daily life as you can. Budget tracking, chore charts if you have kids, whatever you can think of in or out of work. The more you use it, the more you'll see opportunities to improve your Excel skills and make life easier.

1

kamilman t1_j9an2wx wrote

Can confirm. I was dubbed "Excel Guru" at one of my jobs and held this title ever since. And it was just basic stuff most of the time.

Then again, I did build a full database for disciplinary dossiers for the National chamber of bailiffs in Belgium, even built a fancy pants search sheet in the Excel file where you got all the information on a dossier by simply typing the code of the dossier (and specifying the language in case of dossiers before 2022).

But they let me go and they had cold sweats even when Excel was being mentioned, so I don't even know if my little baby is still used by them today...

1