Top 10 Excel applications

francescoG

New Member
Joined
Sep 6, 2006
Messages
1
I'm researching the Top 10 business applications deployed using Excel/VBA across all industries. If you have a moment, please submit your Top 10 based on your own personal programming experience.

Regards,

Francesco
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
I'd put amployee time sheets near the top. Almost everywhere I've worked has used Excel for time recording.
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,010
Office Version
  1. 365
A couple of ideas off the top of my head:

ad-hoc/customized reporting
financial forecasting
trend analysis
charts
survey deployment/results aggregation
matching/merging data sets (that are small enough where you don't need Access or SAS)
 

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
Here's a few thing I use VBA for.

HR process automation
Hourly Merit
Salaried Merit
Quarterly Bonus
Bench Tracking

HTH
Cal
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014

ADVERTISEMENT

If you're really, really sweet to Miss Tracy (aka starl) in a PM she might give you some feedback on the most frequently-appearing kinds of projects Mr. Excel's consulting gurus get called in for. I would think that Tracy would have one of the best views of anyone anywhere as far as where Excel gets applied.
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,974
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
aw, Greg, how sweet.
but to tell you the truth - I'm seeing a lot listed here.... can't think of anything new to add
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014

ADVERTISEMENT

Kind of a different interpretation of your question -- it's not really an "application" per se. But I would have to say that Excel's most common usage is as a "generic list exchange" application. You can take any old list of whatevers -- part numbers, model numbers, invoice numbers, PO numbers, Airwaybill numbers -- and e-mail to vendors, customers, whomever and they can open it and use it; i.e. dump it into their system and/or run a query of some type -- Qty On-Hand, List Prices, Invoices Open, PO ETA's, Tracking Info; and then return it to you with the data you were needed appended to it. That's probably how most of my co-workers use Excel. Only folks that get beyond the novice stage use it to "develop an application" or to crank meaningful analyses.<hr />

Hiya, Miss Tracy! :biggrin:
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
producing + storing, invoices
comparing telephonerates (50 calls to here, 20 to there, 3 minutes each, afternoon)
stockmanagement
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,974
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
I've had clients show up with letters in Excel.. certain areas linked to ranges..
we end up moving those to Word tho.
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
I've had clients show up with letters in Excel...
-starl

:LOL: Were they preparing their financials using tables in Word? :LOL:

<hr />

Back to the topic at hand (so as not to worry Erik :biggrin:) -- I'm starting to play with its XML stuff a bit. While not a mainstream usage of it today, I would think that in the future that might be an area where Excel will get used more.
 

Forum statistics

Threads
1,137,294
Messages
5,680,654
Members
419,923
Latest member
Kalthus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top