30 excel tutorials

i have assembled 30 of the best workbooks that i have developed over the last 10 years for my clients around the world. i have added comments and instructions to them and i call them my

resource workbooks

they are all about managing data with excel
automating
analysis & reports & invoices & statements

with excel formulas (60%) with macros (10%) or with both (30%).

these 30 tutorials contain everything that you need to develop reports and analysis whatever the data source.

you will avoid manual entries and re-entries in most of your excel files minimizing errors and saving countless hours.

only $49
for all 30 resource workbooks

immediately after you have paid, you will be able to download all the resource workbooks in a single compressed file.

including

a tutorial on sumproduct formulas

with these formulas, you can organize data coming from
any business intelligence system or large database.

whatever the database (excel or others) or the format of the data that you receive, your report is automated.

sumproduct formulas are unbelievably powerful
yet very easy to handle.

hundreds of examples, step by step construction clearly explained.

discover the data sheet approach

a tutorial 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.

automate your invoices, you shipping bills or your quotation workbooks, select a client's name in a drop-down list and, the address appears automatically. select a product code and, its name and unit price appear automatically without any macros (vba).

hundreds of examples, step by step construction clearly explained.

and other excel files
the switchboard you open the switchboard and you have access to all the 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.
a new function in excel $99.95 becomes "ninety nine dollars and 95 cents... up to $999,999,999,999.99
other vba (open code) populate cascading combo boxes so that when you choose country in the first one, you are offered a list of cities from the selected country.
my accounting application a simple, user friendly, totally customizable accounting application developed with sumproduct formulas. just write the journal entry and the rest is automated, p&l, balance sheet and any other reports adapted to your reality and that you design yourself. thanks to the database functions in excel, analyse your data, filter them, sort them, subtotal them, your imagination is the limit. you want to correct an entry, or even erase it, just do it.
templates, examples, case studies real problems, real solutions that i have developed for my clients chase manhattan bank, united bank of switzerland, air canada, national bank of canada, barlow (south-africa), bombardier, alcan union carbide, gildan activewear and many joe's hardware store. with and without vba macros

only $49
for all 30 resource workbooks

immediately after you have paid, you will be able to download all the resource workbooks in a single compressed file.