A recommended book for Excel tips

Topic

New Reply

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

Reply | Quote

Replies

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

..

Reply | Quote

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!
Computer Specs

Reply | Quote

Hi,

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

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

Good Luck!

Peter Moran

Reply | Quote

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 Rig: AMD Ryzen 9 5900X 12-Core CPU; ASUS Cross Hair VIII Formula Mobo; Win 11 Pro (64 bit)-(UEFI-booted); 32GB RAM; 2TB Corsair Force Series MP600 Pro 2TB PCIe Gen 4.0 M.2 NVMe SSD. 1TB SAMSUNG 960 EVO M.2 NVME SSD; MSI GeForce RTX 3090 VENTUS 3X 24G OC; Microsoft 365 Home; Condusiv SSDKeeper Professional; Acronis Cyberprotect, VMWare Workstation Pro V17.5. HP 1TB USB SSD External Backup Drive). Dell G-Sync G3223Q 144Hz Monitor.

Reply | Quote