Anyone use Excel in their work?


  #1  
Old 03-08-06, 10:38 AM
wannabefree's Avatar
Member
Thread Starter
Join Date: Mar 2006
Location: Southwestern PA
Posts: 13
Upvotes: 0
Received 0 Upvotes on 0 Posts
Anyone use Excel in their work?

I am a secretary, by trade (Administrative Assistant, now) and have been out of the workforce for many years raising my kids. I've worked from home to keep up my computer skills and have even developed some new computer skills, but I haven't developed Excel.

Seems every Administrative or Clerical job now requires expert Excel skill.

Can you please give me an example of what employers use Excel for? I know they use it to make pie charts, but beyond that, why is it so in demand as a skill?

Thanks a bunch!

-Jean
 
  #2  
Old 03-08-06, 02:51 PM
Annette's Avatar
Member
Join Date: Aug 2003
Location: Midwest
Posts: 4,017
Upvotes: 0
Received 0 Upvotes on 0 Posts
OMG! Excel is awesome! if you have it on your computer, just open it up, get a blank spreadsheet open & start playing around with it. you'll love it too in no time! it's mostly used for spreadsheets, although charts & graphs are done on it, too, by pulling the information automatically from your data in the spreadsheet!!! it's so easy. anytime you need to type columns of something, it's easier in Excel. you can highlight blocks of data & move them anywhere. whereas in Word, you can't do that sort of thing. it's also great for any kind of form or sign. you could actually type a letter on it, if you had to, but mostly it's just great for columns & numbers, like an address data base or phone list. you will probably use it more than you will Word. it's just so versatile.

if you have it, just open it up. it's very very user friendly. you'll figure it out just from playing. or, if you have something already in Excel, open it up & look at it. click on each box & see what the formula was or how it's formatted. you'll see that you can just enter a column full of numbers & by using the Sum function, you'll get a total instantly. you can do the same for rows of numbers. it's just so cool. play with it & post any specific questions you have!
 
  #3  
Old 03-08-06, 03:13 PM
J
Member
Join Date: Sep 2002
Location: welland ontario
Posts: 7,895
Received 477 Upvotes on 393 Posts
http://www.mrexcel.com/

Anytihng you want konw or ask about excel can be found here.
 
  #4  
Old 03-08-06, 03:14 PM
2x2's Avatar
2x2
2x2 is offline
Member
Join Date: Aug 2005
Location: Canada
Posts: 240
Upvotes: 0
Received 0 Upvotes on 0 Posts
Excel

Excel has a formula for quick additions if you need it
you can multiply, divide ,subtract there is a hidden formula for each
Access is good you can make up a chart for most anything
keep track of certain bills

I run office 2000 it doesn't have a product key like 2003

2
+2
---
=sum(3a:3b)
4
 
  #5  
Old 03-09-06, 06:20 AM
W
Member
Join Date: Feb 2006
Location: USA
Posts: 6,345
Received 60 Upvotes on 52 Posts
Smile Excel

I am a retired administrative manager for a large company which had a plant in my town.
We used Excel almost exclusively to do all of our finanacial reporting. It has a vast array of formulas which can be used for various types of calculations. These formulas make use of algebraic logic.
If your software includes a tutorial. take the time to go through it. It will help tremendously.
 
  #6  
Old 03-15-06, 01:07 PM
C
Member
Join Date: Apr 2004
Location: Ontario Canada
Posts: 1,694
Upvotes: 0
Received 0 Upvotes on 0 Posts
I use it for comparative calculations:
I have fixed numbers and apply formulas to them to get the output numbers I would like, or I can use it to experiment with formulas. Sometimes monetary and/or time values (to track prices over time, and compare various forumlae against each other), and sometiomes other things, for engineering and whatnot.

I use it as a ledger, to track my ingoing and outgoing funds, and to project spending and earning (or the funsd I need to add to my acount to not come out in the red).

I also use it as a simple table cell data organizer, charting wiring pinouts and things, kind of like a database with no filtering or sorting.
(I used that to organize connector wiring data when I made my A/V switcher).
 
  #7  
Old 03-15-06, 08:24 PM
R
Member
Join Date: Oct 2005
Location: Fruit Heights, Utah
Posts: 280
Upvotes: 0
Received 0 Upvotes on 0 Posts
Excel is one of the best programs ever! About a month ago, my company left it behind for some crap program called open office.
 
  #8  
