[jsfg_cinti] Re: Questions on Excel

A lot of questions on Excel ... if the problem requires < 4 million formulas, 
its not a challenge. I have written Excel work books that require 6 worksheets 
using all 256 columns.  For example, "Vlookup" -if the table is less than 100 
entries, use it. Otherwise, create a index formula that will take you right to 
the data cell.  If I would use "Vlookup" to access data on a large workbook, it 
would take hours to retrieve anything.  Another point -- always use check 
points.  I have few errors in Excel because I check point totals two or three 
diffent ways. If you have a quesiton - let me know.;   > From: 
mvoto45122@xxxxxxxxxxx> To: jsfg_cinti@xxxxxxxxxxxxx> Subject: [jsfg_cinti] 
Questions on Excel> Date: Sat, 14 Jun 2008 00:00:48 -0400> > > > > Good Evening 
all,> > There have been some recent posts regarding a member who had a question 
on Microsoft Excel.> > > > It wouldn't hurt to briefly mention how to resolve 
problems with Microsoft Excel. > > Getting Started: Always ensure your 
Microsoft Office software is up to date with all patches and service packs.> 
The Microsoft Office Update web site can tell you how to accomplish this. If 
you need the software and are a student at any local college, the college 
bookstore> will sell you a copy of Microsoft Office Professional for under $10. 
[This even applies if you are a part-time student at UC. ]> > Be aware that 
some versions of Excel can do things earlier version can not. Please also 
ensure your anti-virus, anti- spyware and operating software are up to date 
too!> > Trouble-shooting: Normally most of use start out using the "help" 
function and then go to Microsoft's web site for help.> If time allows, there 
are a variety of on line tutorials on Microsoft's Office website. Additionally, 
if you Google "excel tutorial"> you will find some free, well made ones on the 
web, especially on high school and college web sites. > > If you still need 
help after this, try Microsoft' forums to see if someone posted a similar issue 
before. > > Finally, you may> Google what you are trying to do and see if you 
get a hit. I did that last week at work when someone sent me a spreadsheet > 
that was unusable. I located a workaround from a source on the web, implemented 
it and moved forward. > > As you may guess, the same troubleshooting process 
applies to other software whether it be Microsoft Access or non-Microsoft 
software.> > Best Regards,> > Michael> > > > > > > > 
_________________________________________________________________> Enjoy 5 GB 
of free, password-protected online storage.> 
http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008>
 You can unsubscribe from the list by going to the JSFG E-mail Mailing List 
page (http://www.jsfg.com/listserv.htm), entering your e-mail address, and 
selecting "Unsubscribe" instead of "Subscribe"> > Web archive: 
http://www.freelists.org/archives/jsfg_cinti > > Questions to: jsfg@xxxxxxxx
_________________________________________________________________
Instantly invite friends from Facebook and other social networks to join you on 
Windows Live? Messenger.
https://www.invite2messenger.net/im/?source=TXT_EML_WLH_InviteFriends
You can unsubscribe from the list by going to the JSFG E-mail Mailing List page 
(http://www.jsfg.com/listserv.htm), entering your e-mail address, and selecting 
"Unsubscribe" instead of "Subscribe"

Web archive: http://www.freelists.org/archives/jsfg_cinti 

Questions to:  jsfg@xxxxxxxx

Other related posts: