Showing posts with label excel 2007. Show all posts
Showing posts with label excel 2007. Show all posts

7/28/2012

Create Dynamic Charts in Microsoft® Office Excel® 2007 Review

Create Dynamic Charts in Microsoft® Office Excel® 2007
Average Reviews:

(More customer reviews)
I bought this book because it addressed a need I have - how to make better charts with the newest version of Excel (2007), and do it in a dynamic manner, i.e. with data that changes.
This is a typical computer book, with many hundreds of pages and an included CD of examples and other things.
One of the other things on the CD is an explanation of the author's "rS1.method" methodology (even the name should be a clue), which is used throughout the book and is used "in all the author's books" as though it were some kind of standard. In it the author prescribes a very set methodology and structure for laying out your multi-worksheet spreadsheets, and all the examples are based on it. If you need some discipline and like methodology, you will like this.
But if you are like me, impatient for results and not willing to be bound by a rigid framework, you will not like it.
The other thing I didn't like was the author's rambling and lecturing style. It was hard to wade through a long discourse on every subject before getting to the meat. One place in the small print it mentions that this book is "somewhat unusual" and is a "translation from the German" so that might explain why this is. I have read other books (history) that are direct translations from other languages (German in particular), and also from the one foreign language that I can read directly I know that the writing style differs by country and can seem quite strange to a reader in a different country. That seems to be the case with this book so it made tough going for me.
Anyway, there is useful material here and the book has helped me some, thus a generous 3 stars, but I wouldn't have bought it if I had known then what I know now.

Click Here to see more reviews about: Create Dynamic Charts in Microsoft® Office Excel® 2007


Extend your Excel 2007 skills—and create more-powerful and compelling charts in less time. Guided by an Excel expert, you'll learn how to turn flat, static charts into dynamic solutions—where you can visualize and manipulate data countless ways with a simple mouse click. Get the hands-on practice and examples you need to produce your own, professional-quality results. No programming required!

Maximize the impact of your ideas and data!

Learn how your design decisions affect perception and comprehension
Match the right chart type to your communication objective
Visualize—then build—your solution using the author's five-step approach
Apply the science of color to make the right things pop
Add controls—such as drop-down lists and scroll bars—without coding
Use conditional formatting to dynamically highlight and analyze data
Unleash your chart-making creativity—and bring numbers to life!

CD includes:

More than 150 sample, customizable charts for various business scenarios
Helpful worksheets and job aids
Bonus content and resources
Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.


Buy NowGet 41% OFF

Click here for more information about Create Dynamic Charts in Microsoft® Office Excel® 2007

Read More...

3/07/2012

Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables Review

Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables
Average Reviews:

(More customer reviews)
The third updated edition of Microsoft Excel Data Analysis offers an excellent visual approach to professional-level computer instruction in Excel, and uses web-based applications as keys to creating formulas, working with functions, performing predictions, automating Excel with macros, and adding color and customizing results. No Excel collection should be without this!


Click Here to see more reviews about: Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Advanced techniques for Excel power users
Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.
Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
Expands your Excel knowledge and helps you use Excel data more efficiently
Demonstrates how to retrieve data from databases;; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
Explores all features and functions in friendly, two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions

Learn Excel at the highest levels with this practical guide.

Buy NowGet 34% OFF

Click here for more information about Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Read More...

10/24/2011

The Active Modeler: Mathematical Modeling with Microsoft Excel Review

The Active Modeler: Mathematical Modeling with Microsoft Excel
Average Reviews:

(More customer reviews)
This text is a softcover, even though at this time Amazon still lists it as a thin hardcover. It is written on the same level as Giordano, Wier and Fox's Mathematical Modelling, but focuses directly on the use of Microsoft's Excell. I am one of the many annoyed with Microsoft, but since Excell is ubiquitious, it makes a reasonable choice for a course. The book is very visual showing, for example, how to use Excell to draw Feigenbaum diagrams to illustrate chaos, how to illustrating Newton's method (drawing the tangent lines...), drawing Bezier curves for smoothing... It points out many of Excell's useful features (some have found just learning how to add scrollbars useful).

Click Here to see more reviews about: The Active Modeler: Mathematical Modeling with Microsoft Excel

This is a hands-on introduction to modeling a wide variety of applications in Microsoft Excel. It features numerous tutorials and applications to illustrate how to model and solve problems in Excel. It can be used by itself or as a supplement to a text in Mathematical Modeling or Liberal Arts Mathematics. Neuwirth and Arganbright offer a more accessible and hands-on alternative than do other modeling texts.

Buy NowGet 15% OFF

Click here for more information about The Active Modeler: Mathematical Modeling with Microsoft Excel

Read More...

7/28/2011

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other) Review

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)
Average Reviews:

(More customer reviews)
Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)
This book should be on the desk of anyone analyzing data. It IS NOT for someone who doesn't know Excel 2007 and the basics of analyzing or working with data.
However, I've gone through Chapter 39 and have found this book is filled with all kinds of errors. I couldn't find any place on the internet that addresses these errors. Files missing or wrong (ie. Chapter 9 solution file problem numbers are incorrect), examples not matching my Office, Home, Student 2007 version (ie. pg. 43 references a DATEIF function that doesn't exist), plus many more.
The author or Microsoft needs to do a better job of proofreading or at least have a website where readers can post the errors they find so everybody using this book doesn't spend their time refinding the same errors.

Click Here to see more reviews about: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)


Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guide—now updated for Excel 2007. Use Wayne's proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge.

Solve real-world business problems with Excel 2007!

Maximize profits—determine NPV, optimize your product mix, calculate ROI
Create best, worst, and most-likely case scenarios for sales
Analyze investment performance and help minimize risk
Track your personal finances, calculate loan terms, and plan for retirement
Use trend and seasonality to forecast revenue
Estimate a product's demand curve and manage inventory with precision Interpret the effects of price and advertising on sales
Assign a dollar value to customer loyalty
Solve work scheduling problems and shorten wait times for customer service queues
PLUS—predict outcomes of sporting events, presidential elections, and more!

CD Includes:

Sample files from each chapter
Problem-and-solution sets—build your expertise!
Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.


Buy NowGet 40% OFF

Click here for more information about Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)

Read More...