Microsoft Office Excel^® 2007: The L Line^TM, The Express Line to Learning

by Kathy Jacobs

• ISBN13: 9780470173787
• ISBN10: 0470173785
• Format: eBook
• Copyright: 2007-07-01
• Publisher: Wiley

Summary

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

Table of Contents

Author's Acknowledgments

Preface

Exploring Excel

Creating Your First Excel Worksheet

Fine -Tuning Your Worksheet

Understanding Excel Formulas

Charting : Basic Excel Chart Types and When to Use Them

Pivoting Data: Looking at Your Data in a Different Way

Adding Data from Other Sources

Designing Your Data for Viewing and Printing

Exporting Data to Other Applications

Sorting and Filtering Data

Ensuring Your Data Is Right

Analyzing Data with Excel

Customizing Excel

Extending Excel: Using Existing Add-Ins

Programming Excel: An Introduction to VBA and Macros

Building Your Own Excel Add-Ins

Exam Answer Appendix

Getting Help with Excel

Index

Table of Contents provided by Publisher. All Rights Reserved.