• Author:
  • Jacobs, Kathy
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  02/05/2007
• Price:
  $44.99
• <  Buy this book  >

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

Kathy Jacobs, MVP, has been leading technical training projects since the early 1990s, with responsibilities for designing courses, managing training programs, evaluating other instructors, and conducting classes. She supports and trains users in a variety of subjects on a variety of platforms, in both live classes and e-classes. She has been a Microsoft MVP since 2003.

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.