Old 03-15-06, 08:27 PM
R
Member
Join Date: Oct 2005
Location: Fruit Heights, Utah
Posts: 280
Upvotes: 0
Received 0 Upvotes on 0 Posts
Originally Posted by Annette
OMG! Excel is awesome! if you have it on your computer, just open it up, get a blank spreadsheet open & start playing around with it. you'll love it too in no time! it's mostly used for spreadsheets, although charts & graphs are done on it, too, by pulling the information automatically from your data in the spreadsheet!!! it's so easy. anytime you need to type columns of something, it's easier in Excel. you can highlight blocks of data & move them anywhere. whereas in Word, you can't do that sort of thing. it's also great for any kind of form or sign. you could actually type a letter on it, if you had to, but mostly it's just great for columns & numbers, like an address data base or phone list. you will probably use it more than you will Word. it's just so versatile.

if you have it, just open it up. it's very very user friendly. you'll figure it out just from playing. or, if you have something already in Excel, open it up & look at it. click on each box & see what the formula was or how it's formatted. you'll see that you can just enter a column full of numbers & by using the Sum function, you'll get a total instantly. you can do the same for rows of numbers. it's just so cool. play with it & post any specific questions you have!
A sample Annette spreadsheet....
Shoes
1
1
1
1
1
1
-------
=sum(a1:a6)
6
 
  #9  
Old 03-16-06, 04:22 AM
mattison's Avatar
Member
Join Date: Mar 2003
Location: Cinti, OH
Posts: 5,315
Upvotes: 0
Received 0 Upvotes on 0 Posts
Originally Posted by Rapture
A sample Annette spreadsheet....
Shoes
1
1
1
1
1
1
-------
=sum(a1:a6)
6
I think you're underestimating that number.

Wannabefree: Excell isn't rocket science so don't be intimdated by it. It can do wonders for a spread sheet.
 
  #10  
Old 03-17-06, 02:29 PM
C
Member
Join Date: Dec 2005
Posts: 19
Upvotes: 0
Received 0 Upvotes on 0 Posts
Additional Uses

Jean, Everything said previously is very true. However, it can also be used for data. An example of a great use is names and addresses. You can build a list (database) of addresses of customers, or a Christmas list. For business or personal use.

A hint for the spreadsheet is the "Columns have alphabetic characters at the top. The rows across have numbers across. You can see from Annette's shoe spreadsheet it refers to a:1...a:6......
a:1 is the cell or a position located in the first row, and the first column.
a:6 is the cell in the first column but the 6th row down.
Once you are half way proficient with excel you can do a mail-merge. You can send a letter, notice, or a spreadsheet to hundreds of people or companies with just a few clicks. Prints the letter with individual names and addresses and will even do your envelopes.
Good luck.
 
  #11  
Old 03-17-06, 11:38 PM
C
Member
Join Date: Mar 2006
Posts: 3
Upvotes: 0
Received 0 Upvotes on 0 Posts
Red face Excel ... what its good for....

Hi Jean,

Excel is an excellent tool for manipulating numbers, in business, this usually equates to dollars or product quantity (or both!).

Besides the obvious use of entering in data by hand it also has capabilities to retrieve data from shared corporate databases. So all this means that reports (usually run on a periodic basis) are created by running an excel spreadsheet to "crunch the numbers" into a simple summary, be it the sales for the western region, or current budgets. This then gives management the feeling that they are actually controlling their business and doing something productive! (American business is sooo screwed up! .

If you want to learn how to use Excel I suggest you go to your local bookstore are peruse the multitude of books on Excel until you find one that suits your level of understanding. Sit down with your book, PC and Excel and spend some quality time together. I donít recommend taking courses as usually the person teaching the course knows little more than you do!

Chris
 
  #12  
Old 03-20-06, 11:47 PM
I
Banned. Rule And/Or Policy Violation
Join Date: Aug 2005
Posts: 10
Upvotes: 0
Received 0 Upvotes on 0 Posts
excel has thousands of built in formulas e.g =sum(a5:c5)

i love playing around with these formulas!
 
 

Thread Tools
Search this Thread
 
Ask a Question
Question Title:
Description:
Your question will be posted in: