VBA Class Closing Tonight!

I know we are all very busy, so just a quick reminder that Chandoo’s outstanding VBA Classes closes registration tonight!
Wow that was a quick registration window. I had forgotten that today was the deadline until one of my academy students just asked me a few moments ago if there was still time to enroll in Chandoo’s class. It turns out that registration ends tonight, May 20, 2011 at 11:59 PM Pacific Standard Time.


So if you thought you might like to do this, now is the time!
VBA Classes is a 12-week, comprehensive VBA course.  If you know your way around regular Excel and have always wanted to learn how to devise your own VBA and not just copy a snippet you found somewhere, then join his class!
At the bare minimum, please click on this image and watch a video of Chandoo (who is a Microsoft Excel MVP) describe the course in detail:
vba-classes-msg1-chandoo.png
Chandoo’s courses always offer extraordinary value for money and this course is no different. But you can also choose to bundle it with his flagship Excel School and Dashboard programs. Extreme value indeed!
There is no doubt that enrolling in Chandoo’s VBA Classes will prepare you well for my upcoming VBA course so please keep that in mind.
Also, this summer I will be offering the second class of my normal Excel Hero Academy. I had originally planned on running that class this spring, but it will be held this summer. There are already over 250 people on the waiting list. Please consider joining us… it is going to be fantastic! Just fill-in the form on this page:
And finally, if you have some interest in my upcoming VBA-only courses offered through the academy, please fill in this interest list form:
If you are reading this in email or RSS and connot see the above form, please click here.
Enhanced by Zemanta

Excel Jobs Around the World

The Excel Hero Community is blossoming this spring, like its on some type of super-growth serum!
It is a tremendous feeling to witness the growth of this blog, the interest in the Excel Hero Academy, the newsletter, the LinkedIn groups.
Thank you very much indeed!
The one thing we all have in common is our passion for Microsoft Excel.  It’s an awesome thing to make a living simply by working with Excel. But not all of us have that luxury.
I thought it would be helpful for the community to have a place where we can search for Excel jobs. We have readers from all over the world and so I searched for a way to post searchable Excel job listings from around the world.
I’m happy to announce that the Excel Hero website now has an:
You will notice that 28 countries are listed in what looks like a random order. The order is actually by number of Excel Hero Blog readers over the last 90 days (as of May 19, 2011). Sorry I could not list every country, but the ones represented comprise almost all of our readers, and the service I’m tapping into for this does not list jobs for every country in the world.  But 28 countries is pretty good I think.
Thank you for the growth! I hope you find the Excel Jobs Board useful.
P.S. Have you read about the VBA Classes?  … :)

Excel Formulas

If you are searching for information on Excel formulas, you have struck gold!

But if you are looking for a quick answer to an Excel formula problem, this is not the right place. The Excel calculation engine is vast and it will take a long time to fully understand how to harness it to solve business problems.
On the other hand, if you are looking for a place to help you truly understand how Excel formulas work and how best to harness that knowledge, this is the place!

Excel Hero (this blog) is packed with articles that teach you how to wield Excel like a master. This topic is quite large, but here is a straightforward crash course.
Excel Formulas


I would suggest that you start with my article, Which Function To Use.

And then to gain true mastery, I would read these articles on advanced Excel formulas in order:

 

Live Calendar Musings
The Venerable SUMPRODUCT

I have been told by hundreds of advanced Excel students, that this list of articles includes some of the very best insights into Excel formulas ever written!
So please bookmark them and plan on reading them many times.

Excel formulas are the foundation of Excel’s power. To see the sorts of things possible, examine these interesting dynamic charts that are built with Excel formulas!

 
 – solarsong
 – Excel, A Presentation Platform (Number Spiral)
 – Lilac Chaser (Optical Illusion)
 – Stereokinetic (Optical Illusion)
 – Illusory Contours (Optical Illusion)
 – Breathing Square (Optical Illusion)
 – Enigma (Optical Illusion)
 – Two Sinusoids (Optical Illusion)
 – Perpetual Collisions (Optical Illusion)
 – Freezing Rotation (Optical Illusion)
 – Reverse Spoke Illusion (Optical Illusion)
 – Stepping Feet Radial Illusion (Optical Illusion)
 – Swimming Fish (Optical Illusion)

– Mutually Interfering Shapes (Optical Illusion)

 
Now, to learn even more about Excel formulas, please sign-up for my newsletter:

 

 

And consider the Excel Hero Academy. The next class starts this summer (2011)!

VBA Class

Many of you have heard the news that I plan to offer beginning and advanced Excel VBA courses through the Excel Hero Academy this summer and these courses are going to be great.

But in the meantime Chandoo has just opened registration for his new VBA Classes – which is a 12-week, comprehensive VBA course.  If you know your way around regular Excel and have always wanted to learn how to devise your own VBA and not just copy a snippet you found somewhere, than this is the course for you!


At the bare minimum, please click on this image and watch a video of Chandoo (who is a Microsoft Excel MVP) describe the course in detail:
vba-classes-msg1-chandoo.png
Chandoo’s courses always offer extraordinary value for money and this course is no different. But you can also choose to bundle it with his flagship Excel School and Dashboard programs. Extreme value indeed!
There is no doubt that enrolling in Chandoo’s VBA Classes will prepare you well for my upcoming VBA course so please keep that in mind.
Also, this summer I will be offering the second class of my normal Excel Hero Academy. I had originally planned on running that class this spring, but it will be held this summer. There are already over 250 people on the waiting list. Please consider joining us… it is going to be fantastic! Just fill-in the form on this page:
And finally, if you have some interest in my upcoming VBA-only courses offered through the academy, please fill in this interest list form:
If you are reading this in email or RSS and connot see the above form, please click here.
Enhanced by Zemanta