|
Microsoft Office Excel 2007 Data Analysis Visual Blueprint
Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-900f the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate
it to suite your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.
1. Getting Started
2. Creating Formulas
3. Creating and Using Functions
4. Using Financial Functions
5. Using Statistical Functions and Tools
6. Organizing Worksheet Data
7. Working with Pivottables
8. Charting Data
9. Working with External Data
10. Useful Data Analysis Tools and Techniques
11. Sharing your Workbook with Others
12. Automating with Macros
Appendix A: Excel Keyboard Shortcuts
Appendix B: Excel Function Quick Reference
Appendix C: Formula Basics
INDEX
|
