Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

Wiley
Wiley.com
Print this page Share

Microsoft Office Excel 2007: The L Line

ISBN: 978-0-470-10788-1
470 pages
May 2007
Microsoft Office Excel 2007: The L Line (047010788X) cover image
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
See More
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.

See More
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.
See More
  • THE EXPRESS LINE TO LEARNINGThe L Line uses the universally recognized motif and symbols of a subway map, professional design and ample figures to guide readers through start to finish lessons on using Excel.
  • VALUABLE ANCILLARY MATERIALS - Online components include test bank, Power Point slides with outlines, instructor's manual and syllabus.
  • GET A NEW JOB, IMPROVE SKILLS, LEARN NEW SKILLS! Topics are tied to emerging multidisciplinary topics that enable readers to master critical career-enhancing and marketable skills.
  • A START TO FINISH APPROACH – Guides readers interested in gaining professional-level Excel 2007 skills by evaluating current knowledge, learning skills taught in schools, and testing knowledge against real-world examples and challenges.
  • WRITTEN BY A PROFESSIONAL TRAINER – Kathy Jacobs’ background allows her to create training materials that are reality-based, interesting, and which focus on the needs of the learner. Kathy is a regular presenter and team member at PowerPoint Live and she is a presenter at Four Parks Technology eXpo, the Phoenix PC User’s Group, and several more user groups.
See More
Download TitleSizeDownload
Download the review questions 59.50 KB Click to Download
Download the sample files used in the book 3.03 MB Click to Download
PowerPoint slides--Chapter 1 1.45 MB Click to Download
PowerPoint slides-- Chapter 2 1.45 MB Click to Download
PowerPoint slides-- Chapter 3 1.45 MB Click to Download
PowerPoint slides-- Chapter 4 1.42 MB Click to Download
PowerPoint slides--Chapter 5 1.43 MB Click to Download
PowerPoint slides--Chapter 6 1.42 MB Click to Download
PowerPoint slides--Chapter 7 1.43 MB Click to Download
PowerPoint slides--Chapter 8 1.42 MB Click to Download
PowerPoint slides--Chapter 9 1.42 MB Click to Download
PowerPoint slides--Chapter 10 1.56 MB Click to Download
PowerPoint slides--Chapter 11 1.42 MB Click to Download
PowerPoint slides--Chapter 12 1.42 MB Click to Download
PowerPoint slides--Chapter 13 1.42 MB Click to Download
PowerPoint slides--Chapter 14 1.42 MB Click to Download
PowerPoint slides--Chapter 15 1.44 MB Click to Download
PowerPoint slides--Chapter 16 1.42 MB Click to Download
See More
Instructors Resources
Wiley Instructor Companion Site
Instructor's Manual
An Instructor's Manual with Syllabus is available online to all adopters of this text.
Test Bank
A Test Bank is available online to all adopters of this text.
Power Point Slides
See More
See Less
Students Resources
Wiley Student Companion Site
See More
See Less
Back to Top