excel and data analysis. excel can be a powerful tool for analysis excel provides many tools for...
TRANSCRIPT
![Page 1: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/1.jpg)
Excel andData Analysis
![Page 2: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/2.jpg)
Excel and Data Analysis
Excel can be a powerful tool for analysis Excel provides many tools for analyzing
data– Filtering– Sorting– Formulas– Charts– Pivot Tables– Pivot Charts
![Page 3: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/3.jpg)
Hard Way -- Easy Way
You can fight Excel– By Formatting your spreadsheets in a
traditional report style
You can work together with Excel– By Formatting your spreadsheets in a
way Excel prefers
![Page 4: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/4.jpg)
Traditional Way
![Page 5: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/5.jpg)
The Way Excel Likes
![Page 6: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/6.jpg)
Well Formed Data?
Using Excel to analyze data can be much easier if your data is well formed
Well formed Excel data follows a set of simple rules
![Page 7: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/7.jpg)
Rules of Well Formity
One value per cell One type of data in each column No blank rows One row of column headings Be consistent
– Windhoek, WHK, WNDHK, Whoek, The Hoek… Avoid separating similar data across tabs
![Page 8: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/8.jpg)
One Value Per Cell
![Page 9: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/9.jpg)
One Type Per Column
![Page 10: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/10.jpg)
No Blank Rows
![Page 11: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/11.jpg)
Be Consistent
![Page 12: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/12.jpg)
Well Formed Data
Its easy for a computer to process Excel is designed to help you
analyze such data
![Page 13: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/13.jpg)
Summary
Microsoft Excel can be a powerful tool for data analysis
Microsoft Excel works best with well formed data
Following a set of rules can help your data be well formed
![Page 14: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/14.jpg)
The Rules
One value per cell One type of data in each column No blank rows One row of column headings Be consistent
– Windhoek, WHK, WNDHK, Whoek, The Hoek… Avoid separating similar data across tabs
![Page 15: Excel and Data Analysis. Excel can be a powerful tool for analysis Excel provides many tools for analyzing data –Filtering –Sorting –Formulas –Charts](https://reader035.vdocuments.us/reader035/viewer/2022062500/5697c00f1a28abf838cca957/html5/thumbnails/15.jpg)
Final Note
Using Excel to create well formed data can result in the duplication of some information
This duplication is necessary, because Excel is not a relational database