Summary

Hour 19 has shown you how to integrate Excel with other Office applications. Now that you have some basic knowledge on how to share data between Windows applications, you can refer back to Hour 19 to get the instructions you need whenever you get stuck.

Hour 20 shows you how to automate tasks by creating your own macros.

Part I: Excel Basics

Part IV: Advanced Excel Techniques

Hour 14. Working Smarter

Hour 15. Using Functions

Hour 16. Auditing and Validating Your Work

Hour 17. Analyzing Your Data

Hour 18. Working with Pivot Tables

Hour 19. Integrating Excel with Other Office Applications

Using Objects in Excel

Inserting Objects

Using Hyperlinks with Other Office Documents

Sending Your Document Via Email with Outlook

Hour 20. Automating Tasks with Macros and Smart Tags

Part V: Creating and Using Databases in Excel

Part VI: At the Office and on the Internet/Intranet