Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
9 used & new from £12.21

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)
RRP: £17.50
Price: £15.75 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £1.75 (10%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

4 new from £15.75 5 used from £12.21

Frequently Bought Together

Excel Hacks: 100 Industrial Strength Tips and Tools + 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) + Excel VBA Programming for Dummies
Price For All Three: £54.63

Some of these items ship sooner than the others. Show details


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)  £30.39
Excel VBA Programming for Dummies

Excel VBA Programming for Dummies

by John Walkenbach
4.8 out of 5 stars (13)  £8.49
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)  £20.29
Pivot Table Data Crunching (Business Solutions)

Pivot Table Data Crunching (Business Solutions)

by Bill Jelen
5.0 out of 5 stars (1)  £15.39
Excel 2003 Power Programming with VBA

Excel 2003 Power Programming with VBA

by John Walkenbach
4.0 out of 5 stars (3)  £24.47
Explore similar items

Product details


Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Excel Business Solutions
   www.eppert-Consulting.com    Spreadsheets Macros Add ins and VBA programs for business needs 
Excel Tips
   www.the-tutorial-library.com    1500 Excel Tips To Help You Quickly Master Excel - Only $14.75 
Excel Compiler
   www.DoneEx.com    XLS to EXE, copy protection of your XLS with regkey and hardware lock. 
  
 

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.

See all Product Description

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.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below
(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
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

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

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

   


Listmania!


Look for similar items by category


Feedback


The Body Shop

The Body Shop - Vitamin C Skin Boost
Protect and boost your glow with The Body Shop Vitamin C Skin Boost.

Shop The Body Shop

 

More From David E. Hawley

Excel Hacks: Tips...

Excel Hacks: Tips & Tools for...

Millions of users create and share Excel spreadsheets every day, but... Read more
£22.99 £16.09

 

Boys Smell

Lynx Africa Body Spray and After Shave Gift set
But we make sure they smell good...

Discover male grooming at Amazon.co.uk

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

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

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates