<<Convert Excel Spreadsheets to Web Pages | Trading Software That Operates Within Excel | Convert Excel, Access & Other Databases | Merge Excel Files>>

OzGrid.comMicrosoft Excel Templates, Training and Add-ins, Business Software and more

Microsoft Excel ® Spreadsheet Mistakes

| | Information Helpful? Why Not Donate.

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

The number 1 mistake made by Excel spreadsheet users is the manner in which they lay out their data. Nobody would consider building their home on poor foundations, yet most Excel users build their data on poor foundations.

Foundations. How to Correctly Lay Out Data

It's not by coincidence that Excel has only 256 Columns and yet 65536 Rows.

While Excel is not a true database Application, data within it should be laid out in a database format. By this I mean, you should reserve one Worksheet to enter all related raw data in a classic table format. That is, headings across row 1 of the table and all data laid out in continuous rows directly underneath their appropriate headings.

This will often mean repeating some data row after row, but that is what Excel will expect. Do not leave blanks to represent repeated data.

What's the Advantage?

By having a single Worksheet for all raw data, set-out in the manner described above, you will be able to use all of Excel's built-in features. Such features include Pivot Tables, Subtotals, Lookup Functions, Database Functions, Auto Filters, Advanced Filters, Outlines and much much more!

Remember, this data is only raw data, not your final resulting data. Your final resulting data, statistics etc will be relatively easily extracted from your raw data

Our 4 Most Popular Bundled Savings!
1200 Excel Macros Save Over 70% time saving add-in for Microsoft Excel and two downloadable books on Excel macros Get the six most popular add-ins for Microsoft Excel and two downloadable books on Excel macros in one great collection.

Software Categories Search Software

Excel Add-ins || Excel Training || Excel Templates || Employee Scheduling Software || Excel Password Recovery and Access & Word etc|| Excel Recovery and Access & Word etc || Financial Software || Financial Calculators || Conversion Software || Construction Estimating Software || Drilling Software || Real Estate Investment Software || Time Management Software || Database Software || Neural Network Software || Trading Software || Charting Software || Windows & Internet Software || Barcodes Fonts, ActiveX, Labels and DLL's || Code Printing Software

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.