A few scenarios where Excel is not optimal and alternatives Setting 9 on machine A was wrong Supposed to be 20 instead of 24 Limitations of spreadsheets Updating nonnormalized data ID: 488539
Download Presentation The PPT/PDF document "Limitations of spreadsheets" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Limitations of spreadsheetsSlide2
A few scenarios where Excel is
not optimal and alternativesSlide3Slide4
Setting 9 on machine A was wrong!
Supposed to be 20 instead of 24Slide5
Limitations of spreadsheets
* Updating non-normalized data
- A solution is: normalize first
- Another is: use a databaseSlide6
Limitations of spreadsheets
* Updating non-normalized data
- A solution is: normalize first
- Another is: use a database
* Handling millions of recordsSlide7
Limitations of spreadsheets
* Updating non-normalized data
- A solution is: normalize first
- Another is: use a database
* Handling millions of records
- Use a BI tool, database or programSlide8
Limitations of spreadsheets
* Updating non-normalized data
- A solution is: normalize first
- Another is: use a database
* Handling millions of records
- Use a BI tool, database or program
* Complex data analysis
- Use scientific toolsSlide9
Limitations of spreadsheets
* Updating non-normalized data
- A solution is: normalize first
- Another is: use a database
* Handling millions of records
- Use a BI tool, database or program
* Complex data analysis
- Use scientific toolsSlide10
Limitations of spreadsheets
* Updating non-normalized data
- A solution is: normalize first
- Another is: use a database
* Handling millions of records
- Use a BI tool, database or program
* Complex data analysis
- Use scientific tools