IMPORTANT IMPORTANT
IMPORTANT |
Free Microsoft Excel Tips |
|
|
Things you need to learn about Microsoft Excel to work faster and better. |
|
What Microsoft Excel is all about. Work with numbers, text (strings) and dates. Assemble functions and create formulas. |
|
How to bring external data within Microsoft Excel and reformat them to make them usable. How to use Excel to reformat data and uplooad them into your central database or application (accounting, manufacturing, sales, finance, etc...) |
It
is not how much you know about Excel that is important |
|
|
Data is to the enterprise what weapons are for the army, if you supply only the generals and not the soldiers, you lose the war. |
|
Excel can be great database but its strenght resides in its power to transform data from any database into efficient and automated reports even without macros (VBA). |
|
Sort, Filter (Auto filter and Advance Filters), the Form and the Subtotals. |
|
A few tips on charts. |
|
They are not for everybody but they can be very useful. First, learn about SUMPRODUCT and INDEX/MATCH formulas and database filters. |