PDA

View Full Version : Full-On Technology Phobia - Long



SiouzQ.
9-17-16, 9:47am
Yes, it's rearing its ugly head and totally stressing me out at my new job. I am having a really hard time with Excel Spreadsheets, which is what the gallery inventory and daily sales uses. Here's the back story, going way back - I have always had a math and technology phobia ever since I can remember. I have horrible recollections of my dad yelling at me in frustration while trying to explain my math homework to me when I was growing up; it even dissolved into a broken dish and me getting slapped at some point while I was in high school. I took only the math I needed to graduate and have never looked back. Then computers came on the scene. I can do the basics but am pretty shaky on things requiring much more than that. However, I did sort of set up an inventory system for my jewelry using Open Office Spreadsheets but I only use the Auto-sum formula and nothing else. It is so NOT fancy; I have no idea about any of the other formulas or how to link them between tabs.

Fast-forward to new job: I got very little training. The training I got came on day three of arriving to New Mexico after a 1500 mile , three and half day trip in which I upended my entire life as I knew it. The training lasted about maybe three hours - I was shown how to do sales transactions, and then spent a bit of time inputing about three weeks worth of daily sales into the inventory spreadsheet and daily tab. I caught on after a fashion just by rote, but had very little or no understanding of how the program's formulas work. All goes fine until I somehow lost the formulas in the particular cells, and I keep doing it. The new boss was kind of okay about it at first, but there is something I am doing (or not doing) that I keep screwing up and he keeps explaining it, and is getting more and more frustrated at me, which in turn raises my anxiety level to the point that my brain literally shuts down and NOTHING he says makes sense.

The problem is he is in Albuqerque and I am 45 minutes away. I cannot seem to grasp what he is trying to tell me over the phone as he is telling me how to fix (for the umpteenth time) a stupid mistake I've made. And it makes me feel really, really stupid and mortified that there is something I am not grasping about this program and it is the same problem. The first few weeks I was here we were open 7 days a week and it wasn't an issue, but for the last two weeks we've been closed on Wednesdays and I was never really taught how to deal with the closed day on the spreadsheet. I am a monkey-see, monkey-do kind of learner; I need to SEE someone do it several times and then I NEED to do it over and over before it sinks in as to what is being accomplished. Doing it over the phone for me is way too abstract and I end up clicking on the wrong cell, or don't understand exactly what the formula is to be typed it in. When I hear him get angry at me I end up almost in tears. It's already been a difficult first month anyway, none of which is my fault AT ALL, but I think his frustration at things not going smoothly these past few weeks is a little high. My employers are generally really pretty great, but the co-dependent in me doesn't want to make waves, wants to smooth everything over, etc, etc.

The first month for me here saw all this: hot water heater and plumbing issue, resulting with about a week of no hot water, the propane tank needs replacing, the new refrigerator I bought for the place ended up being defective and he ended up having to haul it back to Santa Fe and bring me a new one last week, then there was a town municipal water crisis this week that had the all the water shut off twice for several days in a row (that got a little dicey for me, as I have no bathtub to fill with water in order to flush the toilet - I filled up all the buckets I could find and still started running out, as it takes A LOT of water to fill a toilet tank up enough to flush. Luckily, there are public restrooms for the tourists up the street). I haven't had a shower in days, but it is finally fixed so I will take one this morning...

So anyway, back to the spreadsheet issue - I have been totally stressing out about it since yesterday because I had called him on Thursday BEFORE I did anything to make sure I was closing out the previous day's numbers correctly. I thought I understood what I was supposed to do, but when I went to do it, I somehow screwed it up and lost the formula and I DON'T KNOW WHY OR HOW TO GET IT BACK, YET AGAIN! Every time I try to fix it the way he showed me it's like going down the rabbit hole and floundering in the dark until I am so befuddled and anxious I can't do anything but walk away. I so dread having to call him today, I do NOT want his weekend to get screwed up again, and I feel incompetent, even though I know I am competent in so many other ways.

I am not quite sure how to handle this - I may call the wife part of the team this morning and apologize and explain why I am having so much trouble and discuss ways in which to fix the immediate issue and my problems with understanding the program. I know that if I got more hands-on training it will eventually dawn on me how to fix a mistake when I make it. I do not want to make excuses for myself, but I have a different learning style when it comes to this and these are two people who have had long careers in banking using numbers and spreadsheets for thirty-odd years each. I have never really had to learn this program, let alone over the phone in abstract. I equate it to being dropped off in rural China and to be expected to be able to navigate my way out with absolutely no experience in the language.

