Google knows all lol.
excell guru's
- Thread starter toddbailey
- Start date
- Views: 2744
Google knows all lol.
Iplayfarmer
Super Member
Especially if I can spell "Excel" right.
themichelob
Gold Member
Iplayfarmer--I'm intrigued by this use of Google as a tutorial for Excel. Could you give an example of a description question you might Google, so I can try it and see the result? Thanks for the help! Regards, Mike
RoyJackson
Rest in Peace
- Joined
- Nov 17, 2001
- Messages
- 23,144
- Location
- Bethel, Vermont
- Tractor
- John Deere 4052R Cab,, Deere 855D UTV, Z920A Zero Turn Mower and assorted implements
I'll step into this one since I used Google extensively to create a couple of Access databases last year.
We'll use a simple question: "How do I sum cell values from different worksheets in an Excel workbook?"
The results of this query are shown in the attached picture.
Just select a link to start. You'll soon determine if it's pertinent and user friendly enough for your needs.
Attachments
riptides
Super Member
An interesting thing most over looked by Office Suite users is a thing called Visual Basic in Applications Mode. Google automation. If your using Excel or Access you can programatically call other Office Suite products like Visio, Excel, Word and Outlook. Then your database can draw diagrams, create Excel Workbooks, Worksheets and Charts, create Word Documents and Mail information to users. Viso can also be used to reverse engineer Access databases. Or at the very least, document them.
A real eye-opener for prospective employers is this knowledge, once VBA is mastered, calling these products from each other really can add value to a busiess or enterprise.
A real eye-opener for prospective employers is this knowledge, once VBA is mastered, calling these products from each other really can add value to a busiess or enterprise.
RoyJackson
Rest in Peace
- Joined
- Nov 17, 2001
- Messages
- 23,144
- Location
- Bethel, Vermont
- Tractor
- John Deere 4052R Cab,, Deere 855D UTV, Z920A Zero Turn Mower and assorted implements
Quite a good comment about VB...and there are many examples one can find on the internet.
One thing I had to put into one of those Access databases was an automatic e-mail notification to a group whenever a new record was saved. In this case, we were expanding our Corrective Action system to others (non-QA people) in the company and the e-mail was to notify the QA personnel
Anyway, I found a couple different examples of code I could use to enable the e-mail notification...worked quite well too!
KubotainNH
Veteran Member
OP
toddbailey
Silver Member
- Joined
- Mar 6, 2008
- Messages
- 131
- Location
- south carolina
- Tractor
- nh 3930, ford 1910, farmall super a, allis chamlers b
Spelling is one thing I am for sure not good at!
Iplayfarmer
Super Member
What Roy said.
My real appreciation of excel also began when I was QA manager at a food company. It must be a QA thing. I'm now mostly involved in Research and Development but I still use Excel a lot.
An example of a query I used recently was to learn how to insert a portion of the filename into a cell. When I put insert fileneme in excel 2007 into a google search I came up with the following page as the first result... Inserting the current Excel file name in a cell - Excel - Office.com. This page contained all the information I needed because it has a decription of how to pick out a small portion of the filename by using the MID function. Sometimes I have to combine a few searches and articles to accomplish what I want.
themichelob
Gold Member
Thanks guys!! I don't use Excel often enough to become knowledgeable--this should really help. Thanks for the replies. Regards, Mike
