Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2010
    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?


  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    East Coast, USA
    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
    Manning, South Carolina
    Thanked 1,608 Times in 1,452 Posts

    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!


    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 0 Times in 0 Posts

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

    Good Luck!

    Peter Moran

  5. #5
    5 Star Lounger petesmst's Avatar
    Join Date
    Dec 2009
    Cape Town, South Africa
    Thanked 51 Times in 40 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):

    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:

    "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: 4.00GHz Intel Core i7-6700K CPU; MSI Z170A Gaming Carbon Mobo (Military Class V); Win 10 Pro (64 bit)-(UEFI-booted); 16GB RAM; 500GB SAMSUNG 960 EVO M.2 NVME SSD; 512GB SAMSUNG 850 PRO SSD; Seagate 2TB Barracuda SATA6G HDD; 2 X GeForceGTX 1070 8GB Graphics Card (SLI); Office 2016 Prof "Click to Run" (32-bit); Acronis TI 2017 Premium, Norton Internet Security, VMWare Workstation12 Pro). 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