Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2010
    Location
    Israel
    Posts
    87
    Thanks
    18
    Thanked 0 Times in 0 Posts
    I've just finished a course in Excel, and am looking to start working with it full time. However, I know that Excel is a very powerful program with a huge number of tips & tricks to simplify and make your work more productive, and to teach you all of Excel's capabilities in the long run. I know there is a lot of info on the web but I prefer a book, or a few books.

    I mean here Excel 2010, but 2007 will also suffice.

    Anyone here knows and can recommend such a book?

    TIA

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    There are lots of choices.

    This may be worth a look ....
    Microsoft Excel Training Courses
    On the right hand side under the blue button "Free Training Manuals", are a couple of freebies for 2003-2010. Download and enjoy.

    Here are some more choices
    Amazon Excel books

    ..

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    rfe777,

    Here are three of my faviorites:

    "Excel Hacks, 100 Industrial-Strength Tips & Tools", David & Raina Hawley, O'Reilly, ISBN: 0-596-00625-x
    "Excel Gurus Gone Wild", Bill Jelen, Holy Macro! Books, ISBN: 978-1-932802-40-5
    "Spreadsheet Check and Control", Patrick O'Beirne, ISBN: 1-905404-00-X

    And don't forget the Windows Secrets Excel Lounge!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi,

    You could not go past Jonh Walkenbach and his books at:

    http://spreadsheetpage.com/index.php/books

    Good Luck!

    Peter Moran

  5. #5
    5 Star Lounger petesmst's Avatar
    Join Date
    Dec 2009
    Location
    Cape Town, South Africa
    Posts
    789
    Thanks
    38
    Thanked 43 Times in 33 Posts
    You can't go wrong with O'Reilly Media's excellent "Excel 2010: The Missing Manual" Available via the following link as a printed book, or an e-book (useful hyperlinks aid navigation through the e-book):

    http://oreilly.com/catalog/0636920001850/

    Purchasing the product also provides free access to the "missing CD" which contains shareware and example files referred to in the Manual.

    Here is an extract from the web page:

    Description
    "Fast-paced and easy to use, this guide shows you how to get the most out of Excel 2010. You'll learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. With clear jargon-free explanations, step-by-step instructions, tons of illustrations, and lots of undocumented tips and shortcuts, you'll get hands-on guided tours and explanations of Excel's new features.

    Full Description

    Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.

    •Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
    •Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
    •Organize your data. Search, sort, and filter huge amounts of information
    •Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
    •Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
    •Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
    •Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save"


    Good luck: You have been provided with quite a selection to choose from in the foregoing posts!!

    (Edit: Corrected spelling error)
    (My Setup: Custom built: 3,70GHz Intel Core i7-4820K CPU; MSI Military Class iii X79A-GD45 Plus Motherboard; Win 10 Pro (64 bit) - (UEFI-booted); 16GB RAM; 512GB SAMSUNG SD850 PRO SSD; 120GB SAMSUNG 840 SSD; Seagate 2TB Barracuda SATA6G HDD; GeForceGTX 980 4GB Graphics Card; Office 2013 Prof (32-bit); MS Project 2013 (32-bit); Acronis TI 2015 Premium, NIS 2016, VMWare Workstation12 Pro, etc). WD My Book 3 1TB USB External Backup Drive). Samsung 24" Curved HD Monitor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •