Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | July 14, 2015

    Joshua Mohr: IMG Your Imagination, Your Fingerprint



    When I was in grad school, a teacher told our workshop that if a published novel is 300 pages, the writer had to generate 1,200 along the way. I... Continue »
    1. $17.50 Sale Hardcover add to wish list

      All This Life

      Joshua Mohr 9781593766030

    spacer

Excel Hacks : Tips & Tools for Streamlining Your Spreadsheets (2ND 08 Edition)

by

Excel Hacks : Tips & Tools for Streamlining Your Spreadsheets (2ND 08 Edition) Cover

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks — clever tools, tips and techniques — that will leapfrog your work beyond the ordinary.

Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:

  • Reduce workbook and worksheet frustration — manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
  • Analyze and manage data — extend and automate these features, moving beyond the limited tasks they were designed to perform.
  • Hack names — learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
  • Get the most out of PivotTables — avoid the problems that make them frustrating and learn how to extend them.
  • Create customized charts — tweak and combine Excel's built-in charting capabilities.
  • Hack formulas and functions — subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
  • Make the most of macros — including ways to manage them and use them to extend other features.
  • Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.
You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Book News Annotation:

This reference provides about 130 hacks--quick and dirty solutions to common problems--for getting the most out of Excel 2007 (and later versions). Arrangement is in chapters on reducing workbook and worksheet frustration, Excel's built-in features, naming, PivotTables, charting, hacking formulas and functions, macro hacks, and cross-application hacks. Readers can use the hacks directly as they build and improve spreadsheets, or they can study them, learn some Visual Basic for Application code, and customize the hacks for their own purposes. Step-by-step instructions, code, and screenshots are included. The authors are Excel consultants and trainers in Australia. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Excel 2007 promises great new power for users if they can find the secrets. This compendium of power-user tricks can help readers squeeze more out of every aspect of Excel, from the new interface to new features.

About the Author

David Hawley of Perth, Australia is a professional Microsoft Excel consultant whose company, OzGrid Business Applications, offers services in all aspects of Excel, and VBA for Excel. The company's web site at www.ozgrid.com provides online and email Excel training, a directory of useful Excel add-ins, a user forum, and lots of tips and tricks.

Raina Hawley of Perth, Australia is a professional Microsoft Excel consultant whose company, OzGrid Business Applications, offers services in all aspects of Excel, and VBA for Excel. The company's web site at www.ozgrid.com provides online and email Excel training, a directory of useful Excel add-ins, a user forum, and lots of tips and tricks. Raina is also a lecturing team member at West Australian Institute of Management (WAIM) with specific expertise in Word, Excel, Powerpoint, Internet and email.

Table of Contents

DedicationCreditsPrefaceChapter 1: Reducing Workbook and Worksheet FrustrationChapter 2: Hacking Excel's Built-in FeaturesChapter 3: Naming HacksChapter 4: Hacking PivotTablesChapter 5: Charting HacksChapter 6: Hacking Formulas and FunctionsChapter 7: Macro HacksChapter 8: Cross-Application HacksColophon

Product Details

ISBN:
9780596528348
Author:
Hawley, David
Publisher:
O'Reilly Media
Author:
Hawley, Raina
Author:
Hawley, David
Subject:
Spreadsheets - Excel
Subject:
Business
Subject:
Electronic spreadsheets
Subject:
Business -- Computer programs.
Subject:
Spreadsheets - General
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Excel;Microsoft;Office;desktop application;formulas;pivot table;spreadsheet;worksheets
Subject:
CourseSmart Subject Description
Edition Number:
2
Edition Description:
Second Edition
Series:
Hacks
Publication Date:
20070631
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
412
Dimensions:
9 x 6 x 1.03 in 1.21 lb

Other books you might like

  1. Access Hacks New Trade Paper $34.99
  2. Retire on Less Than You Think: The... Used Trade Paper $5.95
  3. Visual Explanations
    Used Hardcover $19.95
  4. Self-Working Rope Magic: 70... New Trade Paper $6.95
  5. Special Edition Using Microsoft... Used Trade Paper $4.25
  6. Made to Stick: Why Some Ideas...
    Used Hardcover $9.50

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel Hacks : Tips & Tools for Streamlining Your Spreadsheets (2ND 08 Edition) Used Trade Paper
0 stars - 0 reviews
$15.00 In Stock
Product details 412 pages O'Reilly Media - English 9780596528348 Reviews:
"Synopsis" by ,
Excel 2007 promises great new power for users if they can find the secrets. This compendium of power-user tricks can help readers squeeze more out of every aspect of Excel, from the new interface to new features.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.