Part IV: Advanced Excel Techniques

Part IV: Advanced Excel Techniques

Hour

14 Working Smarter

15 Using Functions

16 Auditing and Validating Your Work

17 Analyzing Your Data

18 Working with PivotTables

19 Integrating Excel with Other Office Applications

20 Automating Tasks with Macros and Smart Tags

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

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