Home

 Welcome to Affordable Solutions,

Your IT partners for EXCEL and VBA applications.

At Affordable Solutions, we pride ourselves in getting the job done promptly, and even more importantly, getting it done right.

We offer personalized consulting services in MS Excel with YEARS of expertise in YOUR field.
We will spend more time developing what you need than trying to understand what you are talking about.

Contact us immediately : we can do it or we can help you do it, it's YOUR choice.

With 45 years experience in Management, Accounting and Data handling, I am able to understand the needs of my client even by email or by phone.

Nearly all Windows users, in their office, have some copy of Excel

Nevertheless, I feel really upset when I see how they use Excel, and I always wonder if they only can imagine what a kind of racing horse they have on hand.

Far apart of its mainly used calculation side, Excel is a misknown extraordinary engine with full database capacity, as well as a wonderful and unique reporting tool.

In addition to all these possibilities, Excel includes a tremendous programming language : VBA or Visual Basic for Applications, which adds to the basics of any spreadsheet a unique and easy way of handling nearly every aspect of computing.

These observations, as well as my 35 years expertise, have convinced me of the utility of some vulgarization of all the underlying strengh, and this site is exactly that :

This site is NOT about
"Everything you can do with Excel and VBA",
but about
"How you can do what you NEED to do with Excel and VBA".

My canadian collegue Pierre Leclerc has an outstanding series of Lessons on his website at : 
Rediscover Excel Functions and Formulas .

•  The most important things you should know about Excel are :

Last but not least, Pierre has even added a whole set of tremendous Lessons on VBA for Excel :
100% PRACTICAL !!! See : Excel Macros and Programming

Believe me : if you do practise all of these lessons, you will be "empowered", as Pierre uses to say : I mean you will become actual Excel gurus !.

•  Tutorial on Excel Macros (VBA)

With macros in Excel you will save a lot of time and do a lot more. Learn the skill and get a better paying job.

This Tutorial is divided in three sections:
$1. - Beginner

Section 1 - Beginner : Excel Macros Programming: Lessons 1 to 10
This section is about recording, writing, modifying and testing macros in the Visual Basic Editor. You will also learn about security and discover "events" (an event is what starts the macro).

Section 2 - Intermediate : Excel VBA Vocabulary: Lessons 11 to 23
Developing a macro is communicating with Excel and to do so you need to use a language called Visual Basic for Applications (VBA). In section 2 you will learn all the VBA vocabulary that is essential to work with business data (accounting, sales, production and others).

Section 3 - Advanced : Forms and Controls in VBA for Excel: Lessons 24 to 33
The userform is a small or large dialog window that you create and allows the user to submit values that will be used by your macros. To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.

CLICK AND SEE SCREENSHOTS OF OUR PRODUCTION

Our mission is to help you improve substantially and lastingly your company's performance and value.
We will contribute to your success by providing:

We offer personalized consulting services in MS Excel with YEARS of expertise in YOUR field.

We will spend more time developing what you need than trying to understand what you are talking about.

With 30 years experience in Management, Accounting and Data handling, we are able to understand the needs of our client even by email or by phone : so, the cheapest way is to ask for ON LINE consulting.

We will "empower" you !

We create Solutions : mostly with Excel, but have people who specialize in HTML coding, Web-Sites creation and maintenance, Office-VBA programming and Windows applications development.
We also have expert graphic artists and design specialists : our philosophy is that just because something is professional and rigid on the inside, it doesn't have to look dull or complicated on the outside but it has to be an Affordable Solution.
Our main customers are Company heads, data analysts, financial reporters, MRP and ERP specialists and database administrators who want to automate their analysis and reporting processes and information systems.

!! This work is licensed under a
Creative Commons Attribution-NonCommercial-NoDerivs 2.0 License.

Contacts...

site by Affordable Solutions