This web site is brought to you as a public service by Herve Hanuise and Affordable Solutions. We provide complete consulting and custom application design and development for Excel. For more information about how to turn Excel into a powerful application platform, contact us at email@example.com
CONTACT US FOR AWESOME EXCEL APPLICATIONS
Trainings in Excel - VBA
And save money and time with automation.
I can show you how to do it, help you do it or I can do it for you
It is your choice
During the last years, I have been working for many companies of all sizes, delivering formulae, macros, applications and ideas, enabling them to simplify decision-making processes and save millions.
1• Excel ! ...
Excel is one of the most used software tools in the world and just about every business has a copy somewhere.
Despite its power and flexibility it is not always clear how to use it to perform some of the most important tasks in any business: organizing, analysing, and presenting financial information.
So, I feel really upset when I see how Excel is used, and I always wonder if users 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 :
From integrating data from a variety of different sources, through organizing and analyzing financial data, to presenting it in a variety of graphical forms, this site has you covered.
This site is NOT about "Everything you can do with Excel and VBA"
"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, so, as
I do consider his work as absolutely perfect, I'll just forward you to his site : Rediscover Excel Functions and Formulas.
2• The most important things you should know about Excel are :
|• The database functionalities :|
|a) The Excel DATABASE|
|b) Sorting the Data in Excel|
|c) Filtering Data in Excel|
|• The SUMPRODUCT function|
|• The INDEX/MATCH formulas|
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 !.
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:
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.
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|
|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-NoDerivs 3.0 Unported License.
Rue du Nouveau Monde, 48
B-7060 - SOIGNIES
0477 814 201
site by Affordable Solutions