SiteHQ

SiteHQ

reliable & professional hosting packages to suit all budgets

Search Advanced SearchView Cart   

Excel Hacks: 100 Industrial Strength Tips and Tools

Excel Hacks: 100 Industrial Strength Tips and Tools

zoom 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: 5.0 out of 5 stars 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:

  • Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
  • Excel VBA Programming for Dummies
  • VBA and Macros for Microsoft Excel (Business Solutions)
  • Pivot Table Data Crunching (Business Solutions)
  • Word Hacks: Tips & Tools for Taming Your Text

Customer Reviews:

5 out of 5 stars 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
Categories
Books
Computers
Software