Category Archives: How Excel is used at Work

Unfortunately, I don’t use Excel at my workplace but I have some basic knowledge of how to use the program.
This is someone sharing his experience with Excel:
“My experience with Excel in the workplace is that most Excel applications are developed by people whose job description includes something like ‘develop spreadsheets for use by accounting and administration departments in the company’.

For those in office support, admin asst positions, etc, the job description is pointed more towards data entry in Excel applications developed by the folks in the first group. More like a ‘database management’ thing.”

http://answers.yahoo.com/question/index?qid=20120827110457AAXTvTx

I also found some good info of why Excel is so important in the workplace:

http://ezinearticles.com/?The-Importance-Of-Excel-In-The-Workplace&id=724646

Elena Turcan

I have never had to use Excel at work, but I had the opportunity to learn some basic features of this program. This is a very helpful tool at work because it gives the opportunity to organize data at a faster and effective way.

Being Accounting my field of study I am glad I am going to get a better understanding on how to efficiently use Excel. It’s a good program for scheduling, calculations, financial reports, journal entries and a couple other things that are necessary in the organization.

Cristina Rosario

Unfortunately, none of my work asks for Excel so far. However I know it is so popular that probably being used in every company. I am happy that we will explore the Excel world.

I remember when I was taking physics, my professor gave us the Excel spreadsheets as a tool to check the homework. We can just simply check the answers of some complicated questions by typing the figures in. It is very useful at workplace and also an efficient tool to use in study.

I would like to learn more about Excel in this course and use it in my life.

Wenshi Cao

I currently breathe, eat, and sleep excel.  And still I don’t know every trick this program has to offer.  But I am completely amazed with the things that we can do and populate in this foreign formula obsessed spreadsheet.

I work for a whole sale company and I am in sales, so everything we do is through excel.  For example, we write up orders to our factories in an excel order form, it has drop down lists, and formulas already populated once you enter a quantity and a prepack amount.  I mean this is a too smart for smart people order form.  But this is the least of my excel experience…

Every Monday morning I have to run sales reports, and let me tell you, these reports are intense.  I personally, before I started with this company, only used excel for your basics : charts, some simple formulas and pictures and lists, etc…; but when I started in my new position, I got frighten on how intense my new company used excel.  I didn’t think I would last because my skill level (which I thought was a ‘7’ in a scale of 1-10, but really a ‘3’) I was nothing compared to where I needed to be.

So my sales reports are run from a ‘sumif’ formula, and tons of others.  I am able to read the formulas now, and understand them; but can’t create them just yet.  But the report runs like this:  I upload an excel format raw data (this shows how my items are selling currently for the past week on their floor) from my customers site (i.e. Target), then copy and paste the data into another excel file which is an accumulative file, and save it.  Then I open my customer’s sales report excel sheet (Target) and change a formula in a specific cell to pull information for the current week, and then ungroup some columns and make sure that the formula in that column seems accurate (this formula is the sumif formula that pulls information from my raw data report and enters it automatically in my sales report) and pretty much my sales report file is complete.

This usually takes about 10 minutes for it to be completed through excel.  If we were to do this manually, it will take me hours to search for the data on my own.  But someone, excel savvy (my boss – hence why he is my boss) managed to create this sales report file that does it automatically for us (with a little bit of human input).  Now I only hope to be able to make my excel level from a ‘3’ to a real ‘7’ after this class.

-Bianca Moura

When I was an intern at the Japanese Fashon Intermediate Agency,  I made an inventory chart by usein excel to indicate items,quantities,colors, and prices. I also made invoices for the clients using Excel to format calculations and total the bill with the provided functions included in Excel. It allows the organization of information and statictics in a way that help a business run well.

Post by Mai Moore