Microsoft Excel Resources

A clearly written, no-nonsense guide that is just what I needed.

– From a review of Excel for Beginners by Opossum on Amazon.com dated December 1, 2017.

Books:

Note: If you shop on Amazon, this link will take you to the M.L. Humphrey author page where you can find all of the books listed below. Otherwise you can click on a book image to be taken to a page to choose your store for your country for that book or you can choose the store-specific page on the right-hand side and click on the book you want to be taken to that book in that store.

If you just want to learn the basics you need to know to use Excel on a daily basis, then start with Excel for Beginners. ($4.99 USD in ebook, $12.95 USD in paperback, $19.95 USD in hard cover)

Excel for Beginners open sans boldv2Find a store, Amazon US, Barnes & Noble, Kobo US, Google, Buy Direct with Paypal

If you already know the basics and want to learn about more advanced topics such as pivot tables, charts, conditional formatting, and more then try Intermediate Excel. If you want to learn about how to use formulas and functions in Excel, then try 50 Useful Excel Functions or 50 More Excel Functions. ($5.99 USD in ebook, $12.95 USD in paperback, $19.95 USD in hard cover)

Intermediate Excel Open Sans50 Excel Functions open sans50 More Excel Functions open sans

 

 

 

 

 

 

 

And if you’re ready to just dive in and read all four books at once, then your best bet is Excel Essentials.

Excel Essentials 20190222If what you’d rather do is test your knowledge of Excel then each of the above titles has a quiz book associated with it that includes questions as well as five bonus exercises. ($3.99 USD in ebook for the individual titles, $9.99 USD in paperback for the individual titles and $9.99 USD in ebook and $21.99 in paperback for The Excel Essentials Quiz Book)

Excel for Beginners Quiz Book 20181202Intermediate Excel Quiz Book 2018120250 Functions Quiz Book 20181202The-50-More-Excel-Functions-Quiz-Book-GenericThe-Excel-Essentials-Quiz-Book-Generic

 

 

 

 

And if you just need information on one specific topic, like Pivot Tables, then the Easy Excel Essentials series contains excerpts from the Excel Essentials titles on specific topics. ($2.99 USD in ebook, $5.99 USD in paperback)

Pivot Tables open sansConditional Formatting open sansCharts open sansIf Functions open sansFormatting open sansPrinting open sans

 

 

 

 

You can also purchase one of the following specialty Excel titles as well as their associated template. (Templates are Excel files and only available from the Payhip store.)

Excel for Writers open sans

Excel for Writers excel template

Excel for SP open sansExcel for SP Excel TemplateExcel for Budgeting open sansExcel for Budgeting excel template

 

 

 

 

And if you have an interest in budgeting, Word, or PowerPoint these titles are available as well:

Word for Beginners open sansIntermediate Word open sansWord-Essentials-KindleMail MergeData Principles for BeginnersBudgeting for Beginners open sansPowerPoint-for-Beginners-Generic

Intermediate-PowerPoint-Generic

PowerPoint-Essentials-Kindle

Blog Posts:

This site also contains the following blog posts that may be of interest to you:

Excel, Word, and PPT Books Now in Hard Cover

Data Principles for Beginners (new release notice)

A Quick Excel Copy and Paste Trick

How to Count TRUE or FALSE Entries in a Range

A Little Reminder on Backwards Compatibility

Using Excel for an Optimization Problem

How to Split a Cell Diagonally in Excel

The Excel PRODUCT Function

Excel for Budgeting is Live

Excel Essentials Quiz Books Now Available

A New Release: 50 More Excel Functions