woodys-uk
Price: £25.20
In stock

10 used & new from £12.15

Have one to sell? Sell yours here
 
 
Excel Hacks: 100 Industrial Strength Tips and Tools
 
 

Excel Hacks: 100 Industrial Strength Tips and Tools (Paperback)

by Raina Hawley (Author), David Hawley (Author)
5.0 out of 5 stars  See all reviews (2 customer reviews)

Available from these sellers.


5 new from £18.95 5 used from £12.15

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   Excel Consulting opens new browser window
www.eppert-Consulting.com  -  Spreadsheets Macros Add ins and VBA programs for business needs 
   Excel Tools opens new browser window
Become.co.uk  -  Huge deals from thousands of top- stores. Compare prices and Save. 
   Gage Bilt Rivet Tools opens new browser window
www.GageBilt.com  -  Manufacturer of Rivet Guns & Tools Commercial and Aerospace 
  
 

Customers Who Bought This Item Also Bought

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

by Rob Bovey
4.9 out of 5 stars (19)  £20.29
Excel VBA Programming for Dummies

Excel VBA Programming for Dummies

by John Walkenbach
4.5 out of 5 stars (19)  £8.47
VBA and Macros for Microsoft Excel (Business Solutions)

VBA and Macros for Microsoft Excel (Business Solutions)

by Bill Jelen
3.8 out of 5 stars (5)  £14.47
Access Hacks: Tips & Tools for Wrangling Your Data: Tips and Tools for Wrangling Your Data

Access Hacks: Tips & Tools for Wrangling Your Data: Tips and Tools for Wrangling Your Data

by Ken Bluttman
£22.94
Writing Excel Macros with VBA

Writing Excel Macros with VBA

by Steven Roman
4.3 out of 5 stars (3)  £17.73
Explore similar items

Product details

  • Paperback: 304 pages
  • Publisher: O'Reilly Media, Inc.; 1st ed edition (24 Mar 2004)
  • Language English
  • ISBN-10: 059600625X
  • ISBN-13: 978-0596006259
  • Product Dimensions: 22.8 x 15.2 x 2 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon.co.uk Sales Rank: 181,328 in Books (See Bestsellers in Books)

    Popular in this category:

    #68 in  Books > Computing & Internet > Microsoft Windows > Applications > Excel
  • See Complete Table of Contents

Product Description

Product Description

If you think that getting creative with Excel means the underhanded tweaking of numbers, think again. Excel Hacks shows even the most experienced users how to do things with Excel they might never have thought of doing--and lets them have a little fun while they're at it. Microsoft Excel is not just the dominant spreadsheet in the world; it's also one of the most popular applications ever created. Its success lies not only in its power and flexibility, but also in its streamlined, familiar interface that casually conceals its considerable capabilities. You don't need to know everything that Excel can do in order to use it effectively, but if you're like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path. With this book, Excel power users can bring a hacker's creative approach to both common and uncommon Excel topics--"hackers" in this sense being those who like to tinker with technology to improve it. The "100 Industrial Strength Tips and Tools" in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. Excel Hacks will help you increase productivity with Excel and give you hours of "hacking" enjoyment along the way.


From the Publisher

The tips and tools in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful, roll-up-your-sleeves guide shows you new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. Excel Hacks increases productivity with Excel and gives you hours of "hacking" enjoyment along the way.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 


 

Customer Reviews

2 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
38 of 38 people found the following review helpful:
5.0 out of 5 stars Unlock the power of Excel with this book, 23 Mar 2006
By Mr. T. Berriman "berriman_toby" (UK) - See all my reviews
(REAL NAME)      
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!

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
5.0 out of 5 stars Review, 30 Jan 2009
An excellent book to have for those people who are past the intermediate stages of working in excel. It provides lots of helpful tips and tricks that you thought were never possible!

I would most definately seek buying other books similar to this.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.