Microsoft Office Excel 2007: The L Line, the Express Line to Learning

Description

Get on the fast track to mastering Excel

  
Want to find success in your profession or business? Master the timesaving tools you'll need in the real world, like Excel 2007. Whether you're a student, a professional, or an entrepreneur, you can learn Excel with this start-to-finish guide. Gain solid skills as you go from station to station in a series of clear-cut tutorials on Excel spreadsheet basics, integration with other applications, macro creation, and more. Start your journey today on The L Line.
* Get the basics of the new user interface and how to create spreadsheets
* Apply formulas, build charts, and explore pivot tables
* Filter, sort, analyze, and validate your data
* Customize Excel, create macros, and use add-ins

  All aboard for valuable online extras

  
Visit the L Line Web site at www.wiley.com/go/thelline for valuable online supplementary materials:
* Test bank with challenging review questions
* PowerPoint(r) slides with chapter outlines
* Free sample files
* Along The L Line
* Complete tutorial coverage with step-by-step instruction
* Ample illustrations and examples
* Real-world case studies, applications, and hints for avoiding pitfalls
* Practice exams that let you evaluate your progress

CONTENTS:

Author’s Acknowledgments.

  
Preface.

  
Chapter 1: Exploring Excel.

  
Chapter 2: Creating Your First Excel Worksheet.

  
Chapter 3: Fine-Tuning Your Worksheet.

  
Chapter 4: Understanding Excel Formulas.

  
Chapter 5: Charting: Basic Excel Chart Types and When to Use Them.

  
Chapter 6: Pivoting Data: Looking at Your Data in a Different Way.

  
Chapter 7: Adding Data from Other Sources.

  
Chapter 8: Designing Your Data for Viewing and Printing.

  
Chapter 9: Exporting Data to Other Applications.

  
Chapter 10: Sorting and Filtering Data.

  
Chapter 11: Ensuring Your Data Is Right.

  
Chapter 12: Analyzing Data with Excel.

  
Chapter 13: Customizing Excel.

  
Chapter 14: Extending Excel: Using Existing Add-Ins.

  
Chapter 15: Programming Excel: An Introduction to VBA and Macros.

  
Chapter 16: Building Your Own Excel Add-Ins.

  
Appendix A: Exam Answer Appendix.

  
Appendix B: Getting Help with Excel.

  
Index.