What do ya'll think I should do? I can let the daily sales pile up for a little while but at some point soon I will have to enter items sold in the inventory and close out each day's sales. Like I said earlier, it goes fine until we are closed for a day and then I have to resume inputing info on the next sale day, if that makes any sense. I know I need to take the emotion out of it and let them know I still do not understand what I am supposed to do. It just makes me feel so STUPID to keep ending up with the same problem, two weeks in a row! Can you tell I am stressed out? I have a hard time turning it off because I just want things to go smoothly and I blame myself and my lack of knowledge in this area - and believe me, I have even called the guy who used to run the gallery (who had moved away before I even got here) to have him help me. It would have been much better if he had been around to train me instead of being thrown into the job and attempting to figure it all out myself. Without any training I have had to figure out how to add new artist's work, search for blank consignment forms on a very disorganized file system on the computer, make a bunch of orders, rearrange the whole sales floor, make sure all the items and artwork are tagged with the artist's name (ya think?). The whole place is pretty disorganized but I am getting a handle in it...other than the computer glitch I am having I think I am doing a good job so far.

catherine
9-17-16, 10:00am
Two thoughts:

There have to be Excel-fluent people in your town. Is there any way you can ask for in-person help from someone in town without getting into privacy issues? I would assume the functions for sales would be a pretty universal Excel function. Someone other than the owners who could actually sit with you dispassionately would probably be better trainers for you at this point.

IF that's not possible, how about sucking it up and going back to your employer JUST one more time with the following tools:

a) a desktop sharing program like glance.net so that you could watch him do it remotely again.
b) Then maybe you could do your own video on your phone during the phone training, or even take still shots of the formulas.

Don't worry--you are not stupid!! Just heavy on the RIGHT brain! This week I had a similar thing where I felt really stupid having to ask several times how to connect to a certain web-based program so I could conduct an interview and at one point I was panicking because I didn't think the Webmasters had posted the interview live yet, and there were only 2 minutes to go and as it turned out I simply hadn't clicked on the session, which was obvious to everyone but me.

So it happens to all of us--don't let your employer intimidate you! He's being a jerk.

LDAHL
9-17-16, 10:11am
You might consider posting questions on a site like http://www.excelforum.com/ . It's set up along lines very similar to this one.

JaneV2.0
9-17-16, 11:14am
Also, invest in a class and/or an Excel for Dummies book to build a foundation for the long haul--so that you'll really understand it, and to avoid the panicky mental block next time. Good luck with this--it's just a bump in the road!

pinkytoe
9-17-16, 11:24am
I completely sympathize as I have an artist's brain too. I used to fake it a lot at work with Excel but found myself in similar binds trying to do formulas. I often created duplicate spreadsheets to play around with so that the originals didn't get screwed up. I would take one thing at a time and redo until I figured it out. I think at some point I would just flat out tell the owner that you need more training face to face if you going to succeed. He has invested a lot in your showing up, so he is bound to invest some more time to make it work. If he works with artists, surely he understands that many of them don't have high spreadsheet skills.

ApatheticNoMore
9-17-16, 11:42am
lso, invest in a class and/or an Excel for Dummies book to build a foundation for the long haul--so that you'll really understand it, and to avoid the panicky mental block next time.

yea one way to counter the phobia may be realizing this stuff can be learned step by step, and it all makes sense if done that way. It's not unfathomable, it's step by step learning the skills, bit by bit. That's the long run.

Now of course there are other problems: being thrown in the deep-end, employers probably highly personalized uses of Excel, etc. (a class isn't necessarily going to make one's employers uses clear even though Excel not being a mystery would help greatly). So yea may need to ask for lots of help.

razz
9-17-16, 11:57am
Forgive yourself for not being perfect. None of us is. I have to read about something new and then have a demo and then practice it several times before being able to be fluent. That is how I learn.
When those who are familiar with an action, they do not realize that they are assuming a level of a knowledge about an operation that the learner does not yet have.
You have the power to protect yourself from feeling so stressed. Start by reading about it as suggested above in a Dummies book. Get someone to explain the parts with which you are puzzled and then do some demo versions. Often libraries can help here or suggest someone who may. Online may have simple step by step courses.

YOU ARE NOT STUPID so don't let anyone make you feel that way. You are a smart, courageous, capable and creative person who is making a lot of changes in your life. I believe that it takes an average of 6 months before most people truly understand a new position of employment and that means just the job itself not everything else that is happening in your life.
Hang in there it will come together.

