|
Excel Hacks: 100 Industrial Strength Tips and Tools | 
enlarge | Authors: Raina Hawley, David Hawley Publisher: O'Reilly Media, Inc. Category: Book
List Price: £17.50 Buy New: £10.22 You Save: £7.28 (42%)
Rating: 1 reviews Sales Rank: 216130
Media: Paperback Edition: 1st ed Number Of Items: 1 Pages: 304 Shipping Weight (lbs): 0.5 Dimensions (in): 9 x 6 x 0.8
ISBN: 059600625X Dewey Decimal Number: 005.54 UPC: 636920006251 EAN: 9780596006259 ASIN: 059600625X
Publication Date: March 24, 2004 Availability: Usually dispatched within 1-2 business days Shipping: International shipping available Condition: Brand New. Shipped from UK Mainland. Delivery is usually 4 - 5 working days from order by Royal Mail, International Delivery is by Airmail.
|
| Similar Items:
|
| Customer Reviews:
Unlock the power of Excel with this book March 23, 2006 38 out of 38 found this review helpful
I have been using Excel for many years now, as a basic user then as a small systems developer. I bought this book about a year ago after reading about it on the Ozgrid website (The authors run the Ozgrid website). This book is an absolutely brilliant collection of tips for things that you may never have known were possible in Excel!The book is split into eight chapters, each chapter containing a number of useful tips explained in easy to understand language and with examples throughout. The chapters are: 1 - Reducing Workbook and Worksheet Frustration A collection of tips to improve your general efficiency using Excel, such as how to enter data into multiple worksheets at once and how to reduce the file size of bloated Excel documents. 2 - Hacking Excel's Built-In Features Tops on advanced uses of Excel's built-in functions that help you wring the absolute best functionality out of them. Includes the likes of hilighting every other row or column, and supporting multiple lists in a combo-box. 3 - Naming Hacks A collection of hacks based on defined names, including probably the most searched for: how to create named ranges that expand and contract automatically to fit the data. 4 - Hacking PivotTables Starts with an explanation of PivotTables and how to use them, then goes intoa few tips on more advanced usage such as automating pivot-table creation. 5 - Charting Hacks Some great hacks in here, including how to put two different styles on one chart (ie a bar chart with a line chart overlayed), and how to create pivot-table like functionality with basic charts. 6 - Hacking Formulas and Functions The largest chapter in the book, this section deals with a whole host of useful formulae and functions you can use in your spreadsheets, such as how to display negative time values and hacking vlookup to work over multiple tables. 7 - Macro Hacks A collection of VBA tips including how to speed up your code, and creating splash screens. This is the weakest part of the book, and I feel VBA should have been left for a seperate book entirely. 8 - Connecting Excel to the World A small collection of hacks based on data transfer to and from Excel, including XML. The XML tips are only applicable to windows Excel 2003 and later. As mentioned earlier I have had this book for about a year and I still find myself referring to it for some more advanced uses. If you use Excel regularly, particularly if you use it for analysing data or producing reports, this book is an absolute *must have* for your desktop library!
|
|
| Site powered by Amazon.co.uk | |