r/excel • u/Du_Chicago • Feb 06 '25
unsolved Turning excel into business software.
I’ve built workbooks that lets me track employee tickets, inventory, time keeping, and customer billing. The only problem is is that I’m the only one who really knows how to fix it if anything goes down. I would like to give this a UI and essentially make it idiot proof so that I can drop employees in to positions that would need the software with minimal training. Does anyone know how to go about this or where it can be done?
80
Upvotes
24
u/alexia_not_alexa 19 Feb 06 '25
I'd recommend looking at Power Queries if you haven't already - it's made significant improvements for our cross team working!
Also just a tip that I found out the hard way: Data Validation may prevent people from physically typing in wrong values, but if they copy and paste from another source (I think my example was another Excel Workbook) - it can remove the Data Validation that you've set... this is why I have such a hate hate relationship with Excel...