Other Links
Because the world of data has changed
Rediscovering Excel
A tutorial
Nothing has really changed in Excel between 1997 and 2007 except for some cosmetic transformations and WEB related functionalities that are weak at best. What has changed radically is the computer on your desk. Since the arrival of Excel (20 years ago) the computer capacity and its memory have increased 1,000 folds and this personal computer of yours is now part of a network within your company and a network connecting you to the world. This is why Excel has become so more powerful and useful. You can import data within your Excel spreadsheets and do the analysis and reporting that you need very rapidly and at a vey low cost.
You can now do things with Excel that were impossible even 5 years ago.
So here is a tutorial to rediscover Excel including some old functions and functionalities that were put on the shelves years ago because the personal computer couldn't handle them or because the data was not available.
|
Download the Tutorial and the 25 Spreadsheets and start when you are ready. |
||
|
Powerful |
The Tutorial on Excel 33 Lessons and All of them in a Once they are on your computer On Line Payment by Credit Card or Check Three different secure servers will accept your payment of Download Site 1: ClickBank |
Simple Solutions |
|
SUMPRODUCT |
Database |
|
|
Automated |
INDEX/MATCH |
|
About Excel 2007
The first reaction of long time Excel users is rage. The new "ribbon" menu and toolbar forces them in reprogramming their brain and hands. They feel like secretaries with a new keyboard where ALL the letters have changed position. Nothing is where it used to be. But we'll have to adapt and after a few hours you don't like it but you do with.
There are a few new functions and functionalities:
- Each sheet now has 1,000,000 rows: This will be useful to those who know how to import data into Excel and master the easy to learn database functionalities. It is a very interesting improvement for the few who use VBA (macros) and know about the variable of the VARIANT type.
- You can now filter data using more than two criteria: Again this will be useful to those who master the easy to learn database functionalities.
- You can now use 1,600,000 colors in the background or your cells.....what can I say...
- The great improvement for those who want to develop automated reporting applications is the addition of a new function SUMIFS (with an "S"). BUT, BUT, BUT this is not an improvement. You can already do what SUMIFS does and much more with SUMPRODUCT. Microsoft has just forgotten to tell you as like most trainers, books and websites have forgotten to tell you about it and about the calculator, the drop-down lists and the databases functionalities. You don't need another new Excel or a new book on Excel you need to rediscover Excel as presented by a long time user. You have to get down to the essential.
That is why this website and the downloadable tutorial exist
