Table of Contents

The Missing Credits Introduction Part One: Worksheet Basics Chapter 1. Creating and Navigating Worksheets Creating a Basic Worksheet Editing Data Navigating in Excel Saving Files Opening Files Chapter 2. Adding Information to Worksheets Adding Different Types of Data Quick Ways to Add data Chapter 3. Moving Data Around a Worksheet Selecting Cells Moving Cells Around Adding and Moving Columns or Row Chapter 4. Managing Worksheets and Workbooks Worksheets and Workbooks Find and Replace Spell Check Chapter 5. Formatting Cells Formatting Cell Values Formatting Cell Appearance Chapter 6. Smart Formatting Tricks The Format Painter Styles and Themes Conditional Formatting Chapter 7. Viewing and Printing Worksheets Controlling Your View Printing Controlling Pagination Part Two: Formulas and Functions Chapter 8. Building Basic Formulas Creating a Basic Formula Formula Shortcuts Copying Formulas Chapter 9. Math and Statistical Functions Rounding Numbers Groups of Numbers General Math Functions Trigonometry and Advanced Math Advanced StatisticsChapter 10. Financial Functions The World of Finance Financial Functions Depreciation Other Financial Functions Chapter 11. Manipulating Dates, Times, and Text Manipulating Text Manipulating Dates and Times Math with Dates and Times Date and Time Functions Chapter 12. Lookup, Reference, and Information Functions The Basic Lookup Advanced Lookups Information Functions Tutorial: Quickly Generating Invoices from a Product Catalog Chapter 13. Advanced Formula Writing and Troubleshooting Conditions in Formulas Descriptive Names for Cell References Variable Data Tables Controlling Recalculation Solving Formula Errors Part Three: Organizing Worksheets Chapter 14. Tables: List Management Made Easy The Basics of Tables Dealing with Duplicate Rows Performing Table Calculations Chapter 15. Grouping and Outlining Data Basic Data Grouping Grouping Timesavers Chapter 16. Templates Understanding Templates Creating a New Workbook from a Template Part Four: Charts and Graphics Chapter 17. Creating Basic Charts Charting 101 Basic Tasks with Charts Practical Charting Chart Types Chapter 18. Formatting and Perfecting Charts Chart Styles and Layouts Adding Chart Elements Selecting Chart Elements Formatting Chart Elements Improving Your Charts Advanced Charting Chapter 19. Inserting Graphics Adding Pictures to a Worksheet Excel's Clip Art Library Drawing Shapes Part Five: Advanced Data Analysis Chapter 20. Scenarios and Goal Seeking Using Scenarios Using Goal Seek Solver Chapter 21. Pivot Tables Summary Tables Revisited Building Pivot Tables Multi-Layered Pivot Tables Fine-Tuning Pivot Table Calculations Filtering a Pivot Table Pivot Charts Part Six: Sharing Data with the Rest of the World Chapter 22. Protecting Your Workbooks Understanding Excel's Safeguards Data Validation Locked and Hidden Cells Chapter 23. Worksheet Collaboration Preparing Your Workbook Adding Comments Tracking Changes Sharing Your Workbook Chapter 24. Querying Databases and XML Files Excel and Databases Understanding XML Excel and XML Chapter 25. Exchanging Data with Other Programs Sharing Information in Windows Embedding and Linking Objects Transferring Data Chapter 26. Connecting Worksheets to the Web Putting Worksheets on the Web Performing Web Queries Using Hyperlinks Part Seven: Programming Excel Chapter 27. Automating Tasks with Macros Macros 101 The Macro Recorder Macro Security Creating Practical Macros Chapter 28. Programming Spreadsheets with VBA The Visual Basic Editor Understanding Macro Code Exploring the VBA Language Part Eight: Appendix Appendix. Customizing the Quick Access Toolbar Index

About the Author

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). His website is www.prosetech.com.