Average customer rating:
|
Excel Charts
John Walkenbach Manufacturer: Wiley ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0764517643 |
Book Description
* One of the world's best-known Excel experts shows how to master the charting features in Excel 2000 and 2002 to create compelling graphic representations of dataCustomer Reviews:
Lack of explanation and missing chapters on CD.......2007-07-13
Excel Charts.......2006-11-05
Oooh, Aaaah. How did he do that? .......2006-07-07
Excel Charts.......2006-06-30
Helpful Tips for Efficiency, Not 2 Many Great Templates.......2006-02-20
Average customer rating:
|
Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts, and PivotTables, 2nd Edition (Visual Blueprint)
Jinjer Simon Manufacturer: Visual ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0764597809 |
Book Description
Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-900f the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.Customer Reviews:
Blueprint for Excel Data Analysis Follows Through.......2007-07-06
AWESOME.......2007-05-12
The Joys of Excel.......2006-09-05
A good reference, but not for "anybody"; allow me to explain.......2003-09-20
In this regards, I am satisfied. However if you are looking for learning simple "how-to"s like conditional formula, creating a chart, you would be disappointed since this book covers too much depth for beginners and it becomes easy to get lost in the sea of information.
Quick and Dirty- but Immensely Practical.......2003-09-18
Although I am an MBA grad and am knowledgeable of data analysis techniques, I had always considered myself a novice user of Excel. I recently found myself in a predicament where I had to quickly learn the more complicated Excel features of data analysis in preparation for an interview for a position with a market research firm. In a panic, I went to the local B&N bookstore and bought a copy of the old stand-by Dummies Series- "Excel Data Analysis" (I'll refer to it as "DS"), as well as the book in this review (I'll refer to it as Visual Blueprint, "VB").
The thing about this book that really appealed to me was the logical and clean (uncluttered) explanation of each of the topics presented. It's a very user-friendly manual to follow along with the use of a computer (to go through the exercises).
Progressive screen-shots are always located at the bottom half of each page, in successive order from left to right with clearly labeled numbered steps to follow. The examples that are shown in the screen shots are simple but very illustrative.
On the top half of each left page is an introduction of the topic being covered and what the main processes are to accomplish the particular task. On the top half of each right page are additional methods of application and extra hints and descriptions of the syntaxes for functions that can be used.
The arrangement of the graphics and the text work very well together and allow the reader to efficiently grasp each of the concepts being presented. What would normally be covered by a traditional user's manual in five to ten pages (reading from top to bottom- large text sections interspersed by graphics), this reference does the same in either two pages or four pages maximum. The way the editors have laid out this manual was very clever; not only does the reader have a lot less pages to get lost in (especially when trying to work through the examples with a computer) but also the topics are presented concisely and as simply as possible.
I relied heavily on this book to prepare myself for an Excel test given by the company I was interviewing with. I spent at least 90% of my time referring to VB, and where necessary, I spent 10% of my time referring to DS for supplementary information. I studied over a period of one week and passed the test well enough to be hired!
As enthusiastic as I am about this book, it is far from perfect with regards to being an ultimate and comprehensive manual for Excel. (That said, however, the Appendices are full of useful information...keystroke and navigation shortcuts as well as a handy reference for VBA and function syntaxes / commands....much more than is included in DS.) Additionally, as another reviewer had written previously, I can corroborate that I had found a few minor errors (formula calculations in examples, syntaxes), but not in such a large amount as to dissuaded one from using this book. My other negative is that the examples provided on the included CD were poorly referenced in the Manual; some examples, I couldn't find on the CD. Again, this didn't happen often.
I gave this book a perfect score, not because it is an authoritative and fully comprehensive manual on Excel Data Analysis (it isn't), but because it delivers on empowering readers to learn the software in much less time than traditional manuals can deliver. VB is quick and dirty- but it works!
Average customer rating:
|
Excel PivotTables and Charts (Mr Spreadsheet)
Peter G. Aitken Manufacturer: Wiley ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0471772402 |
Book Description
These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex.This book will help you get more from Excel than ever before.
Download Description
These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex. This book will help you get more from Excel than ever before. Chart Topper # 1 Creating a PivotTable Report Chart Topper # 3 Using Special PivotTable(r) Tools Chart Topper # 6 Understanding and Using PivotCharts Chart Topper # 7 Working with Multidimensional Data Chart Topper # 10 Programming PivotTables with VBACustomer Reviews:
Comprehensive Pivot Tabling.......2007-06-04
Clean and useful.......2006-08-06
A real lifesaver........2006-03-16
Average customer rating:
|
Excel Workbook For Dummies (For Dummies (Computer/Tech))
Greg, PhD Harvey Manufacturer: For Dummies ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0471798452 |
Book Description
Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant’s green sheet, and mastering even the most basic functions can be a challenge.Excel Workbook For Dummies is specially designed to give you the hands-on experience you need to start using this great program with confidence and efficiency. This guide is packed with hundreds of exercises that walk you through the ins and outs of Excel at your own pace. You’ll have all the tools you need to:
Included is a bonus CD-ROM full of useful features, including sample files for all exercises in the book, a variety of important Excel tools, worksheets, and templates for financial planning, and a trial version of Crystal Xcelsius to get you started making progress and becoming an Excel expert!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Download Description
Start using Excel spreadsheets, formulas, and charts - practice exercises make it easy See how to Set up, format, and edit basic spreadsheets Create a variety of formulas for finance, date and time, math, and more Calculate return on investments or loan amortization Master data analysis with pivot tables Turn spreadsheets into Web pages and master hyperlinksCustomer Reviews:
excel for dummies.......2007-02-23
Average customer rating:
|
Excel Charts For Dummies
Ken Bluttman Manufacturer: For Dummies ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0764584731 |
Book Description
Excel is the most popular tool for number crunching on the PC, but the challenge is in putting a meaningful face on those raw numbers. That’s where Excel Charts For Dummies comes in. Ken Bluttman will show readers how to professionally display data in presentation-quality charts. But he’ll go beyond showing readers how to create attractive charts—he’ll explain why to use specific charts in particular circumstances. Lots of real-world examples will show “the good, the bad, and the ugly” of Excel charts. He will cover the whole range of charts in step-by-step tutorials—whether it’s pies, scatter plots, or PivotCharts. He’ll show how to embed graphics and pictures into charts; then use them in impressive PowerPoint presentations or Microsoft Word documents. He’ll also show how to use charts for statistical analysis—and how charts can skew the stats and deceive. This book will feature a 16-page full-color insert of the best Excel charts “works of art.”Customer Reviews:
The best book for charts.......2005-08-28
A Great Book For Learning About Charts.......2005-06-17
Average customer rating:
|
Charts and Graphs for Microsoft Office Excel 2007 (Business Solutions)
Bill Jelen Manufacturer: Que ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0789736101 |
Book Description
<>It is easy to create a bad looking chart in Excel. This book teaches you how to unlock the beautiful formatting options available to make incredible looking charts. The first section will talk about how to decide which chart type to use. Subsequent chapters will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. The book discusses themes, colors, creating metallic charts, shadows, transparency, etc. The book also handles anything graphical in Excel. It will show the new In-Cell Data Bar charts available in Excel 2007. A section will talk about creating business flowcharts with IGX Graphics and how to display product pictures in Excel, and a section on VBA will cover creating 100's of charts using the macro language.
âMore than a how-to and reference, this book also provides the why-tos and when-tos, with serious consideration given to layout best practices and design possibilities–a very well-rounded resource.â
–Kathy Villella, CEO, PowerFrameworks.com
After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007. However, no amount of soft glow or glass bevel effects will help you communicate your point if you use the wrong chart type. This book helps you choose the right charting type and shows you how to make it look great.
This book shows you how to coax Excel to create many charts you might not have believed were possible. You’ll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. You’ll learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chart–without any limitations. You’ll also learn how to add invisible series to make columns float in midair. Learn how to create charts right in Excel cells using the new Excel 2007 data bars–or even the decades-old REPT function!
In no time, this book will have you creating charts that wow your audience and effectively communicate your message.
ABOUT THE AUTHOR
Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.
Introduction
1 Introducing Charts in Excel 2007
2 Customizing Charts
3 Creating Charts That Show Trends
4 Creating Charts That Show Differences
5 Creating Charts That Show Relationships
6 Creating Stock Analysis Charts
7 Advanced Chart Techniques
8 Creating and Using Pivot Charts
9 Presenting Data Visually Without Charts
10 Presenting Your Excel Data on a Map Using Microsoft MapPoint
11 Using SmartArt Graphics and Shapes
12 Exporting Your Charts for Use Outside of Excel
13 Using Excel VBA to Create Charts
14 Knowing When Someone Is Lying to You with a Chart
Appendix A: Charting References
Index
Customer Reviews:
Wonderful way to discover excel 2007's charts & drawing tools.......2007-08-28
Average customer rating:
|
Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets (Visual Blueprint)
Paul McFedries Manufacturer: Visual ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0471784893 |
Book Description
Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 100 key techniques for creating PivotTables and PivotCharts, including:"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
Rob L. Meerscheidt (The Woodlands, TX)
Customer Reviews:
Helpful.......2006-09-30
PivotTables for skill Excel users.......2006-09-05
Average customer rating:
|
How To Lie With Charts: Second Edition
Gerald Everett Jones Manufacturer: BookSurge Publishing ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 1419651439 Release Date: 2007-04-25 |
Book Description
If you're using a computer to generate charts for meetings and reports, you don't have to be taught how to lie-you're already doing it. You probably don't know your charts are unreliable, and neither does your audience. So you're getting away with it-until a manager or a sales prospect or an investor makes a bad decision based on the information that you were so helpful to provide. The main focus of How to Lie with Charts is on the principles of persuasive-and undistorted-visual communication. It's about careful thinking and clear expression. So don't blame the computers. People are running the show.Customer Reviews:
An utterly invaluable educational and self-teaching tool that is absolutely vital to staying abreast of the information age........2007-04-14
Don't let charts trick you!.......2006-11-10
Average customer rating:
|
Creating Spreadsheets and Charts In Excel: Visual QuickProject Guide
Maria Langer Manufacturer: Peachpit Press ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0321255828 |
Book Description
Excel can be daunting: that empty grid just stares you in the face when you start the program, challenging you to fill in the cells with thenumbers you need to crunch. How do you start? What do you do?
Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide answers those questions and puts you on the straight track to getting the job done. This new addition to Peachpit's
Customer Reviews:
Good starter book for Excel.......2006-05-30
A good beginning at using Excel.......2005-08-03
Why do I always have to have a title here?.......2005-03-13
Average customer rating: |
Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf)
Peter G. Aitken Manufacturer: Wiley ProductGroup: Book Binding: Paperback Similar Items:
ASIN: 0470104872 |
Book Description
Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.Books:
Recommended Books