The Different Microsoft Excel Tutorials
Excel Tutorials Excel Templates Excel Examples
Functions, formulas and hundreds of useful tips and ideas.
If you are a beginner and you want to become an expert
start by learning about the most powerful tool in Excel
The SUMPRODUCT Formula
And if you think you are an expert and you don't know about
The SUMPRODUCT Formula
Think Again
Once you have learn for FREE about this function
You will come back here to acquire these tutorials
Money Back Guarantee
If you are not completely satisfied with this product just call the number below and the credit card transaction will be automatically cancelled.
No questions asked.
(Peter) 1- 800-501-6760
On Line Payment by Credit Card
35 Excel Spreadsheets
Only $49
SUMPRODUCT Formulas
INDEX/MATCH Formulas
Just copy/paste a new set of data on one sheet and your report is automatically refreshed on the other sheet.
SUMPRODUCT formulas are unbelievably powerful
yet VERY EASY to handle.
Hundreds of examples, step by step construction clearly explained.
Automate your invoices, your 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.
Time Management
One thing that a lot of users want to create in Excel is a time management application. You enter times in and times out and Excel calculates the number of hours and multiplies the result by the rate for the pay. Here is one such application to work with time, regular time and overtime.
My Accounting Application
Bring the data from your own accounting program and create reports by employee, by project, by product, by city....
Thanks to the database functions in Excel, analyse the data, filter it, sort it, subtotal it, your imagination is the limit.
As an example of the power of SUMPRODUCT, here is a simple, user friendly, totally customizable Accounting Application. Just write the journal entry and the rest is automated, P&L, Balance Sheet and any other reports that you need.
Dynamic Reporting
Copy/paste the data or enter data on one sheet for all your salespersons, stores, branches or products. In the single report sheet, select from a drop-down list the salesperson, the store, the branch or the product and all the numbers change.
The programming language within Excel to develop macros
VBA (Visual Basic for Applications)
A few example of what miracles you can accomplish with this tool. These examples are not designed to transform you into a programmer but to help you develop solutions to do your job faster and to get rid of the irritants that crowd your day.
And 29 other Microsoft Excel Workbooks
solutions developed for my clients in finance, accounting, banking, manufacturing, retail, etc.:
Chase Manhattan Bank, Barnes and Noble, Union Carbide, Deloitte Consulting, Merks, Alcan, Bombardier,
and many Mary's Hardware Stores
and many Joe's Flower Shops
Money Back Guarantee
If you are not completely satisfied with this product just call the number below and the credit card transaction will be automatically cancelled.
No questions asked.
(Peter) 1- 800-501-6760
On Line Payment by Credit Card
35 Excel Spreadsheets
Only $49
The senior super user helping other users on line since 1995
Links to other
Excel-VBA Resources