Book description
What you need, when you need it!
Need answers quickly? Microsoft Excel 2010 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.
Includes
Workshops
MCAS Exam Prep
More than 500 Essential Excel Tasks
Inside the Book
• Create workbooks more efficiently using the improved Ribbon interface
• Use data-analysis tools and techniques for better decision making
• Use organizing, processing, and presenting tools to create and analyze data
• Integrate data from external sources and add hyperlinks
• Use conditional formatting and Sparklines to visualize results
• Add impact to your data with PivotTable and PivotChart reports
• Organize information and add impact with clip art, SmartArt diagrams, tables, and charts
• Use SharePoint to collaborate and share documents
• Use the Excel Web App to view and edit documents in a browser
• Prepare for the Microsoft Certified Application Specialist (MCAS) exam
Bonus Online Content
Register your book at queondemand.com to gain access to:
• Workshops and related files
• Keyboard shortcuts
Table of contents
- Title Page
- Copyright Page
- Acknowledgements
- Contents
- Introduction
- 1 Getting Started with Excel
- 2 Basic Workbook Skills
- 3 Working with Formulas and Functions
- 4 Modifying Worksheets and Workbooks
- 5 Formatting a Worksheet
- 6 Viewing and Printing Worksheets and Workbooks
- 7 Inserting and Modifying Graphics
- 8 Drawing and Modifying Shapes
- 9 Creating and Modifying Charts
- 10 Analyzing Worksheet Data
- 11 Building More Powerful Worksheets
- 12 Protecting and Securing a Workbook
- 13 Reviewing and Sharing Workbook Data
- 14 Publishing Data on the Web
- 15 Tools for Working More Efficiently
- 16 Expanding Excel Functionality
- 17 Working Together on Office Documents
- W Workshops
- New Features
- Microsoft Certified Applications Specialist
- Index
Product information
- Title: Microsoft® Excel 2010 On Demand
- Author(s):
- Release date: June 2010
- Publisher(s): Que
- ISBN: 9780132491792
You might also like
book
Microsoft Office Excel 2007 On Demand
How to use • Create workbooks more efficiently using a new results-oriented interface • Use data-analysis …
book
Excel® 2010 Workbook for Dummies®
Reinforce your understanding of Excel with these Workbook exercises Boost your knowledge of important Excel tasks …
book
Microsoft® Office Excel 2003 Inside Out
Take your Microsoft Excel experience to the next level! This supremely organized reference packs hundreds of …
book
Formulas and Functions: Microsoft® Excel 2010
MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Excel expert Paul McFedries shows how …