1. Creating a Worksheet and an Embedded Chart --; 2. Formulas, Functions, Formatting, and Web Queries --; 3. What-If Analysis, Charting, and Working with Large Worksheets Web Feature: Creating Web Pages Using Excel --; 4. Financial Functions, Data Tables, and Amortization Schedules --; 5. Creating, Sorting, and Querying a Table --; 6. Creating Templates and Working with Multiple Worksheets and Workbooks Graphics Feature: Smart Art and Images --; 7. Using Macros and Visual Basic for Applications (VBA) with Excel --; 8. Formula Auditing, Data Validation, and Complex Problem Solving --; 9. Importing Data, Working with Pivot Charts, Pivot Tables, and Trendlines --; Collaboration Feature: Using Share Point and Excel Services --; Appendices --; Appendix A. Project Planning Guidelines --; Appendix B. Introduction to Microsoft Office 2007 --; Appendix C. Microsoft Office Excel 2007 Help --; Appendix D. Publishing Office 2007 Web Pages to a Web Server --; Appendix E. Customizing Microsoft Office Excel 2007 --; Appendix F. Steps for the Windows XP User --; Appendix G. Microsoft Business Certification Program.
Electronic spreadsheets.
Microsoft Excel (Computer file)
HF5548
.
4
.
M523
G379
2008
Gary B. Shelly, Thomas J. Cashman, Jeffrey J. Quasney.