Go Back   Computer Forums > Welcome To Computer Forums .org > Social Lounge | Off Topic
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-19-2011, 09:24 AM   #1
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default The Powers Of Excel

Hey Guys and Dolls,

I return once again after a period of absence to grace you with my presence, share my knowledge and just have a good old chit chat.

My first subject being Microsoft Excel. . . . . . . WOW what a program.

First off i start by asking a question, in your opinion what d you think Excel can do as a program. If your answer is something along the lines of takes various tables of data, add them, average them report on them then your in for an eye opener.

My answer would be "just about anything".

alot of you may know this but i'm betting many don't Excel has a built in VB editor which in a sense means you can write your own programs within excel to do just about anything. I won't go into too much detail but i now have Excel interacting with the software i user at work, pulling data live from the database reporting on it and accepting user responses and in turn writing to the database.

What a tool!! I reccomend anybody that works with spreadsheets regulary to google around and research what you can do with excel VBA as you can probably make your working life ALOT simpler.

__________________

__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 09-19-2011, 09:51 AM   #2
Omnicide now.
 
foothead's Avatar
 
Join Date: May 2009
Location: My own personal hell
Posts: 10,014
Default Re: The Powers Of Excel

From the sounds of it, my dad has something pretty much identical to you. It pulls all the emission tables from the chemical plant he works at and checks for discrepancies, then alerts the user if there's anything that needs to be checked on further. It also allows the user to input specific equipment problems, and it will recalculate based on that. The whole thing is written in excel, and it manages to load up an i5 computer for about a minute when doing more intensive things. Excel isn't exactly efficient...
__________________

foothead is offline   Reply With Quote
Old 09-19-2011, 10:57 AM   #3
Fully Optimized
 
ssc456's Avatar
 
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Re: The Powers Of Excel

ha-ha now that your right about efficiency is a huge downfall with Excel.
i mean i was using 2003 and it can only use a single core to process everything.

I've upgraded to 2007 now, trying to convince the boss to make another step to 2010.
__________________
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote
Old 09-19-2011, 07:23 PM   #4
Daemon Poster
 
Legodude522's Avatar
 
Join Date: May 2006
Location: Texas
Posts: 1,303
Default Re: The Powers Of Excel

Quote:
Originally Posted by ssc456 View Post
ha-ha now that your right about efficiency is a huge downfall with Excel.
i mean i was using 2003 and it can only use a single core to process everything.

I've upgraded to 2007 now, trying to convince the boss to make another step to 2010.
For a long time I used Office 94 with Word for Windows 6.0. It did everything I needed to do and efficiently.
__________________
PC: Intel i7 4790K, 16gb RAM, MSI R7 250 2gb
Phone: Apple iPhone 6s 64gb
Handheld Games: Nintendo 3DS XL, Tapwave Zodiac 2, GamePark Holdings GP2X F100
Legodude522 is offline   Reply With Quote
Old 09-20-2011, 09:05 AM   #5
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,425
Default Re: The Powers Of Excel

Quote:
alot of you may know this but i'm betting many don't Excel has a built in VB editor which in a sense means you can write your own programs within excel to do just about anything.
I'd say this is pretty common knowledge actually It's also VBA, not quite VB - which does have a lot of limitations, and is an awful language to work with.

Back in the day (15+ years ago) it was pretty revolutionary, and it's still useful today though not so much of an eye opener. As pointed out efficiency can be, well, questionable and if I was doing any serious number crunching on a regular basis I'd probably look at other options. It is a useful skill to have however.
__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 09-20-2011, 09:17 AM   #6
Daemon Poster
 
Dngrsone's Avatar
 
Join Date: Nov 2006
Location: 'Murica
Posts: 951
Default Re: The Powers Of Excel

As the most user-friendly program in Office (as in, the only user-friendly program in Office), I've seen Excel used in many ways that would probably be better done in Access.

Personally, I used Excel for cataloging various inventories, tracking capabilities lists, arranging schedules and duty-rosters, etc. Basically everything except actual spreadshett duty (or creating text documents).

I still use it occasinally at my current job, but I hate the current Office product.

At home, I use Open Office and its Calc program, which is pretty much the same as Excel, but a lot less expensive.
__________________

__________________
Civility, Substance, Subtlety, Style: Success
Dngrsone is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Come to my website Meffert Web Design and Development | Site Reviews 5 05-09-2004 07:24 AM


All times are GMT -5. The time now is 04:12 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0