Cart Contents
Categories
- New Products (5)
- Specials (22)
- Featured (5)
- Bestsellers (5)
- CDs (12)
- Books (24)
- Bundles (18)
- Utilities (9)
- Misc (2)
- DVDs (6)
- eBooks (21)
Bestsellers
VBA and Macros for Microsoft Excel
2500 Excel VBA Examples
Learn Excel from Mr Excel E-Book
Guerilla Data Analysis
Slide Your Way Through Excel VBA
Guerilla Data Analysis E-Book
Join the Excellers League
Complete PDF - Learn Excel
Speedometer Chart Creator
Pivot Table Data Crunching
Sale Item
Currency
Product Details
|
Charts & Graphs for Excel 2007
SKU: 122
|
Overview
A complete guide to the visual display of information in Microsoft Excel 2007. This 437 page book is part of QUE's popular Business Solution series.
You will learn:
- When to choose which type of chart - Most people use pie charts far too often. Learn which chart types are appropriate for each situation.
- Master the Excel 2007 ribbon - If you have Excel 2007, Microsoft has spread the charting commands across three ribbon tabs. Learn which commands are worth your time and when you should head straight back to the Excel 2003-style dialog boxes.
- Coax desired results out of Excel - how many times does an Excel chart get you close to the result, but there is some nagging deficiency? For example, Excel's HLC stock charts are missing the Open marker that every publication like the WSJ or online stock sites routinely use. THe problem goes back to a tiny bad design decision that Microsoft made 15 years ago. Learn how to modify the built-in chart to actually look like a real stock chart.
- Create unreal charts - Chapter 7 is dedicated to creating charts that will have your audience saying, "you can't create that chart in Excel!"
- Display visual data without a chart - create visual displays right in the worksheet.
- Put your geographic data on a map - rather than list your largest customers, show them on a map. Use MapPoint to plot your Excel data geographically. Great for analyzing your customer travel patterns and planning your next advertising campaign.
- Create charts with VBA - the Excel 2007 macro recorder doesn't bother to record any of the cool new charting features in Excel 2007, so you will need this book if you want to create charts with VBA.
- Use graphical elements in Excel - use Shapes, SmartArt Graphics and pictures in your spreadsheets.
- Detect chart lies - many of the Excel charts allow someone to deceive the audience. Learn how to spot chart lies so you won't be fooled.
- Export your Excel Charts - take your Excel charts to PowerPoint, Word, web pages, or as graphics on your hard drive for use elsewhere.
Related Products
SKU: 114
|
|
 |
|
SKU: 127
|
|
|
|
Reviews
Add Your ReviewCurrently there are no reviews for this product. Share your opinion with others, be the first to write a review.
Tell a Friend
