I recently got a new job as a "Revenue Analyst" and I am not where I need to be in my knowledge of Excel and Access. I was told by my supervisor that it's no big deal, I'll learn it, but I feel it necessary to perform at a higher level to enable me to excel in my job function. I've purchased "excel data analysis for dummies", but I need something more. I've been online in Excel "Help" for tips on working various functions, such as VLOOK, IF, etc..., and other data analysis functions. I'm anxious to get this job off the ground and jump right into it. Does anyone have advice that I can use to assist in exceling while on the job. Please help... THANKS!
2006-07-04 15:40:08 · 5 answers · asked by Lady K 1 in Computers & Internet ➔ Software
Hi, your questuion has no easy answer. Various clients, of mine, have asked the same question. Excel, the spreadsheet can be learned quickly since it does come with a limited tutorial,
Access, an integrated database system takes more time. If you're really in a hurry hire a tutor, most colleges have contacts with TA's or good business students.
2006-07-04 15:47:41 · answer #1 · answered by Richard B-H 2 · 0⤊ 0⤋
There's no "easy" way to learn Excel or Access. I am self-taught and have become quite advanced by solving problems as they come up. One pointer that I found very helpful when writing lengthy formulae is to use Notepad. That's right, Microsoft Notepad for writing a formula. You can past the help text of a sample formula into notepad and then simple replace the variables with actual cell addresses. This is especially helpful with nested IF statements. BTW, Excel can only handle 7 nested IF's. Once finished editing a formula, just copy and paste it into the cell you want it in.
Make life much simpler!
2006-07-05 10:03:28 · answer #2 · answered by qwertykph 4 · 0⤊ 0⤋
Best source for this type of education is your local Community College... Most have Adult Education sessions (especially now that Summer session is starting) and convenient timeframes...
Some local High Schools also have similar offerings...
All depends on where you live.
2006-07-04 15:43:12 · answer #3 · answered by N2FC 6 · 0⤊ 0⤋
I picked up the latest book and used the help drop downs.
2006-07-04 15:51:51 · answer #4 · answered by M R 1 · 0⤊ 0⤋
excel and access for dummies
2006-07-04 15:43:32 · answer #5 · answered by Jessica H 1 · 0⤊ 0⤋