Tips and Help on Excel and VBA for Excel


Excel and Business Data

Table of Contents

Excel or Access?

Upgrading from Excel to Access? It is not an upgrade and it can even be a costly mistake.

Database  101

A database is a very simple thing for the user but  you need a great level of competence to design one.

Excel as a Database

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 and Databases

Excel can be a great database program but its strength resides in its power to transform data from any database into efficient and automated reports even without macros (VBA).

Saving or making money with Excel

Manual entries cost money, take time and generate errors. Manual re-entries are even worse.


Discover more in 50 Excel spreadsheets


    Tips and Help on Excel and VBA for Excel

Excel in Business