Free Downloads
Excel Hacks: 100 Industrial-Strength Tips And Tools

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.

Paperback: 304 pages

Publisher: O'Reilly Media; 1st edition (March 1, 2004)

Language: English

ISBN-10: 059600625X

ISBN-13: 978-0596006259

Product Dimensions: 6 x 0.7 x 9 inches

Shipping Weight: 8 ounces

Average Customer Review: 4.4 out of 5 stars  See all reviews (23 customer reviews)

Best Sellers Rank: #1,209,113 in Books (See Top 100 in Books) #212 in Books > Computers & Technology > Software > Accounting #493 in Books > Computers & Technology > Software > Microsoft > Microsoft Excel #688 in Books > Computers & Technology > Internet & Social Media > Hacking

Microsoft Excel is an extremely powerful tool. Yet most users have only scratched the surface of its power, using only a small part of its capabilities.Excel Hacks: 100 Industrial-Strength Tips & Tools by David & Raina Hawley, shows readers how to do more, and how to do things better, with the market-leading spreadsheet. The word "hack" here refers to its original meaning in computers. A hack was either a "quick and dirty solution" or a "clever way of doing things", and didn't refer to breaking into systems. This book presents 100 different hacks spread over eight categories, covering the basics; built-in features; naming hacks; pivot tables; charts; formulas and functions; macros; and connecting Excel to the rest of the world.Individually, none of these hacks may cause you to run down the street shouting "Eureka", but together they should help just about every Excel user. I consider myself an expert user, working with spreadsheets for over twenty years and teaching classes in Excel and 1-2-3, yet I was still able to learn a lot from this book. In some cases, it was genuinely new information (Hack #50, Explode a Single Slice from a Pie Chart or Hack #99, Access SOAP Web Services from Excel). In other cases, it showed how to use a tool I knew about in some different way (Hack #41, Create Custom Functions Using Names or Hack #78, Construct Mega-Formulas). A couple of times, it served as a reminder to use some tool that I had been neglecting (Hack #6, Customize the Template Dialog and Default Workbook).Some of the hacks are usability tips, showing how other tools (such as pivot tables) will be more useful if you lay out data in a certain way. Several tips help if you develop spreadsheets for others to use, limiting their capacity to screw things up.

Excel Hacks: 100 Industrial-Strength Tips and Tools Prepper's Hacks: 15 Outstanding Prepper's Hacks For Surviving Volcanic Eruptions (Prepper's Hacks, Preppers Hacks, Preppers Hacks books) Excel: The Complete Beginners Guide - Boost Your Poductivity And Master Excel In Just 24 Hours! (Excel, Microsoft Office, MS Excel 2016) Organized Home: How to Clean Your House Fast and Stress-free.Practical Tips and Life Hacks for Busy People (Declutter,DIY Hacks,Home Organization) Evaluation of Industrial Disability: Prepared by the Committee of the California Medical Association and Industrial Accident Commission of the State ... of Joint Measures in Industrial Injury Cases. Excel Conditional Formatting: Tips You Can Use Immediately To Make Your Data Stand Out (Data Analysis With Excel Book 3) Perl Hacks: Tips & Tools for Programming, Debugging, and Surviving RV: RV Living For Beginners: Simple Tools, Tips & Hacks To Make Debt Free, Full Time Motorhome Living As Stress Free And Enjoyable As Possible (Tiny house, ... Live In Car, Van) (RV Boondocking Book 2) PHP Hacks: Tips & Tools For Creating Dynamic Websites Retro Gaming Hacks: Tips & Tools for Playing the Classics Nokia Smartphone Hacks: Tips & Tools for Your Smallest Computer Ajax Hacks: Tips & Tools for Creating Responsive Web Sites Cheap and Functional DIY Box Set (6 in 1): Creative, Budget-Friendly Quick and Easy DIY Prepper Projects, Household Hacks, Decorating Ideas and Outdoor Designs (DIY Projects & Household Hacks) 365 Days of Decluttering and Organizing Your Home: DIY Household Hacks, DIY Declutter and Organize, DIY Projects, DIY Crafts, DIY Books, DIY Cookbook, ... Home Improvement (DIY Hacks Book 1) Prepper's Survival Pantry: The Ultimate SHTF Preparedness Guide To Canning, Dehydrating And Emergency Water And Food Storage (Prepper Hacks, DIY Hacks, ... Survival Needs, Hack It, Prepare Your,) EXCEL: Strategic Use of the Calc Spreadsheet in Business Environment. Data Analysis and Business Modeling (Functions and Formulas, Macros, MS Excel 2016, Shortcuts, Microsoft Office) 365 Days of DIY Hacks - Home, Parenting, Pets, Gifts, Budged: (DIY Household Hacks, DIY Declutter and Organize, DIY Projects, DIY Crafts, DIY Books, DIY Gift, Do It Yourself, Home Improvement, Kids) Organize Your Home in Five Days: Easy Hacks to Declutter Your Space, Create a Positive Environment & Get Inspiration Back to Your Life (UPDATED AND EXPANDED!) (DIY Hacks & Home Organization) Excel VBA Programming: Learn Excel VBA Programming FAST and EASY! (Programming is Easy Book 9) Aprender fórmulas y funciones con Excel 2010 con 100 ejercicios prácticos (Aprender... con 100 ejercicios prácticos) (Spanish Edition)