When you work with people that don't understand Excel--

Just an OMG post because I can't let out steam at work,

Work place, did an apprenticeship Lvl4 in accountancy, data analysis and forecasting work so lots on excel to the point I love the application. it's great.

in my new role I share the use of an xls with another work team and their knowledge with xls is using the find function for a persons name or identification number and adding information into the adjacent cell for that person.

I'm the only one across 3 teams that knows how to ude vlookup or anything else other than sum (and even then they use the formula function which fair enough we all need to learn somewhere but its using the formula function for sum every time without wanting to manually so its faster😪)

anyway the thing i came here to actually mention is the filter button.

this shared xls has all customer names and notes, mainly for me and my colleague but for the support of the other teams too as its all debt related.

i put a filter on to see clients under my support, then a 2nd filter to remove any with resolutions, and then a 3rd filter to remove colour coded names im not currently dealing with.

the amount of times the income team come onto the sheet and remove all filters - and i dont mean clear filters- i mean remove it off the top line in full so it removes everyone's selections and gives you the full list of people.

at first fair enough, but im currently a year and bit into the role, its something we've articulated many times in meetings not to do, and it still happens-- happened today twice within 10m

and its just frustrating more than anything, its really not a big deal but also i can't let out to anyone in the teams because all 3 teams have very limited knowledge on xls and dont want to make anyone feel bad 🥴🙏

which is so strange compared to the accountancy side where everything they do is xls and csnt survive without it

anyone else with similar experiences of what seems to be the most basic thing but its just not for some

Edit- thank you all ive created a few macros to help me get back to my place easy as pie 😊

Wanted to mention i didnt want this to come across as not understanding - i 100% understand why people are the way they are, technology constantly changing and people needing to try and keep up for it not to feel daunting, my work place has always been full of people double the age of me so I'm by no means trying to put hate on people, always enjoyed helping their understanding if I can 🖤 Just a bit frustrating when something that's been bought up in meetings many times and management supposed to support them, but it keeps happening a year later and I'm literally the only excel savvy person this department unless we go to IT or Accountancy So the lack of guidance/progression/support for myself, and then also being the best person to go to for everyone else despite it happening many times is the frustration I appreciate people understanding 😅

Im neuro so don't want this to come across as too blunt and people think I'm just being a bugger 🙏 Thank yous for help 😁