- Taschenbuch: 552 Seiten
- Verlag: Wiley & Sons; Auflage: Pap/Cdr (18. November 2003)
- Sprache: Englisch
- ISBN-10: 076454120X
- ISBN-13: 978-0764541209
- Größe und/oder Gewicht: 18,9 x 3 x 23,4 cm
- Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
- Amazon Bestseller-Rang: Nr. 3.434.150 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
Excel Best Practices for Business: Covers Excel 2003, 2002 and 2000 (Englisch) Taschenbuch – 18. November 2003
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
Spreadsheets have become the de facto standard for communicating business information and the preferred tool for analyzing business data. In this current climate, the accuracy and clarity of spreadsheets are paramount. However, busy managers have little time to sift through heaps of reference books to extrapolate techniques for making polished spreadsheets. Even with finished spreadsheets in hand, managers and business professionals still need a book which holds up a mirror to their real world situations and reflects hidden flaws; and then takes the next step and guides the reader in specific ways to rework these critical documents."Excel Best Practices for Business" enables readers to examine their work and ask critical questions. And once asked, this book also answers with dynamic, practical approaches and provides take-aways extrapolated from real situations across a managerial spectrum, making this book more mentor than reference. In this book, a critical need is met. This book highlights are as follows. XML in Microsoft Office Excel 2003: entirely new to Excel 2003 is major support for XML, making Excel truly web capable and Internet ready.This book provides extensive coverage of these new features from a hands-on perspective. It identifies subtleties, gotchas and problems, and shows you practical solutions and workarounds.Spreadsheet Portals: this book introduces the topic of Spreadsheet Portals, which elevates spreadsheet practices for the Internet-ready software to the next level. Aside from explaining the basic concepts and principles of Desktop Client Portals, best practice techniques for building your portal pages and reference implementations are provided. These reference implementations, sample spreadsheets, and online demos are provided on the book's CD. Spreadsheet Makeovers: what do you do when your manager or boss asks you to take over a complex, spreadsheet-based application and send out reports every two weeks? The person who created the spreadsheet no longer works for the company. Aside from a few emails, there's no documentation.You look at the spreadsheet and you find it has flaws. Never mind about fixing the old reports; the new ones are going to go out with your name on it. This report is not your prime responsibility.You do not have the time or resources to turn this into a whole project, yet you can't afford to leave it the way it is."Excel Best Practices for Business" provides a step-by-step approach to these 'Mission Impossible' situations and walks you through the steps with fully worked out examples. Assistive Technologies: for the first time in a mainstream book, the topic of preparing accessible spreadsheets for individuals with disabilities is addressed. Government agencies needing to make electronic information section 508 compliant and corporations choosing not to alienate communities with special needs will find the techniques presented invaluable.You will learn from a hands-on perspective how to organize and design accessible spreadsheets for the visually impaired that will work with Screen Reader software, how to set up Screen Reader software, and how to build graphical components that will work with Screen Readers. These practices are carried to the next level with the introduction of Assistive Portals. This allows you to make spreadsheets accessible and avoid having to alter your original spreadsheets. The Portal Page does all the work. Because it is table driven, there are no formulas or scripts to modify. Think of how this will change the economics of preparing accessible documents.There are many more topics in "Excel Best Practices For Business" including: practical techniques for visualizing hard-to-present data, incorporating 'Smart Data' into your spreadsheets, how to build a Data Overpass, quantification of uncertainty, conversion of mountains of legacy data into manageable and useful form, spreadsheet auditing to validate the work of others, a hands-on approach to working with the Excel Solver tool, spreadsheet construction techniques through both simple design and large, complex applications.If you want to find about these and many other techniques covered, then "Excel Best Practices for Business" is the perfect guide!
Everything you need to know about
- Implementing the new XML features in Spreadsheet Portals and Web Services
- Auditing spreadsheets provided by third parties
- Making spreadsheets accessible to individuals with disabilities
- Performing spreadsheet makeovers
- Constructing large, complex spreadsheets that are efficiently designed and easily maintained
- Quantifying uncertainty and incorporating "fuzzy" numbers in financial analysis
- Moving and managing mountains of data with competence and efficiency
What do your spreadsheets have to say about your business?
In a corporate climate tainted by high-profile accounting issues, the answer to that question is paramount. This book empowers you to create, manage, and validate spreadsheets that will stand up to scrutiny and provide a clear and accurate picture of your enterprise. It shows you how to examine your work for hidden flaws, preserve the integrity of inherited spreadsheets while improving their clarity, and apply specific techniques to achieve results. If you need practical techniques you can use today, you?ll find them here.
"Excel Best Practices for Business is a "must-read" for today's busy professionals working with quantitative information."
?Tom Inman, Vice-President, WebSphere Foundation & Tools; IBM Software Group
- A selection of "Quick ?n? Easy Take-Aways"? sample components and spreadsheets that can be quickly and easily modified to meet various business needs
- Mathematica Version 5 evaluation
|5 Sterne (0%)|
|4 Sterne (0%)|
|3 Sterne (0%)|
|2 Sterne (0%)|
|1 Stern (0%)|
Die hilfreichsten Kundenrezensionen auf Amazon.com
Some of the principles might be good ideas but it seems as of each one had to be translated into the row-column appraoch to be appreciated
On a side note: when I went to the CD to work some samples, I was unable to install the program on my computer due to restrictions on my work computer. I emailed the address from my book and asked if there was a way to access the Excel files without installing the program. Mr Abduzeler emailed me back and he had set up a web page for me to download the files and also wrote a lengthy explanation on how to use them. I was impressed.
I'll update this when I get closer to the end of the book.
Aside from having all the latest and greatest spreadsheet technology (like spreadsheet portals, XML, and web services), the author writes about really practical techniques. Even if you think that you know all that there is to know about spreadsheets, you will still learn more from this book. Where else can you learn, for instance, how to evolve a strategy for Absolute vs. Relative vs. Hybrid cell referencing in Excel? While this may seem mundane to some, having the best strategy for your particular situation can make a serious difference in long-term productivity and the resulting value of the spreadsheet.
Just as there are best practices for construction in the home building industry, there are best practices for spreadsheet construction that can make a long-term difference in customer or client satisfaction. In addition to providing a better understanding of simple spreadsheets, you will learn how to create blueprints for large or complex spreadsheets.
The author's excellent formal training in applied mathematics is readily apparent in the sections on manipulating, compiling, managing, viewing, and presenting data. You will learn about how to create and use smart data and how to analyze data without getting stuck in the MUD (messed-up-data). How you ever managed before learning the fine art of data slogging will become a mystery to you.
There are whole chapters devoted to special topics and themes. Some of these include using spreadsheet portals with XML, spreadsheet auditing, spreadsheet makeovers, developing spreadsheets to accommodate special needs of individuals with disabilities, and learning how to manage mountains of data. By now it should be clear that this is not your ordinary spreadsheet book written just for the computer phobic or mathematically challenged. It's well worth reading by anyone with an interest in using best practices for spreadsheets even if you've only had eight hours of previous Excel training.
The CD-ROM alone is worth the price of the book because it's not just files that serve as input for exercises in a computer lab. The CD-ROM contains a selection of components and spreadsheets that can be quickly and easily modified to meet various predictable business needs, including making spreadsheets accessible to the motor impaired, hearing impaired and visually impaired using the latest assistive technologies.
1. John Walkenbach - Excel 2000 Power Programming with VBA
2. Michael Kofler - Definitive Guide to Excel VBA
3. Loren Abdulezer - Excel Best Practice for Business
The first two books use a lot of VBA code examples. Loren's Excel Best Practice for Business is a refreshing surprise. Written in simple, easy to understand english in fluent lines that read away as though is was a novel! Once started , I couldn't stop reading untill I finished the whole book.
Its details are simple, but most effective. The outlined ideas give you a headstart when creating and maintaining Excel files.
For example, Loren demostrates clearly what pitfalls to escape from when you design any Excel file. It is good that Loren reminds the reader of some old Roman advise ('Divide and Conquer') when recommending to SEPARATE the date into 3 layers: 1) original date, 2) analysis layer and 3) presentation layer) to CONQUER in your work of creating and maintaing Excel files.
It is funny how, if one looks at his or her own Excel files, this simple device is still broken many times.
Another example deals with the advantages of the R1C1 workbookstyle compared to the traditional A1 style. It sounds so simple, but yet, in Walkenbach and Kofler you will not find these kind of tips.
Finally the book has great examples on the CD. Examples on how to use conditional formatting to colour and present your data.
In a nutshell, I can advise anyone to buy this book, whether he or she considers him or herself a novice or expert Excel user. GO GET IT!