One thing I used to joke when I worked in IT was accounting's belief that "Anything complicated is IT." Even had a CFO who thought that we should be responsible for helping people use an application that had "Accounting" in the name. If they just see Excel's performance issues as an IT problem you are wasting your time. But someone from accounting has to be invested in figuring this out with you. Once you know where it came from you can research if there's some type of report writer that they should be using instead. Do they continually add data into Excel or are they doing a fresh export each time?.They are falling back to Excel because that's what they are comfortable with. They may already have something that would do what they need, but as you pointed out they don't want to learn anything new. I basically have to learn their job and what they do, then go out and learn what software will work with their workflow.Įdit: for those of you who don’t know, excel absolutely runs like garbage with files over 20MB I’m trying to look for the best solution, but I’m not trying to go down a rabbit hole. Users have a year worth of data in excel that they use to find discrepancies, or they use pivot tables in excel to show other members of the company data - like financials / spending etc. Have you ever encountered this in the workplace? What’s my best option to resolve this? Do I need to look at power bi, tableau, etc? I’ve already tried explaining to them that excel isn’t supposed to be used this way, but of course they keep using it that way.Īnd of course users won’t go out of their way to learn something else, so now it’s my job to figure out a solution. I have several users who are trying to use excel as a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |