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 writen an outstanding series of Lessons (Index of the Lessons), so, as I do consider his work as absolutely perfect, I'll just forward you to his pages.

The most important things you should know about Excel are :

1. The database functionalities :
   • The Excel DATABASE
   • Sorting the Data in Excel
   • Filtering Data in Excel
2. The SUMPRODUCT function
3. The INDEX/MATCH formulas

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

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 !.

CLICK AND SEE THE 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:

• Management consulting
• Project management
• Training
• Coaching
• Outsourcing

And, most importantly,

• Reporting applications, fully scaled to Your needs.

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.

affordsol@skynet.be

intl +32.67.340.350

intl +32.67.340.351

Affordable Solutions
Rue du Nouveau Monde, 48
B-7060 - SOIGNIES
BELGIUM


0477 814 201

 site by   Affordable Solutions