Excel-Tutorial Search Microsoft Excel VBA for Excel Other MS Excel Resources 33 Excel Tutorials Click Here for a FREE Example You and I have taken intermediate and advance courses in Excel and came out of it 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 our IQ had just dropped 30 points. Two promises and only two. 1 - There is nothing useless in my Resource Templates, they contain material that I use daily as a Consultant in Reporting and Data Analysis. 2 - No fancy programming, only procedures (macros) that work and that you can read as easily as a comic strip. For beginners and experts in both Excel and VBA. Not another advanced course, an APPLIED course On uselessness; What is the use of flashing and jumping numbers if they are wrong? Make money selling Excel Expertise If you are not a ClickBank member, you will be asked to become one. After, you will be taken to a web page that will tell you how toSell Excel ExpertiseJoin My Affiliate Program Give your clients access to a FREE Templatethat will change the way they work with Excel Copy/Paste Hundreds of Formulas and Macros Only material that you will use daily. Templates, Case Studies and Examples On Line Payment by Credit Card Only US $49 Immediately after you have paid on-line with your credit card, you will be automatically transferred to my Hidden Domain from where you will be able to download you Resource Templates in a single ZIP or EXE file. Click Here to Buy it at ClickBank 33 Resource Templates Including 4 courses on the MAGIC FORMULAS A course on SUMPRODUCT Formulas With these formulas, you can organize data coming from ANY Business Intelligence System or large database. Whatever the format of the data that you receive, your report is automated. SUMPRODUCT are unbelievably powerful yet very easy to handle. Hundreds of examples, step by step construction clearly explained. A course on INDEX/MATCH formulas With these formulas, you can assemble data from different sources within a single EXCEL report. You can literally create a relational database within Excel. Select a name in a drop-down list and, the address comes automatically, Select a product code and, its name, unit and price come automatically. Hundreds of examples, step by step construction clearly explained. A course on OFFSET formulas A course on INDIRECT formulas 29 Other Templates 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, Barlow (South-Africa), Union Carbide, Gildan Activewear, etc. The solution to the FREE download exercise The Switchboard You open the SWITCHBOARD and you have access to the 24 other spreadsheets Discover the beauty of hyperlinks in Excel. Create your own SWITCHBOARD, save time and avoid frustration. No need to go down 10 levels of sub-directories each time you need to open an Excel spreadsheet. MY VBA PROCEDURES (for both macro users and macro builders) Here is a spreadsheet that I carry around all the time. A set of 25 VBA procedures that you can use even if you are not VBA literate. Ctrl capital A: Encases all your formulas within an "IF/ISERROR" function. Ctrl capital D: Deletes all the named fields from a selected worksheet. Ctrl capital U: Unhides all hidden sheets. My accounting system The one that I use and that I have improved over the years.Totally customizable, nothing hidden, nothing protected.No VBA, I use the "database" approach and the magic formulas. You just take care of the journal entriesAll the statements are updated automatically. 13 other templates focusing on formulas, functions, hyperlinks, charts and other Excel tools. Hundreds of formulas 12 other templates focusing on VBA procedures (macros) that you can USE or adapt to your own needs. Hundreds of lines of VBA Code On Line Payment by Credit Card Only US $49 Immediately after you have paid on-line with your credit card, you will be automatically transferred to my Hidden Domain from where you will be able to download your Resource templates in a single ZIP or EXE file. Click Here to Buy it at ClickBank Search Microsoft Excel VBA for Excel Other MS Excel Resources