Microsoft Office Excel 2007 On Demand
Read an excerpt:
Chapter 3: Working with Formulas and Functions
Reprinted with permission from Que Publishing. Copyright © Pearson Education, Que Publishing. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Microsoft Office Word 2007 On Demand; Steve Johnson, et al, $22.50, 36% Off!
- Microsoft Office Word 2007 Plain & Simple; Jerry Joyce, et al, $12.95, 41% Off!
- Microsoft Office Excel 2007 Plain & Simple; Curtis D. Frye, $12.95, 41% Off!
- Microsoft Office PowerPoint 2007 On Demand; Steve Johnson, et al, $22.50, 36% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
How to use
• Create workbooks
more efficiently using a new results-oriented interface
• Use data-analysis
tools and techniques for better decision making
• Use organizing,
processing, and presenting tools to create data in Excel
• Integrate
data from external sources and add hyperlinks
• Use conditional
formatting to visualize results
• Add impact
to your data with PivotTable and PivotChart reports
• Create organizational
data reporting and publishing solutions
• Organize
information and add impact with clip art, SmartArt diagrams, tables, and charts
• Use Groove
and SharePoint Team Services to collaborate and share documents and information
• Prepare
for the Microsoft Certified Application Specialist (MCAS) exam
• Practice
your new skills with the useful workshops inside
On the Web
This book uses real-world examples to give you a context
in which to use the task. This book also includes workshops to help you
put together individual tasks into projects. The Excel example files that you
need for project tasks are available at www.perspection.com.
Includes MCAS Exam Objectives!
This courseware meets the objectives for the Microsoft
Certified Application Specialist (MCAS). Upon completion of this courseware,
you may be prepared to take the exam for MCAS qualification. To learn more about
becoming a
Microsoft Certified Application Specialist, visit www.microsoft.com.
Table of Contents
Introduction xvii
Chapter 1 Getting Started with Excel
1
Chapter 2 Basic Workbook Skills
35
Chapter 3 Working with Formulas and
Functions 71
Chapter 4 Modifying Worksheets and Workbooks
109
Chapter 5 Formatting a Worksheet
131
Chapter 6 Viewing and Printing Worksheets
and Workbooks 169
Chapter 7 Inserting and Modifying Graphics
185
Chapter 8 Drawing and Modifying Shapes
225
Chapter 9 Creating and Modifying Charts
257
Chapter 10 Analyzing Worksheet Data
291
Chapter 11 Building More Powerful Worksheets
317
Chapter 12 Protecting and Securing a Workbook
333
Chapter 13 Reviewing and Sharing Workbook Data
363
Chapter 14 Publishing Data on the Web
395
Chapter 15 Tools for Working More Efficiently
411
Chapter 16 Expanding Excel Functionality
429
Chapter 17 Working Together on Office Documents
455
W Workshops: Putting It All Together
483
About the Author
Steve Johnson has written more than 20 books on a variety of computer software,
including Microsoft Office XP, Windows XP, and Macromedia Director MX and Fireworks.
In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection,
Inc. Perspection, Inc. is a software training company committed to providing
performance-based training to help people effectively and efficiently use computer
technology. Perspection writes and produces software training books, and develops
Web-based training for Windows and Macintosh personal computers. Since 1991
they have written more than 60 computer books and sold over 4.5 million copies.
|
