"The definition of insanity is doing the same thing over and over and expecting different results." - (Benjamin Franklin)
|Tired of making the same reports every day ?
|Want your job get done effectively and efficiently ?
|.... Contact us immediately at firstname.lastname@example.org
About DATABASES in Excel This is an excerpt from Pierre Leclerc (www.excel-vba.com)
Unless you develop a database with Excel for your small enterprise, store, department or branch get ready to either spend a lot of time learning and trying or to spend a lot
of money hiring a database specialist and developing your database. And at the end of the process you will still need Excel to develop your reports and analysis.
In a modern database data are stored in a very specific way. In what DB people call TABLES, records (rows of data) are stored one after the other without interruption.
Each record comprises many fields (columns) for record number, date, name, amounts, account number, etc.
Many tables are usually in a database (clients, employees, products, sales, etc...) The data is organized so that the computer can easily find what you are looking for.
A lot of companies have large centralized databases (EssBase, Oracle, SAP, Sybase, SQL Server...) or large centralized accounting, financial or manufacturing applications (JDE, SAP, Oracle, PeopleSoft, SmartStream...) but the data is analyzed and the reports are developed using Excel. They become really efficient in analyzing and reporting when their employees learn about SUMPRODUCT and INDEX/MATCH formulas. They adopt this approach because Excel is the most user friendly analyzing and reporting application so they don't need to train a few analysts on other reporting applications creating a bottleneck at the report development level. Adopting Excel also allows all the analyst and decision makers to develop significant analysis and reports improving the bottom line of the whole corporation.
site by Affordable Solutions