Resource Workbooks

Excel and VBA Not presented by a teacher but by a colleague Accountant/Data Analyst who has been working daily for the last 15 years for clients around the world making it happen in Excel and VBA

You and I have taken intermediate and advanced courses in Excel and have come out of them having learned a lot of useless things and spent $100s. You and I have bought big books on Excel with a lot of useless chapters. You and I have read books on VBA that made us think that our IQ had just dropped 30 points. Two promises and one only two. 1 - In Excel: There is nothing useless in my Resource Workbooks, they contain material that I use daily as a Consultant in Reporting and Data Analysis. 2 - In VBA: No fancy programming but procedures (macros) that work and that you can read as easy as a comic strip. For both beginners and experts in Excel and VBA.  Most of this material can't be found in books or in courses from people who master Excel-VBA but do not master accounting, data analysis and reporting. On uselessness; What is the use of flashing and jumping numbers if the result is wrong?

Tired of Waiting for IT/IS To develop YOUR reports?

SUMPRODUCT Formulas

With these formulas, you can organize data coming from ANY ERP system or large database. Whatever the format of the data that you receive, your report is automated WITHOUT ANY VBA (MACROS) SUMPRODUCT Formulas are queries in a cell. They are unbelievably powerful. Hundreds of examples, step by step construction clearly explained.

INDEX/MATCH formulas

With these formulas, you can assemble data from different systems within a single EXCEL report. INDEX/MATCH formulas allow you to develop a relational database between different "txt" or "csv" or "xls" files downloaded from different systems. Automate your invoices, type the name and the address comes automatically, type a product code and its name, unit and price come automatically. No VBA(Macros) needed. Hundreds of examples, step by step construction clearly explained.

Not a beginners course Not an intermediate course Not an advanced course An APPLIED COURSE in EXCEL and in VBA

And, 23 other workbooks, case studies and real reports and applications that I have developed for my clients:  Chase Manhattan Bank, United Bank of Switzerland, Air Canada, National Bank of Canada, L'Oréal (Paris), Barlow (South-Africa), Union Carbide, Gildan Activewear, etc...
Including
The Switchboard No need to go down 10 levels of sub-directories each time you need to open one of the RESOURCE WORKBOOKS, OPEN THE SWITCHBOARD Discover the beauty of hyperlinks in Excel. Create your own SWITCHBOARD, save time and avoid frustration.
An Accounting Application Easy to use, easy to modify, easy to adapt to YOUR needs. An application that allows you to create ANY report that you wish. The journal entries are easily accessible for correction, modification, duplication. As easy to use as Excel No VBA, no MACROS JUST SUMPRODUCT FORMULAS
10 other workbooks focusing on formulas, functions, hyperlinks, charts and other Excel tools. Hundreds of formulas	10 other workbooks focusing on VBA procedures (macros) that you can use or adapt to your own needs. Thousand of lines of VBA Code

A one time payment of $49.00us for all 25 Workbooks. Once you have paid, you will be sent to a web page from where you will be able to download IMMEDIATELY a SINGLE file containing all the workbooks.

If you are a member of Paypal, or want to become one,