Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I disagree with the quite modest L. Howard Kittle, having seen many of his
very astute postings; MVPs aren't Excel experts. A closer description might be "some people are very adept in certain areas of Excel" along with "and like to post a lot on websites or write books". One thing to keep in mind: if you can describe a logical mathematical process to arrive at a result, you can probably either write worksheet formulas or a VBA macro to calculate that result. In other words, step 1 is to clearly define the problem and steps required to solve it. Once you have that, then either you yourself or you with the help of others can probably get Excel to do it for you. And after you've done it enough yourself or as you learn from doing with others, then you gain more and more expertise. As your read through books, posts on boards like this, and other places, pay a lot of attention first to WHAT can be done with either functions or code. Once you have an idea of the capabilities of the Excel tools, then you are much better prepared to tackle the HOW of applying them to problem solving. Even if you just know in the back of your mind that there's a function somewhere that will give you a specific result, then all you have to do is 1) remember what the heck function it is, or get help for your memory from Help files, posts to forums or other sources, and 2) do the research on the correct syntax needed to use the function/VBA commands. Good luck. "Luke M" wrote: To add on... John Walkenbach's site: http://spreadsheetpage.com/ For charting tips, I like to use Jon Peltier's site: www.peltiertech.com Debra keeps a daily blog of tips, and is a master at PivotTables: www.contextures.com And like John, Chip Pearson's site has a plethora of tips regarding formulas and VBA: www.cpearson.com It really depends on what you want to try and learn first. Note that most of these MVP's also post a list of books they recommend (including some that they have written themselves). The best way to learn if by doing, but no matter what path you choose, expect to spend some time reading and studying. Some of us have been here for years, and we're still learning! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "L. Howard Kittle" wrote: Well, as an Excel novice and novice contributor to these newsgroups and a retired department manager, I would suggest this. Pose your questions in plain English text, (In which I am also not an expert). "I am new to excel and very fascinated about it and would like to learn more about it, to discover more secrets about it. My new job demands me to take control and manage existing, outgoing and incoming stock on Excel. I want to be the best asset for my company in this field." So, I suggest you won't learn Excel in the next few weeks enough to impress very many people. You probably do not have time to view the newsgroups to learn all the things you will need to get on with your job. I would suggest local Community College courses in Excel and books by John Walkenbach on Formulas and VBA Programming as a starter. You will probably only need a small knowledge of Excel to be a large contributor at your work place, depending on what you are trying to accomplish in your job description. If vast Excel knowledge is required to get your work done, you would most likely not have been hired in the first placed. There are tons of Tutorials, which I will leave to the true EXPERTS of EXCEL, the MVP's, to suggest. I refer to them almost daily as an Excel hobby in retirement. I learn something new every day!!! Just cannot remember it all.<G HTH Regards, Howard "innovative" wrote in message ... am new to excel &very fascinated about it and would like to learn more about it,discover more secrets about it.my new job demands me to take control&manage existing,outgoing&incoming stock on excel.i want to be the best asset for my company in this field... . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MOS Excel Expert 2003 | New Users to Excel | |||
Expert in Excel Needed.... HELP | Excel Discussion (Misc queries) | |||
excel expert with data | Excel Worksheet Functions | |||
What next to become a developer or excel expert | Excel Discussion (Misc queries) | |||
Excel Expert Exam..! | Excel Discussion (Misc queries) |