Jonmo1
MrExcel MVP
- Joined
- Oct 12, 2006
- Messages
- 44,061
Kudos to this forum !!!!!
I'd like to take just a minute to thank this forum for all the helpful people and information here.
This is truely a remarkable website. I have learned more by reading and posting than I ever would
have learned from any book. By reading posts, and challenging myself to come up with resolutions to other
people's problems, I have greatly increased my learning curve. I saw a post here that referred to a website
http://www.xl-logic.com/modules.php?name=Content&pa=showpage&pid=1 that ranks Excel Skills.
When I first found this forum, I was in the intermediate level. I could make a Vlookup formula, Use the
AutoFilter, Make a Pivot Table. I could do rudamentary Macro Editing after first creating a macro
with the macro recorder.
Now, a little more than a Year later, thanks to this forum I would say I am in Advanced - Teetering on Expert Level.
I can write advanced macros by hand without the recorder. I know not to use (and how not to use) select. I
Can create and use arrays in VBA, Loop through sheets/rows/columns/arrays. I can use advanced formulas like Index/Match,
Sumproduct, Array formulas like {Sum(If()) Average(If())}. The part that has me teetering on Expert level,
is I have created an addin, but have yet to distribute it for widespread use. Not to mention dreaming about spreadsheets..
About 2 years ago, I was handed a project with about a dozen processes. None were automated. All was done
by hand. Formatting/Filtering/Presenting/Sending lots of different data. For about 6 months - 1 year I muddled a
little bit at automating the processes, and I would spend at least 6 hours of a workday doing these processes.
Now thanks to this forum, I spend all of about 1 hour actually working on these processes. Maybe 25% of that speed
increase is due purely to repetition (the more you do something, the faster you get at it). But the rest is due
directly to Practices I've learned on this forum.
So anyway, thanks to everyone. You guys ROCK !!!!
I'd like to take just a minute to thank this forum for all the helpful people and information here.
This is truely a remarkable website. I have learned more by reading and posting than I ever would
have learned from any book. By reading posts, and challenging myself to come up with resolutions to other
people's problems, I have greatly increased my learning curve. I saw a post here that referred to a website
http://www.xl-logic.com/modules.php?name=Content&pa=showpage&pid=1 that ranks Excel Skills.
When I first found this forum, I was in the intermediate level. I could make a Vlookup formula, Use the
AutoFilter, Make a Pivot Table. I could do rudamentary Macro Editing after first creating a macro
with the macro recorder.
Now, a little more than a Year later, thanks to this forum I would say I am in Advanced - Teetering on Expert Level.
I can write advanced macros by hand without the recorder. I know not to use (and how not to use) select. I
Can create and use arrays in VBA, Loop through sheets/rows/columns/arrays. I can use advanced formulas like Index/Match,
Sumproduct, Array formulas like {Sum(If()) Average(If())}. The part that has me teetering on Expert level,
is I have created an addin, but have yet to distribute it for widespread use. Not to mention dreaming about spreadsheets..
About 2 years ago, I was handed a project with about a dozen processes. None were automated. All was done
by hand. Formatting/Filtering/Presenting/Sending lots of different data. For about 6 months - 1 year I muddled a
little bit at automating the processes, and I would spend at least 6 hours of a workday doing these processes.
Now thanks to this forum, I spend all of about 1 hour actually working on these processes. Maybe 25% of that speed
increase is due purely to repetition (the more you do something, the faster you get at it). But the rest is due
directly to Practices I've learned on this forum.
So anyway, thanks to everyone. You guys ROCK !!!!