nswef
9-17-16, 11:58am
Siouz, The adv ice about Excel for dummies and doing it step by step on a copied actual spreadsheet sound like a plan. But, notifying your emotional, not very good teacher boss about needing a class or real life hands on instruction is also something that should make it better. Only a month and you have already done so much and put up with so much. Good computer teachers are hard to find, they don't know how to break things down into step by step because they have always done it...You are NOT STUPID!!!! I am sure it will make sense sometime soon. Good luck and try not to stress...think about how your legs and feet and back feel! And that you won't need to go through a Michigan winter! And you have hot water now!

JaneV2.0
9-17-16, 12:38pm
Have the boss write step by step instructions, with brief explanations. Then read a book, look at YouTube videos, etc. until it makes sense to you.

SiouzQ.
9-18-16, 10:45am
Alls well that ends well - I message the wife part of the team yesterday with my lament and she was totally cool - she wanted me to emailed her the spreadsheet and honestly, I had to think through the steps for a little bit as to how to make that actually happen technology-wise (I copied the portion of the a week's worth of the spreadsheet and sent it as an attachment in an email). She looked at it and told me to not worry about the formulas and all I had to do was MANUALLY type in the daily sales totals vs. the cost of goods and put in the difference! SIMPLE AS THAT! Yeah, I know the program is acting like a big calculator but for right now it is way simpler for me to do it the analog old-fashioned way!

They are both going to be in town two weekends from now and I'll have her fix it and show me how to do the formulas then and I will do ten times in front of her until I have the mental memory and notes to back me up if I screw it up ever again.

I like that she totally understood why I was so stressed out and flumoxxed - she equated it to someone handing her a guitar and expecting her to be able to play Stairway To Heaven right of the bat.

rosarugosa
9-18-16, 1:48pm
I'm glad it looks like you have a solution! I was thinking it would be helpful if one of them could watch what you are doing to find out where you are going astray.

nswef
9-18-16, 1:57pm
Yay!

Kestra
9-18-16, 2:23pm
I don't know if they want to spend money on this but I like a software program called Snagit, which I mostly use for screenshots but also does video screen capture so you could have little videos of the right steps to refer to over and over. Though I believe there is a free trial so you/they could just use that, get the videos and not purchase.

Very useful for visual learners and it's not easy to describe steps in Excel with only the written word.

ETA - you can also dictate what you are doing while doing the video capture.

Mary B.
9-18-16, 4:18pm
Alls well that ends well - I message the wife part of the team yesterday with my lament and she was totally cool - she wanted me to emailed her the spreadsheet and honestly, I had to think through the steps for a little bit as to how to make that actually happen technology-wise (I copied the portion of the a week's worth of the spreadsheet and sent it as an attachment in an email). She looked at it and told me to not worry about the formulas and all I had to do was MANUALLY type in the daily sales totals vs. the cost of goods and put in the difference! SIMPLE AS THAT! Yeah, I know the program is acting like a big calculator but for right now it is way simpler for me to do it the analog old-fashioned way!

They are both going to be in town two weekends from now and I'll have her fix it and show me how to do the formulas then and I will do ten times in front of her until I have the mental memory and notes to back me up if I screw it up ever again.

I like that she totally understood why I was so stressed out and flumoxxed - she equated it to someone handing her a guitar and expecting her to be able to play Stairway To Heaven right of the bat.

She sounds like someone who really appreciates you!

i have one other suggestion, and that is, once you have the formulae sorted out, to save a copy of the spreadsheet and call it something like "Sioux Q's Formula Backup Spreadsheet." That way if anything happens to the one you're working with, you can copy and paste the formula from your backup to the real thing. When I do things like this, I format the colour of my backup to something ridiculous so I know it's not the real thing -- edit/select all/fill in some color or other. Safer!

jp1
9-18-16, 4:28pm
A bit of help I'd suggest, have them lock the cells that have the equations in them so that you can't accidentally type over them.

Also, someone else mentioned this as far as practicing, but I'd suggest using it as part of your daily routine. Make a copy of the sheet, do the days work in the copy. If you finish successfully then it becomes the original. If you mess things up throw it in the trash, go back and make another copy of the original and start over, again doing your work in the copy. That way you don't have to stress out if things go wrong. You just start over.

Mary B.
9-18-16, 10:47pm
A bit of help I'd suggest, have them lock the cells that have the equations in them so that you can't accidentally type over them.

Also, someone else mentioned this as far as practicing, but I'd suggest using it as part of your daily routine. Make a copy of the sheet, do the days work in the copy. If you finish successfully then it becomes the original. If you mess things up throw it in the trash, go back and make another copy of the original and start over, again doing your work in the copy. That way you don't have to stress out if things go wrong. You just start over.

jp1, that's a terrific idea, and would ensure that you always had a backup, too. You'd only lose one day's work if anything happened to the file you were working on.

KayLR
9-19-16, 2:49pm
Mary B's suggestion is excellent; I was going to suggest the very thing! I'm sure the more you use it, it will become easier for you! Just stay positive about it!

Float On
9-19-16, 3:28pm
So glad the wife was helpful. Excel is easy....but not. Especially if you write over a formula. YOUTUBE is so helpful. I imagine you are keeping track of consignment sells as well and may even have different rates for different artists. Maybe you and the wife could sit together and write a written manual to keep on file until they discover something like masterpiece manager point of sale system.

lhamo
9-19-16, 10:24pm
It sounds like you will get the hands on training you need when they come out for the weekend visits, but if not, although it would be a pain, I would suggest that you consider driving the 45 min each way to Sante Fe to get the in person interface. I am actually pretty good with excel, but found it VERY difficult/frustrating when people in our Controller's office would want to talk through a complicated spreadsheet -- I am not good at linking up the verbal instructions with the visual format of the spreadsheet, somehow. I can deal with it better in face to face interactions, where I can watch someone using the spreadsheet. Or from very precise written instructions. Do not deal well with people explaining to me over the phone, though.

SiouzQ.
9-20-16, 10:05am
Yes, that's it exactly, for some reason my brain cannot process the linking up of verbal instructions over the phone to the visual spreadsheet in front of me, it's like I have a learning disability in that regard. Case in point, I had to call Quicken support last week because all of the sudden I couldn't get the program to link up and download transactions from my bank and it was the same thing - someone on the phone (with an accent, no less) trying to walk me through all these different computer steps that took me so far from the original task that I got completely lost and floundering down in the rabbit hole. I could tell she was getting impatient with me as well. I've always known I am a monkey-see, monkey do kind of learner, and repetition is very, very important.

JaneV2.0
9-20-16, 12:23pm
Try YouTube, or one of those instructional programs that you can refer back to. And overlearn it until it's second nature.

iris lilies
9-20-16, 12:57pm
I operate at a below Basic level on Excel, but it annoys me that too many people use Excel for functions that are truly database management. Why Does no one use MS Access? makes me crazy. Not that i know Access, but I would be willing to learn the basics.

Regularly I work with spreadsheets someone else has put together in Excel when there are no cell formulas or no math
computations, in other words no NEED for spreadsheet functions.

A few weeks ago I was trying to fix up a spreadsheet that someone made, a map of beds in our community garden. i couldnt figure out how to make them a different size without affecting some f the borders.

DH stepped in, reached back in his reptilian brain for past experience with VisiCalc, and made the changes I needed. GO DH!!!

who here remembers VisiCalc? Haha.

Mary B.
9-20-16, 1:35pm
I operate at a below Basic level on Excel, but it annoys me that too many people use Excel for functions that are truly database management. Why Does no one use MS Access? makes me crazy. Not that i know Access, but I would be willing to learn the basics.

Regularly I work with spreadsheets someone else has put together in Excel when there are no cell formulas or no math
computations, in other words no NEED for spreadsheet functions.


iris lilies, I think it's likely because at least historically Access doesn't come with the Microsoft Office package -- you get Word, Excel and PowerPoint, and maybe Outlook, but not Access. It is definitely easier for text-based record keeping. But you used to have to buy it separately, and it cost quite a few $$, and Excel kinda works...

ApatheticNoMore
9-20-16, 2:11pm
It sounded to me like it would be a program that might (don't have all the details) be better implemented in a database or another program than in Excel. But that is neither here nor there, if a company uses Excel then have to learn some Excel. The using Excel when a database would be better is kind of one of those widespread problems. Not coming free is definitely an incentive to use what does come free, and maybe accountants prefer Excel, I.T. prefers databases.

JaneV2.0
9-20-16, 2:40pm
I had a co-worker who used Excel for everything including word processing. She was Chinese; don't know if that influenced her choice.

iris lilies
9-20-16, 2:43pm
It sounded to me like it would be a program that might (don't have all the details) be better implemented in a database or another program than in Excel. But that is neither here nor there, if a company uses Excel then have to learn some Excel. The using Excel when a database would be better is kind of one of those widespread problems. Not coming free is definitely an incentive to use what does come free, and maybe accountants prefer Excel, I.T. prefers databases.
Im sure it is what Mary B says, people,use what they have.

another Excel spreadsheet I am working with is one drafted by our neighborhood crime patrol that lists street lights that are out. This is definately content in need of database application, but here is it, in Excel. I guess that for very simple lists with multiple fields f data, Excel is fine if not optimal.

I slipped into the bad habit and listed all of my iris plants and lily plants in excel spreadsheets. But back in the day when I was making book lists, I used some kind of database software, dont remember what it was.